How to point Snowflake DataPrep connection to use a particular SCHEMA

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



                                Zoho Marketing Automation
                                        • 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. ____________________________________________________________________________________________________________


                                        Manage your brands on social media



                                                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 WorkDrive Resources



                                                                    Zoho Campaigns Resources

                                                                      Zoho CRM Resources

                                                                      • CRM Community Learning Series

                                                                        CRM Community Learning Series


                                                                      • Tips

                                                                        Tips

                                                                      • Functions

                                                                        Functions

                                                                      • Meetups

                                                                        Meetups

                                                                      • Kbase

                                                                        Kbase

                                                                      • Resources

                                                                        Resources

                                                                      • Digest

                                                                        Digest

                                                                      • CRM Marketplace

                                                                        CRM Marketplace

                                                                      • MVP Corner

                                                                        MVP Corner

                                                                      





                                                                      




                                                                          Design. Discuss. Deliver.

                                                                          Create visually engaging stories with Zoho Show.

                                                                          Get Started Now