We're trying to use the MSSQL connector to transfe...
# ask-community-for-troubleshooting
s
We're trying to use the MSSQL connector to transfer several large tables (100M - 1B rows) to Snowflake. The initial sync is timing out, and it looks like the temp files + logs are filling up storage on our VM. Can anyone point me towards best practices / recommendations for managing the initial load of large tables from MSSQL?
k
A message from kapa.ai
Hmm, I don't know enough to give you a confident answer yet. However, you can refer to the [Airbyte tutorial on replicating Microsoft SQL Server to Snowflake](https://airbyte.com/tutorials/replicate-microsoft-sql-server-to-snowflake) for general guidance on setting up the connection and syncing data. For more advanced scaling and performance considerations, you can check the [Airbyte scaling guide](https://docs.airbyte.com/operator-guides/scaling-airbyte).
s
On further investigation, this looks like a bug. I've raised an issue here: https://github.com/airbytehq/airbyte/issues/26932