How to make good sense of how to connect to and reference dbt sources, for example referencing 'dbt-tutorial' following dbt BigQuery set up guidelines?

Help
1

WHERE IS THE ‘dbt-tutorial’ NAME REFERENCED (AS A SOURCE NAME) IN BiqQuery OR IN dbt?

A major deficiency for dbt is managing data sources, starting with connecting to and referencing data sources.

To set up a BigQuery source for dbt, the guide Quickstart for dbt Cloud and BigQuery | dbt Developer Hub covers the following:

A.

Create BigQuery datasets​

  1. Verify that you can run SQL queries. Copy and paste these queries into the Query Editor:
select * from `dbt-tutorial.jaffle_shop.customers`;select * from `dbt-tutorial.jaffle_shop.orders`;select * from `dbt-tutorial.stripe.payment`;

However, searching BigQuery Explorer for ‘dbt-tutorial’ finds 0 results. Where should it be found?

B.

Recommended dbt sql code includes 'select * from dbt-tutorial.jaffle_shop.customers

However, where is naming reference for ‘dbt-tutorial’ found?

1 Like