Solved: Snowflake to BigQuery migration

Nikita_G

Could anyone please help me understand the following:
I need to migrate data from Snowflake to BigQuery using the BigQuery Data Transfer Service. Is this possible? Is there any documentation available on how to migrate data from Snowflake to BigQuery using the BigQuery Data Transfer Service? Additionally, is it available for on-premise setups? In what scenarios would on-premise Snowflake be useful?

ms4446

Hi @Nikita_G ,

BigQuery doesn't currently support using Data Transfer Service with Snowflake. This means you'll need to use an alternative migration strategy. Google Cloud provides an excellent documentation on Snowflake to BigQuery migration This guide covers schema changes, available tools, a sample export process, and even SQL translation options.

View solution in original post

ms4446

Hi @Nikita_G ,

BigQuery doesn't currently support using Data Transfer Service with Snowflake. This means you'll need to use an alternative migration strategy. Google Cloud provides an excellent documentation on Snowflake to BigQuery migration This guide covers schema changes, available tools, a sample export process, and even SQL translation options.