Error when trying to run model in staging

haroon_24 — Thu, 19 Dec 2024 09:32:54 GMT

i am learning dbt and pache airflow i am using the samples catalog and tpch schema/database

when i try to run a sql query in my staging folder I get this error - I am using the premium trial version for databricks
09:30:21 Running with dbt=1.8.8
using legacy validation callback
09:30:28 Registered adapter: databricks=1.8.0
09:30:30 [WARNING]: Configuration paths exist in your dbt_project.yml file which do not apply to any resources.
There are 1 unused configuration paths:
- models.datapipeline.marts
09:30:31 Found 3 data tests, 1 model, 2 sources, 701 macros
09:30:31
09:30:39 Concurrency: 1 threads (target='dev')
09:30:39
09:30:39 1 of 1 START sql view model tpch.stg_tpch_orders ............................... [RUN]
09:30:41 1 of 1 ERROR creating sql view model tpch.stg_tpch_orders ...................... [ERROR in 1.96s]
09:30:42
09:30:42 Finished running 1 view model in 0 hours 0 minutes and 11.41 seconds (11.41s).
09:30:42
09:30:42 Completed with 1 error and 0 warnings:
09:30:42
09:30:42 Runtime Error in model stg_tpch_orders (models\staging\stg_tpch_orders.sql)
[UC_COMMAND_NOT_SUPPORTED.WITHOUT_RECOMMENDATION] The command(s): Create sample tables/views are not supported in Unity Catalog. SQLSTATE: 0AKUC
09:30:42
09:30:42 Done. PASS=0 WARN=0 ERROR=1 SKIP=0 TOTAL=1

Re: Error when trying to run model in staging

Walter_C — Thu, 19 Dec 2024 11:43:12 GMT

The error indicates that the command you are trying to run is not supported in UC, can you please share what is the SQL command you are currently running?

Re: Error when trying to run model in staging

haroon_24 — Thu, 19 Dec 2024 14:41:10 GMT

select

from

topic Error when trying to run model in staging in Data Engineering

Error when trying to run model in staging

Re: Error when trying to run model in staging

Re: Error when trying to run model in staging