Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
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