Hi - how do I set the Snowflake DataPrep connection to use a particular SCHEMA in the database?
I've tried appending the schema to the database name and to the table name but not working so far.

Also I am getting errors on "warehouse not active" and "user cannot create tables" although I know both of these are not true in the general sense. I feel there's an issue with the connection and the security context.

For example:
Export has failed. Error during export. Error details: No active warehouse selected in the current session. Select an active warehouse with the 'use warehouse' command.

This one happens when I do not select a SCHEMA - just enter the base DATABASE and a new TABLE name.
This also occurs when I manually generated the table in Snowflake and selected "use existing table".

Here's another one:
Export has failed. Error during export. Error details: Cannot perform INSERT. This session does not have a current database. Call 'USE DATABASE', or use a qualified name.

This is using the DATABASE.SCHEMA as the database name.

It seems that the underlying connection to the Snowflake database is not being handled correctly. 

The connection from Zoho DataPrep should call the USE WAREHOUSE and USE DATABASE each time.
Also there should be an option to enter a SCHEMA.

Any suggestions?