Requirements
In order for Marketo Measure to set up a direct share to the data warehouse you must meet the following requirements.
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.
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 ROLE ACCOUNTADMIN
SHOW SHARES
CREATE DATABASE <database_name> FROM SHARE <provider_account>.<share_name>
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.