Document best practices when building connectors

[hariso]

Feature description

With the many connectors we've written over time, I think we can share some good advice when it comes to writing connectors (setup, snapshots vs CDC in sources, consistent snapshots, different CDC methods, handling keys, positions, etc.).

[raulb]

We should make sure we also include a way to test them. See discussion here.