Snowflake Database component to load data

vidya821 — Fri, 15 Nov 2024 23:11:18 GMT

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

Re: Snowflake Database component to load data

Anonymous — Tue, 22 Feb 2022 08:57:27 GMT

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:

The tSnowflakeOutputBulk component uploads incoming data to a storage.
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

topic Re: Snowflake Database component to load data in Talend Studio

Snowflake Database component to load data

Re: Snowflake Database component to load data