malterializedvw
New Contributor III
In response to Ashwin_DSA

2 weeks ago

Hi Ashwin, this approach wouldn't work for me due to the apostrophe injected. Sorry for the bad formatting, I am running into errors trying to send it properly.

- task_key: example 
sql_task: 
file: 
path: query.sql 
source: WORKSPACE 
warehouse_id: abc 
parameters: 
    catalog: data_catalog_${var.environment}
    schema: source_schema 
    table: mat_view
CREATE MATERIALIZED VIEW IF NOT EXISTS {{catalog}}.{{schema}}.{{table}}​
[PARSE_SYNTAX_ERROR] Syntax error 
CREATE MATERIALIZED VIEW IF NOT EXISTS
'data_catalog_PROD'.'source_schema'.'mat_view'
0 Kudos