WAREHOUSE value of Dynamic Table 'xxxx' unsupported

[dataders]

Discussed in #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:

{{
  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!
```</div>

[dataders]

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

[amychen1776]

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.