Snowflake Azure Bs

Use Snowflake and Microsoft Azure

Prerequisites

Access to Snowflake
Microsoft Azure account

Configure Snowflake

In Snowflake, create a new SQL worksheet and paste in the query shown below. The query will create a Snowflake database, a warehouse and a user with the required permissions.

After changing the MY_NAME, MY_COMMENT and MY_PASSOWRD variables, select "Run all" to execute the query.

configure_snowflake.sql

-- Set up variables
SET MY_NAME = UPPER('Y42_DEMO');
SET MY_COMMENT = 'Y42 DataOps Cloud demo';
SET MY_PASSWORD = 'my_secret_password';
-- Set up user / role
CREATE ROLE IDENTIFIER($MY_NAME) COMMENT = $MY_COMMENT;
CREATE USER IDENTIFIER($MY_NAME) COMMENT = $MY_COMMENT PASSWORD = $MY_PASSWORD MUST_CHANGE_PASSWORD = false DEFAULT_ROLE = $MY_NAME;
GRANT ROLE IDENTIFIER($MY_NAME) TO ROLE IDENTIFIER('ACCOUNTADMIN');
GRANT ROLE IDENTIFIER($MY_NAME) TO USER IDENTIFIER($MY_NAME);
-- Set up database
CREATE DATABASE IDENTIFIER($MY_NAME) COMMENT = $MY_COMMENT;
GRANT CREATE SCHEMA ON DATABASE IDENTIFIER($MY_NAME) TO ROLE IDENTIFIER($MY_NAME);
GRANT ALL ON DATABASE IDENTIFIER($MY_NAME) TO ROLE IDENTIFIER($MY_NAME);
GRANT OWNERSHIP ON DATABASE IDENTIFIER($MY_NAME) TO ROLE IDENTIFIER($MY_NAME) REVOKE CURRENT GRANTS; 
-- Set up warehouse
CREATE WAREHOUSE IDENTIFIER($MY_NAME) COMMENT = $MY_COMMENT WAREHOUSE_SIZE = 'X-Small' AUTO_RESUME = true AUTO_SUSPEND = 120 WAREHOUSE_TYPE = 'STANDARD';
GRANT USAGE ON WAREHOUSE IDENTIFIER($MY_NAME) TO ROLE IDENTIFIER($MY_NAME);

The exmaple query will generate the following credentials:

Field	Example value
User	`Y42_DEMO`
Password	`my_secret_password`
[1] Account	`https://<account_locator>.<cloud_region_id>.snowflakecomputing.com`
Warehouse	`Y42_DEMO`
Database	`Y42_DEMO`

[1] Region-specific account locator (opens in a new tab)

Configure Azure

In the Azure management console, go to Data Storage/Containers. Next, create a new container and retrieve the access key.

For further details, please visit Microsoft Azure's documentation on account access keys (opens in a new tab).

Snowflake with AWS S3 3. Define a source asset