topic Snowflake connection shows no tables in Talend Studio

Snowflake connection shows no tables

nickwhitebdp — Sat, 16 Nov 2024 01:24:16 GMT

Hi - I am using Talend Open Studio 7.3.1 and creating a Snowflake connection in Metadata. The connection test works OK and I have included a role in the "Advanced" section. However, when I click on "Next" there are no tables visible.

If I use exactly the same connection details and role in, for example, DBeaver, then I can see all the tables - so I know it is not an access/permissions issue in Snowflake and that the connection details are correct.

Any ideas what the issue might be or how I might investigate this further e.g. are there any log files generated when I am creating this connection?

Re: Snowflake connection shows no tables

Anonymous — Thu, 24 Sep 2020 08:25:35 GMT

Hello,

Are you following up this online documentation about: TalendHelpCenter:Centralizing Snowflake metadata?

Is it materialized Views? There is lots of limit for snowflake Materialized Views, need to care about : https://docs.snowflake.net/manuals/user-guide/views-materialized.html#limitations-on-creating-materialized-views

Best regards

Sabrina

Re: Snowflake connection shows no tables

nickwhitebdp — Thu, 24 Sep 2020 09:01:11 GMT

Hi - thanks for responding. Yes - I am following the online documentation and have filled in all the fields as recommended. All names are uppercase.

These are just tables - there are no MVs involved.

Screenshots below (obviously I have replaced <my-account-name>.eu-west-1 with my actual account name)

Test of connection successful:

No tables showing on the next screen: