malterializedvw
New Contributor III

Hey @Pat , thanks for the answer, I didnt know about the IDENTIFIER-clause and it makes me hopeful.
Yes, you got me right. So, I tried to apply your suggestion to my problem, defining catalog, schema and table in the job.yml and then updating my query.sql as follows:

CREATE MATERIALIZED VIEW IF NOT EXISTS IDENTIFIER(
  :catalog || :schema || :table
)

Also I tried this:

:catalog || '.' || :schema || '.' || :table

Neither worked though.
Exactly one CREATE [ LIVE TABLE | MATERIALIZED VIEW | STREAMING TABLE ] statement expected, but 0 found