cancel
Showing results for 
Search instead for 
Did you mean: 
Data Engineering
Join discussions on data engineering best practices, architectures, and optimization strategies within the Databricks Community. Exchange insights and solutions with fellow data engineers.
cancel
Showing results for 
Search instead for 
Did you mean: 

Error when trying to run model in staging

haroon_24
New Contributor

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


2 REPLIES 2

Walter_C
Databricks Employee
Databricks Employee

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?

select
   *
from
    {{ source('tpch', 'orders') }}

Connect with Databricks Users in Your Area

Join a Regional User Group to connect with local Databricks users. Events will be happening in your city, and you won’t want to miss the chance to attend and share knowledge.

If there isn’t a group near you, start one and help create a community that brings people together.

Request a New Group