Snowflake data store setup in minutes

Automate Snowflake from a single space with no code

A loader for Snowflake, a cloud-based data warehousing platform.

Settings

Account

Your account identifier. See Account Identifiers.

Database

The initial database for the Snowflake session.

Schema

The initial schema for the Snowflake session.

Default Target Schema

The default target database schema name to use for all streams.

User

The login name for your Snowflake user.

Password

The password for your Snowflake user.

Warehouse

The initial warehouse for the session.

Role

The initial role for the session.

Add Record Metadata

Whether to add metadata columns.

Batch Size Rows

Maximum number of rows in each batch.

Clean Up Batch Files

Whether to remove batch files after processing.

Faker Config Locale

One or more LCID locale strings to produce localized output for: https://faker.readthedocs.io/en/master/#localization

Faker Config Seed

Value to seed the Faker generator for deterministic output: https://faker.readthedocs.io/en/master/#seeding-the-generator

Flattening Enabled

'True' to enable schema flattening and automatically expand nested properties.

Flattening Max Depth

The max depth to flatten schemas.

Hard Delete

Hard delete records.

Load Method

The method to use when loading data into the destination. append-only will always write all input records whether that records already exists or not. upsert will update existing records and insert new records. overwrite will delete all existing records and insert all input records.

Private Key Passphrase

Passphrase to decrypt private key if encrypted.

Private Key Path

Path to file containing private key.

Stream Map Config

User-defined config values to be used within map expressions.

Stream Maps

Config object for stream maps capability. For more information check out Stream Maps.

Use Browser Authentication

Whether to use SSO authentication using an external browser.

Validate Records

Whether to validate the schema of the incoming streams.