Replaceable tags
Built-in replaceable marks/tags inside files.
Their purpose is help to avoid common mistakes and follow in-house naming convensions.
| mark | meaning |
|---|---|
| {{target_schema}} | Target schema of Task |
| {{target_table}} | Target table of Task |
Samples
DROP TABLE IF EXISTS {{target_schema}}.{{target_table}} CASCADE;
CREATE TABLE {{target_schema}}.{{target_table}} AS (
SELECT ....
);
CREATE INDEX IF NOT EXISTS ix_{{target_table}}_4_some_col
ON {{target_schema}}.{{target_table}} (some_col);