Talend Studio Merge Into with Snowflake

[BenG]

Hi,

we are using Snwoflake as Database solution. And want to use the Merge statement from Snowflake.

I know there is a SQL Template but this requieres a source table. We are using ELT components to gether the data and want to write the result with a merge into statement.

Like this: https://docs.snowflake.com/en/sql-reference/sql/merge

I saw there is a custom component for Oracle, is there already a solution for Snowflake?

Thanks

Ben

[Anonymous · Accepted solution]

Hello,

So far, there is no such a tSnowflakeMergeELT component in both talend studio and talend exchange portals.

Are you trying to refresh target table with source table?

We have to configure some merge statement with TALEND software Via creating a store procedure and Snowflake SP can be executed using tSnowflakeRow component.

Feel free to create a new feature jira issue on talend bug tracker.

Best regards

Sabrina

[BenG]

Ok, thanks! I will create a feature request.