Metadata models¶

The SQL statements are generated from the standardized YAML models storing the metadata information for each required object.

These models can be auto-generated from provided metadata (model generation) or can be created / adjusted manually to the specific needs.

Models¶

Currently two model types are supported: 1. Snowflake table 2. Snowflake procedure with truncate and insert behavior

Snowflake table¶

system: snowflake
object_type: table

name: <table_name>
schema: <schema_name>

columns:
  - name: <column_name>
    datatype: <snowflake_datatype>
    key: <true|false>
  - ...

Snowflake truncate-insert procedure¶

system: snowflake
object_type: procedure

name: <procedure_name>
schema: <schema_name>

source:
  name: <table_name>
  schema: <schema_name>
  prefix: <table_prefix> # (1)!

target:
  name: <table_name>
  schema: <schema_name>
  prefix: <table_prefix> # (2)!

columns:
  - <column_name>
  - ...

bk:
  - <column_name>
  - ...

Optional. Defaults to TBL.
Optional. Defaults to TBL.