Open jrlegrand opened 1 month ago
Moving from PostgreSQL to BigQuery means we will definitely find SQL that throws errors d/t the different systems.
We need to identify these areas and modify the SQL to match BigQuery and then TEST to make sure it doesn't break existing marts, etc.
All dbt models run in BigQuery.
Run whatever the command is for a full dbt refresh and monitor for errors.
One way we know BigQuery is significantly different is how it handles dates: https://cloud.google.com/bigquery/docs/reference/standard-sql/date_functions
Problem Statement
Moving from PostgreSQL to BigQuery means we will definitely find SQL that throws errors d/t the different systems.
We need to identify these areas and modify the SQL to match BigQuery and then TEST to make sure it doesn't break existing marts, etc.
Criteria for Success
All dbt models run in BigQuery.
Run whatever the command is for a full dbt refresh and monitor for errors.
Additional Information
One way we know BigQuery is significantly different is how it handles dates: https://cloud.google.com/bigquery/docs/reference/standard-sql/date_functions