Snowflake Database component to load data

[vidya821]

Is there any snowflake database component that doesn't copy the data to talend first and then loads into snowflake table ?

tSnowflakeOutput does copy the data to talend and then loads it into Snowflake, does tSnowflakeBulkExec also does the same ?

Thanks

[Anonymous]

Hello,

The tSnowflakeOutput component uses the data incoming from its preceding component to insert, update, upsert or delete data in a Snowflake table and tSnowflakeBulkExec component 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.

Normally, the tSnowflakeOutputBulk and tSnowflakeBulkExec components work together in a two-step process:

1. The tSnowflakeOutputBulk component uploads incoming data to a storage.
2. The tSnowflakeBulkExec component loads the data from a storage into a Snowflake database table.

You can transform the data before it is loaded into the database table in this two-step process.

These two steps are fused together in the tSnowflakeOutputBulkExec component, detailed in a separate section.

Best regards

Sabrina