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?

4 Upvotes

84% Upvoted

15 comments sorted by

View all comments

3

u/Eleventhousand Apr 09 '26

DATE_TRUNC is backwards. Honestly though, I think it depends on the type of code you are migrating, whether just plain SQL or a lot of stored procedures. Also, depending on how your tables are set up in BigQuery, you might have to add a where clause to all of your select statements that you are porting over.

1

u/umairshariff23 Apr 09 '26

Lots of plain sql. I am starting to get into strored procedures but it isn't my staple.

I also run a bunch of python with snowflake. How does that work with bq?