Issue creating a snowflake data source using gateway

Hi Anonymous ,

It sounds like you are trying to connect to a Snowflake database using an ODBC connection and you are encountering an error when you try to run a SELECT statement. The error message indicates that you need to specify a database to use for the connection.

In Snowflake, a database is a logical container for a set of tables and other objects. When you create a connection to a Snowflake account, you need to specify the name of the database that you want to connect to.

To specify the database to use for the connection, you can use the "Database" option in the connection settings. This option is usually located in the same section as the "Server" and "Warehouse" options. You will need to enter the name of the database that you want to connect to in this field.

Alternatively, you can also specify the database to use in your SQL statements by using a qualified name. A qualified name consists of the name of the database, followed by a period (.) and the name of the object (e.g. "database_name.table_name").

For example, you could use a statement like this to select data from a table in a specific database:

SELECT * FROM database_name.table_name;

I hope this helps! Let me know if you have any more questions.

Best Regards,
Henry

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.