Input · Databases and cloud

Snowflake Reader

Reads a table from Snowflake through a saved connection, or the result of a SQL query you write. A table is read whole unless you set a row limit.

Also known as: Data warehouse

How it works

Add it from Add data source → Snowflake with a saved Snowflake credential. Mode is table, where you name the Database, Schema and Table, or query, where you paste a SELECT. In table mode, Row limit caps how many rows are read; blank reads the whole table, and the node warns when the limit truncated the source. The limit is also editable later in the Attributes panel.

Inputs and outputs

Settings

Example

The ORDERS table in MY_DB.PUBLIC. Choose table mode, fill in the three names and set Row limit to 10000 while you build the pipeline; clear it before the final run.

More in Databases and cloud

• DB Reader — Reads a table from a PostgreSQL or MySQL database through a saved connection. You pick the schema and table.
• S3 Reader — Reads a file stored in an Amazon S3 bucket, or another S3-compatible store, into a table. A pattern such as s3://bucket/exports/*.csv reads every matching object into one table.
• Salesforce Reader — Reads the records of a Salesforce object through a saved connection, or the result of a SOQL query you write. An object is read whole unless you set a row limit.
• Strava Reader — Reads your Strava activities, athlete profile or activity streams through your own connected Strava app.