issue in data engineering lesson

[akashsonowal]

Hi @GokuMohandas,

I was trying to run the data engineering lessons in my local.

The tags dataset don't have id column so inside dbt cloud development when we run this sql code, it throws an error as tags doesn't have id. Please correct me if am missing something.

-- models/labeled_projects/labeled_projects.sql SELECT p.id, created_on, title, description, tag FROMmade-with-ml-XXXXXX.mlops_course.projectsp -- REPLACE LEFT JOINmade-with-ml-XXXXXX.mlops_course.tagst -- REPLACE ON p.id = t.id

[teddythinh]

I get the same error too, I don't know if the query p.id = t.id is true or not.

[Shyam4801]

Looks like there is no id column in datasets/tags.csv. Hence the error