Hi, I’m using the nessie catalog and when i’m trying to create a table in it, I’m getting the following error:
error log
1 of 1 START sql table model catalog.catalog_folder.my_first_dbt_model … [RUN]
1 of 1 ERROR creating sql table model catalog.catalog_folder.my_first_dbt_model [ERROR in 1.72s]
Finished running 1 table model in 0 hours 0 minutes and 3.26 seconds (3.26s).
Completed with 1 error and 0 warnings:
Runtime Error in model my_first_dbt_model (models/example/my_first_dbt_model.sql)
ERROR: Version context for entity catalog.catalog_folder.my_first_dbt_model must be specified using AT SQL syntax
So, I update the files as below but still getting the above error.
dbt_project.yml
models:
unique_apa_dbt:
# Config indicated by + and applies to all files under models/example/
example:
+version: “BRANCH main”
+object_storage_source: catalog
+object_storage_path: catalog_folder
+materialized: table
source.yml
version: 2
sources:
-name: example
database: catalog
schema: catalog_folder
tables:
-name: catalog_table
columns:
-name: test
my_first_dbt_model.sql
{{ config(materialized=‘table’) }}
select *
from catalog.catalog_folder.catalog_table AT BRANCH main