Hi @malterializedvw,

Try this... Build your .sql file like the below,

CREATE MATERIALIZED VIEW IF NOT EXISTS
  IDENTIFIER('{{catalog}}.{{schema}}.{{table}}')
AS
SELECT
  ...
FROM
  ...;

 

If this answer resolves your question, could you mark it as “Accept as Solution”? That helps other users quickly find the correct fix.

Regards,
Ashwin | Delivery Solution Architect @ Databricks
Helping you build and scale the Data Intelligence Platform.
***Opinions are my own***