Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
hk_sam
Partner - Contributor
Partner - Contributor

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

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

Labels (1)
1 Solution

Accepted Solutions
lyka
Support
Support

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

View solution in original post

2 Replies
Madhavi_Konda
Support
Support

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
Support
Support

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