SnowDDL
Search…
STREAM
Config path: /<database>/<schema>/stream/<name>.yaml
Example:
object_type: TABLE
object_name: test_table_1
append_only: true
show_initial_rows: true

Schema

  • object_type (str) - object type for stream (e.g. TABLE, EXTERNAL_TABLE)
  • object_name (ident) - object name for stream
  • append_only (bool) - is stream APPEND_ONLY(for TABLE)
  • insert_only (bool) - is stream INSERT_ONLY (for EXTERNAL_TABLE)
  • show_initial_rows (bool) - return existing rows when the stream is consumed for the first time
  • comment (str)

Usage notes

  1. 1.
    If stream is created on top of TABLE, table should have CHANGE_TRACKING=TRUE set explicitly in config. Otherwise SnowDDL will try to remove CHANGE_TRACKING during next run.
  2. 2.
    If stream is re-created, the contents of stream will lost.

Links

Last modified 7mo ago
Copy link
On this page
Schema
Usage notes
Links