search

dbt-labs / dbt-snowflake

dbt-snowflake contains all of the code enabling dbt to work with Snowflake
https://getdbt.com
Apache License 2.0
297 stars 177 forks source link

WAREHOUSE value of Dynamic Table 'xxxx' unsupported #1145

Closed dataders closed 3 months ago

dataders commented 4 months ago

Discussed in https://github.com/dbt-labs/dbt-snowflake/discussions/774

Originally posted by **nauxliu** September 14, 2023 I encountered the strange error when changing a model to dynamic_table. ### Error ``` 15:55:52 Completed with 1 error and 0 warnings: 15:55:52 15:55:52 Database Error in model dd_reps (models/marts/discovery_data/dd_reps.sql) 002736 (22023): SQL compilation error: WAREHOUSE value of Dynamic Table 'XXXX' unsupported. compiled Code at target/run/rightcapital/models/marts/discovery_data/dd_reps.sql ``` The config code: ```sql {{ config( materialized = 'dynamic_table', target_lag = '1 minute', snowflake_warehouse = 'DEFAULT', on_configuration_change = 'apply' ) }} ``` My dbt version. ``` Core: - installed: 1.6.2 - latest: 1.6.2 - Up to date! Plugins: - snowflake: 1.6.2 - Up to date! ```
dataders commented 4 months ago

@nauxliu are you still experiencing this issue? Have you tried this on a newer version of dbt, like 1.8?

amychen1776 commented 3 months ago

Due to lack of response and inability to replicate this error, I'm going to close this issue for now but please reopen if it does come up.