Our project is getting migrated from oracle DWH to big query. Being a data QA (using dbt), I would like to compare the data (by creating models) between Oracle data warehouse (on prem tables) and Bigquery tables (cloud) after successful migration. Can we connect to both the sources (Oracle & Bigquery) at a time ?
Is it possible to connect to both Oracle and BigQuery at once from dbt so that i can create models and compare the data using tests?
It’s not possible comparing oracle tables with bigquery tables in dbt
2 posts were split to a new topic: Does dbt support oracle exadata?
dbt issues commands to your warehouse on your behalf, and works inside of a single warehouse at a time. Since there’s not a native way to query a Oracle database from inside of BQ, dbt can’t make that happen for you either.