Error when trying to run model in staging
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-19-2024 01:32 AM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-19-2024 03:43 AM
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?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-19-2024 06:41 AM
![](/skins/images/97567C72181EBE789E1F0FD869E4C89B/responsive_peak/images/icon_anonymous_message.png)
![](/skins/images/97567C72181EBE789E1F0FD869E4C89B/responsive_peak/images/icon_anonymous_message.png)