In this article
...
Error | Reason | Resolution |
---|---|---|
| The schema name is required for Snowpipe Streaming. | Provide a schema name in the Snap configuration. |
Examples
Ingest Data from One Table to Another in Snowflake
This example pipeline demonstrates how to use Snowflake - Snowpipe Streaming Snap to ingest data into the Snowflake database from a different table in the Snowflake database.
...
Download this pipeline.
Step 1: Configure the Snowflake - Execute Snap to delete the existing table.
...
Step 2: Configure the Snowflake - Select Snap with Schema name and Table name fields. Add the second output view for Snowflake - Select to pass the schema to the downstream Snowflake - Snowpipe Streaming Snap to enable table creation.
Step 3: Configure the Snowflake—Snowpipe Streaming Snap to ingest the data into the Snowflake database as and when available. On validation, the data is successfully inserted into the Snowflake database.
Ingest Data from a Source into Snowflake
This example pipeline demonstrates how to use Snowflake - Snowpipe Streaming Snap to ingest data into the Snowflake database from a source as and when it is available.
Download this pipeline.
Step 1: Configure the Sequence Snap to generate ten documents.
Step 2: Configure the Mapper Snap to pass the values to the downstream Snowflake- Snowpipe Streaming Snap.
...
Step 3: Configure the Snowflake - Execute Snap to create or replace an existing table with the column datatype.
...
Step 4: Configure the Mapper Snap to pass the values to the downstream Snowflake- Snowpipe Streaming Snap.
...
Step 5: Configure the Snowflake—Snowpipe Streaming Snap to ingest the data into the Snowflake database as and when available. On validation, the data is successfully inserted into the Snowflake database.
Snap Pack History
Expand | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||
|
...