Hi! I have tried searching the documentation but c...
# ask-community-for-troubleshooting
p
Hi! I have tried searching the documentation but couldn't find an answer - what is the most optimal way to sync a lot of tables from a single database? Should I just setup a single connection, multiple connections based on table size and table priorities (e.g. have all the small tables in a single connection, have an important table separately) or have a connection for each table? Also, we are planning on orchestrating through Airflow so I could document which connection is which through there but what is the recommended best practice to documment connections in general?
1
u
I saw some users with the pattern: small tables in a single connection and individual connection for priority/large tables.
👍 1
p
Thanks!