Everything you need to know about granting access for Alooma and connecting to Snowflake.
Setting up access to Snowflake can be done in a few simple steps.
First, log in to your Snowflake account and open up an SQL worksheet, or connect to Snowflake using your SQL console of choice.
Then, run the following SQL command block (note that lines 2 and 3 are optional):
USE ROLE accountadmin;
CREATE DATABASE "<database>";
CREATE SCHEMA "<database>"."<schema>";
CREATE ROLE "<alooma_role>";
GRANT USAGE ON DATABASE "<database>" TO ROLE
GRANT CREATE SCHEMA ON DATABASE "<database>" TO ROLE
GRANT ALL ON SCHEMA "<database>"."<schema>" TO ROLE
CREATE USER <alooma> PASSWORD='<password>' DEFAULT_ROLE
GRANT ROLE "<alooma_role>" TO USER <alooma>;
GRANT ALL ON WAREHOUSE "<warehouse_name>" TO
The code block above will:
Ensure that the role for the session is set to accountadmin in order to grant privileges.
[Optional] Create a new database for Alooma.
[Optional] Create a new schema for Alooma.
Create the role that will be used by the Alooma user.
Grant database privileges to the role (regardless of whether a new database was created in step 2).
Grant schema privileges to the role (regardless of whether a new schema was created in step 3).
Create the user for Alooma's Snowflake connection.
Grant alooma_role privileges to the alooma user.
Grant alooma_role privileges over the selected warehouse.
That's it, you're done configuring access, time to connect to Snowflake.
If you need support or prefer to use a pre-existing user, role, or other option, contact us and we'll be happy to help you get set up.
Once you've granted access to your Snowflake, you'll need to indicate the warehouse information for Alooma to connect to. Note that Snowflake is case-sensitive, so make sure to use uppercase letters.
Click on the Output node of the Plumbing page.
If not selected, choose the Settings tab.
Fill out the connection information:
Please note that all fields are case sensitive
Account subdomain (the subdomain portion of "http://<subdomain>.snowflakecomputing.com", NOT the entire URL)
Warehouse (case sensitive)
Username (case sensitive)
Database name (case sensitive)
Default schema (case sensitive - this is the one we'll write to by default, though you'll be able to choose to map to any other schema we have access to).
You can choose not to validate the Snowflake settings and save them regardless of their validity by checking the "do not validate" option (not recommended).
Save the changes.
Note that Alooma connects to Snowflake over SSL by default.
That's it! Alooma can now connect to your target Snowflake data warehouse.