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.
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 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?
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?
Access your files securely from anywhere
Zoho Developer Community
New to Zoho LandingPage?
Zoho LandingPage Resources
New to Zoho Survey?
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho Marketing Plus?
Everything you need to run your marketing
New to Zoho Marketing Plus?
Everything you need to run your marketing
New to Bigin?
Topic Participants
Steve Bramblet
Nithin R
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. ____________________________________________________________________________________________________________
New to Zoho TeamInbox?
Zoho TeamInbox Resources
Zoho DataPrep Resources
Zoho CRM Plus Resources
Zoho Books Resources
Zoho Subscriptions Resources
Zoho Projects Resources
Zoho Sprints Resources
Qntrl Resources
Zoho Creator Resources
Zoho Campaigns Resources
Zoho CRM Resources
Design. Discuss. Deliver.
Zoho Show Resources
Get Started. Write Away!
Writer is a powerful online word processor, designed for collaborative work.
Zoho CRM コンテンツ
-
オンラインヘルプ
-
Webセミナー
-
機能活用動画
-
よくある質問
-
Ebook
-
-
Zoho Campaigns
- Zoho サービスのWebセミナー