Data Warehouse Access - Direct Share

Requirements

In order for Marketo Measure to set up a direct share to the data warehouse you must meet the following requirements.

  • You have your own Snowflake instance.
  • Your Snowflake instance is located in the Azure East US 2 Snowflake region.
  • You provide Marketo Measure with your Snowflake account id.

Limitations

Marketo Measure will only be able to set up Snowflake Direct Shares with accounts located in Azure East US 2 due to current Snowflake Direct Share limitations. If you require your data to be made available in other Snowflake regions, we recommend making a copy of the data in a Snowflake account located in Azure East US 2 and leveraging the Snowflake Database Replication feature to copy your data in the Snowflake region/account of your choice.

Accessing the Share

Once the share has been created for the account id provided, you must complete the setup steps within your Snowflake instance in order to access the data.

NOTE

You can choose any database name you want. You can assign the privileges to any rule you choose, so long as it exists in your Snowflake instance.

  • Use the Account Admin role
USE ROLE ACCOUNTADMIN
  • View available shares (this will show the name of the share granted)
SHOW SHARES
  • Create a database for the share
CREATE DATABASE <database_name> FROM SHARE <provider_account>.<share_name>
  • Grant privileges on the shared database
GRANT IMPORTED PRIVILEGES ON DATABASE <database_name> TO ROLE <role_name>
GRANT IMPORTED PRIVILEGES ON ALL SCHEMAS IN DATABASE <database_name> TO ROLE <role_name>

For more detailed instructions and steps to accomplish these steps from the Snowflake UI, please reference Snowflake’s documentation directly.

On this page