STORAGE.DYNAMIC_TABLE_BACKFILL_FROM

Target database: Snowflake

STORAGE.DYNAMIC_TABLE_BACKFILL_FROM option enables:

Specifying the table from where the initial state for the dynamic table is filled from.

See also:

• DYNAMIC_TABLE

Usage

STORAGE.DYNAMIC_TABLE_BACKFILL_FROM: String

Default: empty

Notes

Supports only Snowflake Dynamic table

Examples

Snowflake: Set the STORAGE.DYNAMIC_TABLE_BACKFILL_FROM

Setting STORAGE.DYNAMIC_TABLE_BACKFILL_FROM for an Dynamic table (e.g. publish.F_TRIP):

STORAGE.DYNAMIC_TABLE_BACKFILL_FROM: calculated_current_state_table

DDL generated by Agile Data Engine:

CREATE DYNAMIC TABLE publish.F_TRIP (
  ...
)
..
BACKFILL_FROM calculated_current_state_table
...
AS
  SELECT ...;