Assigning dyamic warehouses in dynamic table

General Discussion
1

I am using Gitlab for our CI and snowflake to design our dynamic tables. I need to assign dynamic warehouse. Below is a code snippet
–liquibase formatted sql
–changeset author:Prasanjit endDelimiter:/

CREATE OR REPLACE DYNAMIC TABLE TEST.TOTAL_PROP
LAG = ‘DOWNSTREAM’
WAREHOUSE = ‘TEST_{$ENV}01_WH’
REFRESH_MODE = FULL
AS

SELECT

ENV is a variable which is fetched from the CI based on the environment it is executing on.
After the variable is fetched it should read like TEST_D01_WH, TEST_T01_WH etc
I am getting the below error when I try to execute it

syntax error line 6 at position 0 unexpected ‘’
SELECT
‘’.

ERROR: Exception Primary Source: Snowflake 8.21.1

Is it the correct way of assigning warehouse name

2

Please provide the entire changelog, and the command you are using the execute Liquibase.

3

One thing I notice is that your variable syntax isn’t correct in your example:

Instead of WAREHOUSE = ‘TEST_{$ENV}01_WH’ you need `WAREHOUSE = ‘TEST_${ENV}01_WH’