dbt Analytics Engineering Certification

Question

Consider the following source configuration:

sources:  
  - name: jaffle_shop  
    schema: jaffle_shop_raw_current  
    tables:  
      - name: orders  
        identifier: customer_orders

Which source reference is correct?

Explanation

The source() function takes the declared source name and table name: jaffle_shop and orders. The schema and identifier properties specify the corresponding database schema and physical table name. (docs.getdbt.com)

Learn more

dbt Analytics Engineering Certification

AstroTutor

Notes

Readiness

QuestionQ53

Community Discussion