In order for Marketo Measure to set up a direct share to the data warehouse you must meet the following requirements.
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.
Open the Settings section in the Marketo Measure app and navigate to the Data Warehouse page. In the Direct Share section, enter your Snowflake account id in the box provided and click Connect.
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 role 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.