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

[hk_sam]

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

[Madhavi_Konda]

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

[lyka · Accepted solution]

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