Skip to content
English
  • There are no suggestions because the search field is empty.

Dataslayer Connectors for Snowflake: Complete Guide

Dataslayer connectors for Snowflake enable seamless integration between your marketing data sources and Snowflake's data warehouse. With support for 50+ marketing platforms including Google Ads, Facebook Ads, Google Analytics, and more, Dataslayer simplifies the process of consolidating your marketing data into Snowflake for advanced analytics and reporting.

What Makes Dataslayer Unique

  • Native Snowflake Integration: Data flows directly into your Snowflake warehouse without intermediary storage
  • 50+ Marketing Platforms: Connect all your advertising, analytics, and social media platforms
  • Automated Data Refresh: Schedule automatic data imports to keep your Snowflake tables up-to-date
  • Flexible Schema Definition: Customize your data structure by selecting specific metrics and dimensions
  • No-Code Setup: Intuitive interface requires no technical expertise

Supported Platforms

Dataslayer supports major marketing platforms, including:

  • Advertising: Google Ads, Facebook Ads, LinkedIn Ads, Microsoft Advertising, TikTok Ads, Twitter Ads
  • Analytics: Google Analytics, Search Console
  • Social Media: Facebook Insights, Instagram Insights, YouTube, LinkedIn Pages
  • E-commerce: Shopify, WooCommerce
  • And many more...

Quick Start Guide

Prerequisites

Before you begin, ensure you have:

  1. An active Snowflake account with appropriate permissions to create tables
  2. A Dataslayer account (sign up at dataslayer.ai if you don't have one)
  3. Admin or access credentials for the marketing platforms you want to connect

Step 1: Install the Dataslayer Connector from Snowflake Marketplace

  1. Log into your Snowflake account
  2. Navigate to Marketplace in the left sidebar
  3. Search for "Dataslayer" in the marketplace search bar
  4. Click on the Dataslayer connector listing
  5. Click Get or Install to add it to your Snowflake account
  6. Follow the prompts to grant necessary permissions

Step 2: Access Dataslayer Configuration Portal

  1. After installation, you'll receive access to the Dataslayer configuration portal
  2. Log in using your Dataslayer credentials or create a new account
  3. Link your Snowflake warehouse to your Dataslayer account

Step 3: Connect Your First Data Source

  1. From the Dataslayer dashboard, click Add New Connector
  2. Select the marketing platform you want to connect (e.g., Google Ads, Facebook Ads)
  3. Click Authenticate to begin the authorization process

Step 4: Authenticate Your Account

  1. You'll be redirected to the platform's login page
  2. Enter your credentials and grant Dataslayer the necessary permissions
  3. Upon successful authentication, you'll be redirected back to Dataslayer
  4. Your connected account will now appear in the list of available data sources

Step 5: Configure Your Data Import

Now you'll define what data to import and how it should be structured in Snowflake.

5.1 Select Accounts
  • Choose which accounts, properties, or profiles you want to pull data from
  • You can select multiple accounts if your login has access to several
  • Example: If you manage 5 Google Ads accounts, you can import data from all 5 simultaneously
5.2 Define Date Range

Choose your data collection period:

  • Preset ranges: Last 7 days, Last 30 days, Last month, This year
  • Custom range: Select specific start and end dates
  • Dynamic ranges: Configure rolling date windows for automated updates
  • Relative dates: Use "today", "yesterday", or offset dates like "today-7" for recurring imports
5.3 Select Metrics and Dimensions

This is where you define your Snowflake table structure:

Dimensions (categorical data):

  • Date
  • Campaign Name
  • Ad Group
  • Device
  • Country
  • Age Range
  • etc.

Metrics (numerical data):

  • Impressions
  • Clicks
  • Cost
  • Conversions
  • Revenue
  • CTR (Click-Through Rate)
  • ROAS (Return on Ad Spend)
  • etc.

Important: The metrics and dimensions you select will determine the columns in your Snowflake table. Choose only the fields you need for your analysis to optimize query performance.

Step 6: Configure Snowflake Destination

  1. Database: Select the Snowflake database where data will be stored
  2. Schema: Choose or create a schema for your marketing data
  3. Table Name: Define a descriptive name for your table (e.g., GOOGLE_ADS_CAMPAIGNS)
  4. Write Mode:
    • Append: Add new data to existing table
    • Replace: Overwrite the entire table with fresh data
    • Merge: Update existing records and add new ones (requires unique key)

Step 7: Set Up Refresh Schedule (Optional)

Configure automatic data updates:

  • Daily: Refresh every day at a specific time
  • Weekly: Update on selected days of the week
  • Hourly: For near real-time data needs
  • Custom: Define your own cron schedule

Step 8: Run Your First Import

  1. Review your configuration settings
  2. Click Run Now to perform an initial data import
  3. Monitor the import status in the dashboard
  4. Once complete, verify the data in your Snowflake warehouse

Configuration Instructions

Understanding the Connector Architecture

The Dataslayer connector works as a bridge between marketing platforms' APIs and your Snowflake warehouse:

Marketing Platform API → Dataslayer Connector → Data Transformation → Snowflake Table

Advanced Configuration Options

Multi-Account Aggregation

You can combine data from multiple accounts into a single Snowflake table:

  1. During account selection, choose multiple accounts
  2. An additional column (account_name or account_id) will be added to distinguish sources
  3. This allows for cross-account analysis in a single query
Custom Field Mapping

Map platform-specific field names to your preferred column names:

  1. Go to Advanced Settings in the connector configuration
  2. Enable Custom Field Mapping
  3. For each dimension/metric, specify your desired column name
  4. Example: Map campaignName to CAMPAIGN_NAME for consistency
Data Filtering

Apply filters to import only relevant data:

  1. Navigate to Filters section in configuration
  2. Add filter rules (e.g., "Campaign Name contains 'Brand'")
  3. Combine multiple filters with AND/OR logic
  4. Reduces data volume and speeds up imports

Table Schema Management

Schema Validation

Before each import, Dataslayer validates:

  • Column data types match expected formats
  • Required fields are present
  • No duplicate column names exist
  • Table permissions are sufficient

Performance Optimization

Clustering Keys

For large tables, define clustering keys to improve query performance:

  1. Recommended clustering on frequently filtered columns (e.g., DATE, CAMPAIGN_ID)
  2. Configure in Snowflake table settings after initial creation
  3. Example: ALTER TABLE campaigns CLUSTER BY (date, campaign_name);
Partitioning Strategy

Organize data by date partitions for better performance:

  • Use date-based table names for historical data (e.g., ADS_2024_Q1)
  • Configure Dataslayer to write to date-specific tables
  • Create views to union all partitions for comprehensive analysis

Common Use Cases

1. Marketing Performance Dashboard

Objective: Create a unified view of all marketing channels

Configuration:

  • Connect Google Ads, Facebook Ads, LinkedIn Ads in different tables
  • Select dimensions: Date, Channel, Campaign, Ad Group
  • Select metrics: Spend, Impressions, Clicks, Conversions, Revenue
  • Schedule: Daily refresh at 6 AM
  • Snowflake table: MARKETING_PERFORMANCE_UNIFIED
2. ROI Analysis by Campaign

Objective: Track return on investment across campaigns

Configuration:

  • Connect your advertising platforms in different tables
  • Select dimensions: Date, Campaign Name, Campaign ID
  • Select metrics: Cost, Revenue, Conversions, Conversion Value
  • Add calculated field: ROI = (Revenue - Cost) / Cost
  • Schedule: Twice daily

3. Social Media Analytics Consolidation

Objective: Aggregate social media metrics in one place

Configuration:

  • Connect Facebook Pages, Instagram Business, LinkedIn Company Pages, YouTube Channel in different tables
  • Select dimensions: Date, Platform, Content Type, Post ID
  • Select metrics: Impressions, Reach, Engagement, Shares, Comments
  • Schedule: Daily refresh

Troubleshooting

Authentication Issues

Problem: "Authentication failed" error. Solutions:

  • Verify your credentials are correct
  • Check if you have admin access to the connected account
  • Ensure two-factor authentication is properly configured
  • Re-authenticate the connector by clicking "Reconnect"

Problem: "Insufficient permissions" error. Solutions:

  • Verify the user account has access to the requested data
  • Check platform-specific permission requirements
  • For Google Ads: Ensure account has at least "Standard" access level
  • For Facebook: Confirm business manager admin rights

Data Import Errors

Problem: "No data returned" message. Solutions:

  • Verify the date range contains data
  • Check if filters are too restrictive
  • Confirm the account had activity during the selected period
  • Review platform-specific data availability delays

Problem: "Table creation failed" error. Solutions:

  • Verify Snowflake credentials and permissions
  • Ensure the database and schema exist
  • Check for special characters in table name
  • Confirm warehouse is running and accessible

Schedule and Refresh Issues

Problem: Scheduled refresh not running. Solutions:

  • Verify schedule configuration is active
  • Check for API quota limitations on the source platform
  • Ensure Snowflake warehouse is running during scheduled time
  • Review error logs in the Dataslayer dashboard

Problem: Partial data imports. Solutions:

  • Check for API rate limits on source platform
  • Verify date range doesn't exceed platform limitations
  • Monitor Dataslayer job logs for timeout errors
  • Consider splitting large imports into smaller date ranges

Getting Support

Dataslayer Support Channels

  • Documentation: Visit support.dataslayer.ai for comprehensive guides
  • Email Support.
  • Live Chat: Available in the Dataslayer website (business hours)

Snowflake Marketplace Support

For issues specific to the Snowflake Marketplace listing:

  • Visit the Dataslayer listing page in Snowflake Marketplace
  • Click "Support" or "Contact Provider"
  • Submit a support ticket with your account details

About Dataslayer

Dataslayer is a leading marketing data integration platform trusted by agencies, brands, and marketers worldwide. With 50+ native connectors and powerful automation features, Dataslayer eliminates the complexity of marketing data consolidation, empowering data-driven decision-making.

Learn more: www.dataslayer.ai