Hi everyone, I'm new to elementary and I'm getting...
# community-support
l
Hi everyone, I'm new to elementary and I'm getting this error: 'WithCTE :- 'CTERelationDef 1, false : +- 'SubqueryAlias buckets_with_existing_metrics : +- 'Distinct : +- 'Project ['bucket_start, 'bucket_end] : +- 'Filter ((('bucket_start >= date_trunc(day, cast(2025-03-28 000000 as timestamp), Some(UTC))) AND ('bucket_end <= cast(2025-04-11 070049.443026+00:00 as timestamp))) AND (('upper('full_table_name) = upper(PRD_INT.STO)) AND ('metric_properties = cast({"dimensions": ["zugstandortmeldungstyp", "COUNT(*) * 1.0 / SUM(COUNT(*)) OVER ()"], "event_timestamp_column": null, "freshness_column": null, "time_bucket": {"count": 1, "period": "day"}, "timestamp_column": "created", "where_expression": null} as string)))) : +- 'UnresolvedRelation [None], [], false Why is there an UnresolvedRelation? How can I troubleshoot this?
👀 1
n
Hey Luiza! What DWH are you using? 🙂 Making sure, does this table exist in your
dbt_models
table in the Elementary schema?
l
The Table STO existis in the schema PRD_INT. It is possible that i need a small database where elementary can do things ?
n
Sorry, my phrasing wasn't clear 🙂 Are Elementary tables placed in an Elementary schema in your DWH? If so, does the table
dbt_models
contain a row that's the table you're testing?
l
I dont really know. Is there a support chanel to call so that i can show you my problem ?
n
Hey Luiza, would you like to hop on a call tomorrow to look into this? 🙂
l
Yes, that would be great. I'm new to the topic and could need some help.