Skip to main content

Snowflake components

tSnowflakeBulkExec Loads data from files in a folder into a Snowflake table. The folder can be in an internal Snowflake stage, an Amazon Simple Storage Service (Amazon S3) bucket, or an Azure container.
tSnowflakeClose Closes an active Snowflake connection to release the occupied resources.
tSnowflakeCommit Provides gain in performance.
tSnowflakeConfiguration Stores connection information and credentials to be reused by other Snowflake components in the Apache Spark Batch framework.
tSnowflakeConnection Opens a connection to Snowflake that can then be reused by other Snowflake components.
tSnowflakeInput Reads data from a Snowflake table into the data flow of your Job based on an SQL query.
tSnowflakeOutput Uses the data incoming from its preceding component to insert, update, upsert or delete data in a Snowflake table.
tSnowflakeOutputBulk Writes incoming data to files generated in a folder. The folder can be in an internal Snowflake stage, an Amazon Simple Storage Service (Amazon S3) bucket, or an Azure container.
tSnowflakeOutputBulkExec Writes incoming data to files generated in a folder and then loads the data into a Snowflake database table. The folder can be in an internal Snowflake stage, an Amazon Simple Storage Service (Amazon S3) bucket, or an Azure container.
tSnowflakeRollback Cancels the transaction commit in the Snowflake database to avoid committing part of a transaction involuntarily.
tSnowflakeRow Executes the SQL command stated onto a specified Snowflake database.

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!