topic Talend Studio Merge Into with Snowflake in Talend Studio

Talend Studio Merge Into with Snowflake

BenG — Thu, 16 Feb 2023 08:23:47 GMT

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

Re: Talend Studio Merge Into with Snowflake

Anonymous — Fri, 17 Feb 2023 07:08:13 GMT

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

Re: Talend Studio Merge Into with Snowflake

BenG — Fri, 17 Feb 2023 08:09:42 GMT

Ok, thanks! I will create a feature request.