issue in data engineering lesson #54

New Issue

GiteaMirror · 2025-11-02T00:02:35-05:00

GiteaMirror commented

2025-11-02 00:02:35 -05:00

Originally created by @akashsonowal on GitHub (Sep 17, 2023).

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 FROM made-with-ml-XXXXXX.mlops_course.projectsp -- REPLACE LEFT JOINmade-with-ml-XXXXXX.mlops_course.tags t -- REPLACE ON p.id = t.id

Originally created by @akashsonowal on GitHub (Sep 17, 2023). 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 FROM `made-with-ml-XXXXXX.mlops_course.projects` p -- REPLACE LEFT JOIN `made-with-ml-XXXXXX.mlops_course.tags` t -- REPLACE ON p.id = t.id`

GiteaMirror commented

2025-11-02 00:02:37 -05:00

@teddythinh commented on GitHub (Dec 25, 2023):

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

@teddythinh commented on GitHub (Dec 25, 2023): I get the same error too, I don't know if the query `p.id = t.id` is true or not.

GiteaMirror commented

2025-11-02 00:02:38 -05:00

@Shyam4801 commented on GitHub (Jun 30, 2024):

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

@Shyam4801 commented on GitHub (Jun 30, 2024): Looks like there is no id column in datasets/tags.csv. Hence the error

GiteaMirror referenced this issue

2025-11-02 00:05:20 -05:00