- Overview
- Introduction to Marketo Measure
- Marketo Measure Tracking
- Setting Up Tracking
- Best Practices for Implementing Marketo Measure JavaScript
- Adding Marketo Measure Script
- Adding Marketo Measure Script via Google Tag Manager
- Adding Marketo Measure Script to Different Form Providers
- Adding Marketo Measure JavaScript to Pardot
- Adding Marketo Measure Script to Lightbox Forms
- Adding Marketo Measure Script to Sitecore Pages
- Adding Marketo Measure Script to Uberflip Forms
- Adding Marketo Measure to Act-On Forms
- Adding Marketo Measure to Hubspot
- Adding Marketo Measure to Marketo Landing Pages
- AJAX Form Handling
- Connecting Marketo Measure to Unbounce Script Manager
- IFrame Forms and Marketo Measure
- Excluding Marketo Measure from Specific Forms
- Marketo Measure Cookies
- Definition of Marketo Measure Web Sessions
- Best Practices for Testing
- Setting Up Tracking
- Configuration and Setup
- Getting Started with Marketo Measure
- Marketo Measure and Salesforce
- Marketo Measure Salesforce Package Installation and Set Up
- Salesforce Package Consolidation
- Connect Marketo Measure to Salesforce
- Best Practices for Marketo Measure CRM Package
- Marketo Measure Salesforce Objects
- How Marketo Measure and Salesforce Interact
- Marketo Measure Object and Field Taxonomy
- Marketo Measure Fields on Standard Salesforce Objects
- Page Layout Instructions
- Hiding Unnecessary Report Types
- Creating a Marketo Measure Profile
- Marketo Measure Permission Sets
- Recommended Salesforce Permissions for Marketo Measure Connected User
- Sandbox Testing
- Marketo Measure Insights (Canvas App)
- Channel Tracking and Setup
- API Connections
- Marketing Spend
- Advanced Marketo Measure Features
- Marketo Measure Discover UI
- Marketo Measure and Adobe
- Marketo Measure and Dynamics
- Marketo Measure and Marketo
- Marketo Measure Salesforce Reporting
- Marketo Measure Data Warehouse
- BI Report Templates
- Security and Compliance
- Marketo Measure Ultimate
- Miscellaneous
- Other Related Resources
- Marketo Measure Maintenance
- Marketo Measure Resource List
- Call Tracking Integration
- Difference between a Google Analytics Conversion and a Buyer Touchpoint
- Email Tracking Parameter
- Granting Salesforce Access to Marketo Measure Support
- Privacy Request
- Remove Marketo Measure Tracking Parameters from the Landing Page URL in Google Analytics
- Transitioning to Marketo Measure from Full Circle
- Other Related Resources
- Release Notes
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.
Enter Snowflake Account ID
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.
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 role 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.
Resources
Adobe Account
