Provide metadata in the table

This example pipeline demonstrates how to provide metadata for the table definition through the second input view, to enable the Bulk Load Snap to create a table according to the definition.


Pipeline 2

  1. Configure the Snowflake Execute Snap as follows to drop the newTable with the DROP TABLE query.

    Snowflake drop table

  2. Configure the Mapper Snap as follows to pass the input data.

    Upper Key case

  3. Configure the Snowflake Bulk Load Snap with two input views:
    • First input view: Input data from the upstream Mapper Snap.
    • Second input view: Table metadata from JSON Generator. If the target table is not present, a table is created in the database based on the schema from the second input view.
      Snowflake Bulk Load

    JSON Generator Configuration: Table metadata to pass to the second input view.


    JSON Generator Output

  4. Configure the Snowflake Select Snap with two output views.
    Snowflake Select