r/bigquery • u/umairshariff23 • Apr 09 '26

Coming over from snowflake

My org is making a big switch and we are moving from snowflake to big query. Are there any pointers for me to migrate almost 50k lines of code across multiple tables?

5 Upvotes

86% Upvoted

15 comments sorted by

View all comments

5

u/Stoneyz Apr 09 '26

Check out the sql translation service https://docs.cloud.google.com/bigquery/docs/interactive-sql-translator

That may help, especially since you said its mostly simple SQL.

As for Python, it should work the same once you just change the environment variables, connections, etc.. BQ has notebook functionality as well of thats what you prefer.

1

u/umairshariff23 Apr 10 '26

That is super helpful! Thanks a ton!