C4W1 - dbt lab dim_dates error

Course Q&A Data Engineering Data Modeling, Transformation, and Serving
, , ,
1

I ran into an error when calling function dbt_date.get_date_dimension in date.sql. “Database Error in model dates (models/star_schema/dates.sql)
invalid input syntax for type timestamp: “YYYY-MM-DD”
LINE 5: ((cast(‘YYYY-MM-DD’ as timestamp))::date - (cast('YY…”

2

Issue fixed after entering valid dates from 2003 to 2005.

1 Like