How to point Snowflake DataPrep connection to use a particular SCHEMA

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?

Zoho Desk Resources

Desk Community Learning Series
Digest
Functions
Meetups
Kbase
Resources
Glossary
Desk Marketplace
MVP Corner
Word of the Day

Topic Participants
Steve Bramblet
Nithin Ramesh

Sticky Posts
How to Add Users to your Organization in ZohoMail?
A better clarity so you can create other users to start using Zoho Mail. You can directly Add Users from the Control Panel to your Organization. You can invite users with the existing email address. If the person (user) already uses ZohoCRM, then you can import users from Zoho CRM. You can also import them using a .csv file. (if you are planning to add them in Bulk) In this topic, We will be discussing on how to Add and Invite users only. The Import options are self explanatory. ____________________________________________________________________________________________________________