The Snowflake module enables you to execute SQL command in your Snowflake account.
Getting Started with Snowflake¶
- A Snowflake account
In order to use Snowflake with Ibexa Connect, it is necessary to have a Snowflake account. If you do not have one, you can create a Snowflake account at trial.snowflake.com.
The module dialog fields that are displayed in bold (in the Ibexa Connect scenario, not in this documentation article) are mandatory!
Connecting Snowflake to Ibexa Connect¶
To connect your Snowflake account to Ibexa Connect you need to fill the Create a connection dialog as follows:
Enter the name of your Snowflake account.
For example, if the URL of your Snowflake account is https://sx48547.eu-central-1.snowflakecomputing.com then the name of your account is
Enter your username. This can be found, for example, in the top-right corner of your account.
Enter the password to your account.
Enter the security role you want to use after creating the connection, if needed.
Click the Continue button to establish the connection.
The connection has been established. You can proceed with setting up the module.
Executes an SQL command in your Snowflake account.
Enter the SQL statement you want to execute in your Snowflake account.
Make sure you have set up the connection accordingly (schema, role)