topic Re: Snowflake Metadata creation errors in Talend Studio

Snowflake Metadata creation errors

nickwhitebdp — Sat, 16 Nov 2024 07:33:34 GMT

When I try to create metadata for a Snowflake connection, using the wizard, the connection is created and the list of tables returned. If I select one table then the wizard seems to work ok but the metadata is not saved. If I select multiple tables then the wizard throws an error.

I have seen similar posts regarding Salesforce but none where there seems to be a solution.

I am using TOS v7,0.1

The error log shows:

To see the whole post, download it here

Re: Snowflake Metadata creation errors

Anonymous — Sat, 29 Sep 2018 09:18:32 GMT

Hello,

It seems wrong setup of schema from Snowflake connection. Is this issue related to specific tables?

Best regards

Sabrina

Re: Snowflake Metadata creation errors

nickwhitebdp — Sat, 29 Sep 2018 10:42:26 GMT

I sort of found a workaround to this bug...

I created the connection without any tables and then edited the connection and added the tables 1 by 1. I found if I tried to add more than one table at a time it errored and there also seemed to be a limit to the number of tables I could add to a single connection so I ended up with 2 connections and half the tables added to each connection.

Regards,

Nick

Re: Snowflake Metadata creation errors

Anonymous — Sat, 29 Sep 2018 11:03:17 GMT

Hello,

The schema and database should be mandatory.

Is it saying connection ok when you put all crendentials in Snowflake metadata creation?

Best regards

Sabrina

Re: Snowflake Metadata creation errors

nickwhitebdp — Sat, 29 Sep 2018 11:30:27 GMT

Yes - the connection is fine, it passes the connection step. On the next step of the wizard it correctly shows the tables. The issue is that when I then try and select those tables and then save it errors

Re: Snowflake Metadata creation errors

Anonymous — Sun, 30 Sep 2018 07:07:05 GMT

Hello,

It seems some bug appear when store or syn the schema in studio.

Best regards

Sabrina

Re: Snowflake Metadata creation errors

nickwhitebdp — Tue, 02 Oct 2018 10:58:34 GMT

There seem to be some tables that I can't add no matter what I try. I can't see anything different about those tables (no datatypes not used in tables I have already added, etc.)

Anyone have any more ideas?

Is there a way of formally raising this as a bug?

Re: Snowflake Metadata creation errors

Anonymous — Wed, 03 Oct 2018 17:20:06 GMT

hi,

Depending on the version you are using, you should:

- contact Talend Support if you are using subscription version.

Open source version are not associated with a contract support, but you may raise a jira ticket at

https://jira.talendforge.org/ with all the required steps in order to reproduce it (DML export, examples...)

Benjamin