In this post, we will cover a few operations in the Mule Snowflake Connector along with the Snowflake configuration for those operations (task, store procedure, multi-table insert, merge, row listener, and Snowpipe concept).
Snowflake Access and Setup
Snowflake Access for Development
Please create an account in Snowflake. Please note:
Account name: We need to mention from the URL we can infer SB15234.ap-southeast-1.
For the trial account, you would have 30 days. This allows you access to the same database with data. You can explore for your test and development.
Select cloud hosting (Standard) and region (Asia Pacific), Cloud Provider AWS (out of any AWS, Google, Azure) would be fine. For the rest, enter the information asked based on which purpose you need.
You will receive an activation mail along with a Snowflake-hosted URL, which will be used for the Snowflake login from the browser. For the first time, you need to set the user name and password for the Snowflake account.
Enterprise work process: Generally enterprise applications or licensed applications would either allow single sign-on or they will create a service account for Snowflake access.
3. You can connect as well using Snowflake CLI.