topic Re: TDC - Snowflake JDBC Import bridge in Talend Data Catalog

TDC - Snowflake JDBC Import bridge

Anonymous — Sat, 16 Nov 2024 02:12:15 GMT

Hi,

I am receiving an error ( Unsupported feature 'MATERIALIZED VIEW') while importing SnowFlake (import bridge) in Talend Data Catalog. Based on 'TDC supported snowflake jar versions' mentioned in www.metaintegration.net/Products/MIMB/Specifications/MIRJdbcSnowflakeImport.html, it was mentioned 2.X versions are supported. But it said that 'the database connection failed in TDC'.

For 3.X versions of snowflake, I had received 'Unsupported feature Materialistic view'. But in the schema and database that I have used, there are no views created and while importing the snowflake in 'TDC', I have specifically mentioned only one 'table' name that is present in the snowflake database so that it would only trigger that one. But I still see the same error. I have attached the log file of the error for reference.

Could someone please help me with it?

Thanks in advance.

Regards

Sravya. B

Re: TDC - Snowflake JDBC Import bridge

Anonymous — Tue, 09 Jun 2020 05:49:30 GMT

Hi,

did you also try to filter the harvest-process just for tables or views?

Regards,

Steffen

Re: TDC - Snowflake JDBC Import bridge

Anonymous — Tue, 09 Jun 2020 16:33:03 GMT

Hi,

Yes, I did. But I am still receiving the same error.

Regards

Sravya

Re: TDC - Snowflake JDBC Import bridge

Anonymous — Wed, 10 Jun 2020 05:58:57 GMT

Hi Sravya,

do you get the same error if you filter for a single table-name? I'm not so sure, but I guess that the data catalog is first looking into the system tables, where the tool can find all kinds of schemas, tables, views and so on ...

So now lets imagine, you don't have the access to the system tables, the data catalog could not be able to harvest any metadata. Thats why I would try to look for a single table - if that one table-harvesting process is working, we could be sure that the data catalog is able to take a look into the system tables, if not you have to reinvestigate on that issue.

Regards,

Steffen

Re: TDC - Snowflake JDBC Import bridge

Anonymous — Thu, 11 Jun 2020 18:53:01 GMT

Hi Steffen,

Yes, I have tried by providing only one table but I still get the same issue.

Thanks,

Sravya

Re: TDC - Snowflake JDBC Import bridge

Anonymous — Wed, 17 Jun 2020 06:17:24 GMT

Hi Sravya,

that's a mess - at the moment I'm not able to readjust that issue, but I'll try.

Regards,

Steffen

Re: TDC - Snowflake JDBC Import bridge

Anonymous — Thu, 25 Jun 2020 15:26:27 GMT

Resolved when used snowflake 'Enterprise Edition' version as it would support 'materialized views'. However, Talend couldn't trigger the specified table which was mentioned while importing the model.