Snowflake account managers can use the Snowflake connector to directly connect their Snowflake account to Akkio, making it easier than ever to build and deploy AI models on Snowflake data.
To connect your Snowflake account, you simply need to select Snowflake in the primary input step when creating a new flow.
You will then be prompted to enter your Snowflake Account ID.
To find the Account ID go to the bottom left of the snowflake instance and expand the menus as shown. Select the hyperlink icon. This will generate a URL that you can paste into the platform.
Copy in the text.
Then, in Snowflake, you’ll want to ensure that your account role is set to ACCOUNTADMIN.
Next, you’ll want to enter any databases you want to give Akkio read access to in your Snowflake account. Multiple database names should be separated by commas.
Now, Akkio will give you a code snippet to paste into Snowflake.
In Snowflake, you’ll first paste the code into a new workspace and press 'Run'. At the bottom rightt of the page, you’ll get a JSON Blob with OAUTH_CLIENT_ID and OAUTH_CLIENT_SECRET.
Note: We default to using the data warehouse
COMPUTE_WH. The default snippet will provision that warehouse to the new Akkio user.
The final step looks like the below. After pasting in the aforementioned JSON blob (with OAUTH_CLIENT_ID and OAUTH_CLIENT_SECRET), click “Finish.”
You’ll then be automatically taken to a Snowflake page to verify your integration. Simply click “Allow,” and you’re done!
From here, you can create an Akkio flow in the same way you would with any other data source. Simply select your Snowflake dataset, and you can either merge with additional data, or go straight to modeling and deployment.