topic Re: QDC and Snowflake integration in Catalog and Lineage

QDC and Snowflake integration

ashish_dalvi22 — Tue, 07 Dec 2021 22:35:04 GMT

Hi,

I have installed snowflake driver and setup source connection for it in QDC. The connection works fine. But when I try to add data from Snowflake to QDC it throws attached error. Can someone please help.

Error! core.error.code.METADATA_TABLE_LOAD_FAILURE - Failed to get field metadata for table : SQL compilation error: syntax error line 1 at position 24 unexpected '.'.

Re: QDC and Snowflake integration

bvz — Wed, 26 Feb 2020 08:32:30 GMT

Hi.

How did you setup the connector in QDC Admin?

I used "net.snowflake.client.jdbc.SnowflakeDriver" as Driver Class Name, and double quotes as escape character (see screenshot attached).

I installed the snowflake-jdbc-3.9.2.jar and it works as expected.

Hope this helps.

Re: QDC and Snowflake integration

ashish_dalvi22 — Wed, 26 Feb 2020 14:33:32 GMT

Thank you so much for your help. That double quotes as escape character in driver setting did the trick 🙂

-Ashish

Re: QDC and Snowflake integration

Lavanyasreepada — Mon, 14 Dec 2020 07:36:21 GMT

Generally alluded to as ETL, information coordination envelops the accompanying three essential activities:

Concentrate

Sending out information from determined information sources.

Change

Changing the source information (varying), utilizing rules, combines, query tables or other transformation techniques, to coordinate the objective.

Burden

Bringing the subsequent changed information into an objective information base.

The later utilization of the term is ELT, underlining that the change activity doesn't really should be performed prior to stacking, especially in frameworks, for example, Snowflake that helps change during or in the wake of stacking.

Moreover, the extent of information combination has extended to incorporate a more extensive scope of tasks, including:

Information readiness.

Information relocation, development, and board.

Information stockroom computerization.

Thanks and Regards,

Lavanya Sreepada

Re: QDC and Snowflake integration

maksim_senin — Tue, 06 Apr 2021 08:35:43 GMT

Kudos!

The same works for the cdata.jdbc.excel.ExcelDriver - use " as delimiter... and finally you'll be able to load data (not just metadata) from MS Excel xlsx file into Qlik Catalog.