dbt Analytics Engineering · Debugging data modeling errors

While running dbt run, you see the following error in your terminal: Compilation Error in model dim_customers (models/marts/dim_customers.sql) 'customer_id' is ambiguous. This is happening because the column is present in more than one table used in this query. Your model joins stg_customers and stg_orders, and both tables have a customer_id column. What is the most direct fix?

• AAdd a unique_key config to the model so dbt resolves the column ambiguity automatically.
• BWrap both table references in ref() instead of hardcoding table names.
• CRebuild the model with dbt run --full-refresh to force dbt to regenerate the compiled SQL.
• DQualify customer_id with a table alias (or rename one instance) in the SELECT list so the compiled SQL references only one source column.