Snowflake (Username / Password) (Beta)

Snowflake (Username / Password) support is currently in beta. Please raise any issues you encounter via the chat bubble in the bottom-right of the site, and we'll be happy to help.

---

Overview

Our Snowflake (Username / Password) integration allows you to import your data; allowing you to clean, transform, and ask questions via Chat Explore.

You must allow network traffic from the IP address 54.197.189.139 in order to allow Akkio to access your data.

Importing Data

To import data, first create a new project.

Click the Snowflake (Username/Pass) button.

Click the "Connect Dataset" button.

Enter your Snowflake details.

Your Account Identifier can be found by running this SQL statement within Snowflake:

select current_organization_name() || '-' || current_account_name() as "Account Identifier" Full documentation about Snowflake Account Identifiers can be found here.

To import data into Akkio, your user & role must have appropriate USAGE or SELECT permissions on all of the warehouse, database, schema, and table.

To create a new role for a user and grant read-only access, run SQL similar to:

-- Assumes a pre-existing user named MY_USER

CREATE ROLE AKKIO_ROLE;

GRANT ROLE AKKIO_ROLE TO USER MY_USER;

GRANT USAGE ON WAREHOUSE MY_WH TO ROLE AKKIO_ROLE;

GRANT USAGE ON DATABASE MY_DB TO ROLE AKKIO_ROLE;

GRANT USAGE ON SCHEMA MY_DB.MY_SCHEMA TO ROLE AKKIO_ROLE;

GRANT SELECT ON TABLE MY_DB.MY_SCHEMA.MY_TABLE TO ROLE AKKIO_ROLE;

NOTE: if you will be pushing predictions back to Snowflake, give these additional permissions:

-- Assumes a pre-existing user named MY_USER

GRANT CREATE TABLE ON SCHEMA MY_DB.MY_SCHEMA TO ROLE AKKIO_ROLE;

GRANT CREATE FILE FORMAT ON SCHEMA MY_DB.MY_SCHEMATO ROLE AKKIO_ROLE;

To pull in your data, input the following:

• Account Identifier: Your Snowflake Account Identifier. You can find it by running this SQL within Snowflake:

  select current_organization_name() || \'-\' || current_account_name()

• Warehouse: Which warehouse to use. Defaults to COMPUTE_WH.

• Database Name: The name of the database within your Snowflake account that your table is inside. NOTE: a database instance holds multiple databases or schemas, and each database or schema holds multiple tables.

• Role: Which role to use. If you do not specify one, the user's default role will be used. NOTE: the user's default role may be PUBLIC, which may not have access to your table.

• Username & Password: Credentials for the database user to authenticate. This user must have read permissions for a table to import and write permissions to deploy.

• Schema Name: The schema within your database where the table resides.

• Table Name: The name of the table to pull from.

When complete, hit submit.

We will then validate the connection.

If successful, you'll move forward to the data loading screen, where your data is syncing behind the scenes.

You may need to wait for the data to import. Small datasets should only take a few minutes; large datasets may take longer.

Once your data is done importing, you'll see it populate onto the screen.

From here, you can do anything you like to the data - clean and transform it on the Prepare tab, ask Chat Explore questions on the Explore tab, you name it!