data-engineering

data-engineering copied to clipboard

Hi @GokuMohandas, I have followed your course to use dbt to transform data.

At the step with writing query to join two tables projects and tags together with this code in the file dbt_transforms/models/labeled_projects/labeled_projects.sql:

SELECT p.id, created_on, title, description, tag
FROM `made-with-ml-359923.mlops_course.projects` p
LEFT JOIN `made-with-ml-359923.mlops_course.tags` t
ON p.id = t.id

I'm getting this error: Name id not found inside t at [9:13]

I believe the cause is there is no column id in the tags table so when I query on this line ON p.id = t.id, it throws this error. I also tested in BigQuery and it throws the same error.