topic Re: How to Connect to a specific Snowflake schema via Replicate other than Public schema? in Qlik Replicate

How to Connect to a specific Snowflake schema via Replicate other than Public schema?

hk_sam — Tue, 16 Mar 2021 01:01:57 GMT

Hi,

I was trying to connect to a schema in Snowflake by specifying schema=mySchema in the advanced ODBC parameter. However, it automatically connects to the Public schema.

Does anyone have an idea about this?

Thank,

Sam

Re: How to Connect to a specific Snowflake schema via Replicate other than Public schema?

Madhavi_Konda — Tue, 16 Mar 2021 11:42:55 GMT

Hi Sam,
Can you define your schema in task settings->Metadata->Target Metadata->Target table schema
and Control Tables->Create target control tables in schema: and try replicating?

Thanks,
Madhavi

Re: How to Connect to a specific Snowflake schema via Replicate other than Public schema?

lyka — Tue, 16 Mar 2021 15:37:29 GMT

Hello,

You can also try this -

Go to the advanced settings of the snowflake endpoint and add the internal metadataschema

the default value is PUBLIC

Thanks,

Lyka