Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

In this article

Table of Contents
minLevel1
maxLevel2
absoluteUrltrue

...

The Snowpipe Streaming Snap uses the role defined in the accounts' account URL properties field. If a role is not defined, the Snap runs a SELECT CURRENT_ROLE() to determine a suitable role, failing which it falls back to the PUBLIC role.

...

Error

Reason

Resolution

Schema name not found

The schema name is required for Snowpipe Streaming.

Provide a schema name in the Snap configuration.

...

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.

snowflake-select-config.png

snowflake-select-second-output.pngImage Modified

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.

...

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.

...

...

Attachments
patterns*.slp, *.zip

Snap Pack History

Expand
titleClick here to expand...

Insert excerpt
Snowflake Snap Pack
Snowflake Snap Pack
nameSnowflake_SPH
nopaneltrue

...

Related Content

...