Docs
Go to Home
API Docs
Free Trial
  • Introduction
    • About Hevo
    • Hevo Features
    • Hevo System Architecture
      • Hevo Pipeline Framework
    • Core Concepts
      • ETL and ELT
      • Data Pipelines
      • Sources and Destinations
        • Types of Sources
        • Types of Destinations
      • Events
      • Objects and Event Types
      • Data Replication
      • Data Transformation
      • Data Types
    • Free Trials
      • Free Product Trial
      • Free Trial of Unused Sources
    • Security
      • Customer Data Retention and Encryption
      • Infrastructure Security
      • Company Security Standards and Practices
      • Password and Account Lockout Policy
    • Regulatory Compliance
    • Hevo Support
  • Getting Started
    • Creating an Account in Hevo
      • Selecting your Hevo Region
      • Creating your Account
      • User Roles
    • Connection Options
      • Connecting Through SSH
      • Connecting Through Reverse SSH Tunnel
      • Reauthorizing an OAuth Account
      • Using Google Account Authentication
    • Familiarizing with the UI
      • Asset Palette
      • Global Search
      • User Information Panel
      • Activity Graphs
      • Side-by-Side Setup Guide
      • Keyboard Shortcuts
      • Switching to Dark Mode
      • UI Elements and Terms Reference
    • Creating your First Pipeline
      • Creating a Database Pipeline
      • Creating a SaaS Pipeline
      • Creating a WebHook Pipeline
    • Data Loss Prevention and Recovery
    • Activity Log
      • Activity Logs - Cloudwatch Sync
  • Data Ingestion
    • Ingestion Modes
    • Types of Data Synchronization
    • Ingestion and Loading Frequency
    • Ingestion Frequency and Data Synchronization
    • Data Ingestion Statuses
    • Deferred Data Ingestion
    • Query Modes for Ingesting Data
    • Handling of Primary Keys
    • Handling of Updates
    • Handling of Deletes
    • Hevo-generated Metadata
      • Metadata Column __hevo_database_name
      • Metadata Column __hevo_id
      • Metadata Column __hevo_source_modified_at
  • Data Loading
    • Loading Data in a Database Destination
    • Loading Data to a Data Warehouse
    • Optimizing Data Loading for a Destination Warehouse
    • Manually Triggering the Loading of Events
    • Scheduling Data Load for a Destination
    • Loading Events in Batches
    • Name Sanitization
    • Table and Column Name Compression
    • Parsing Nested JSON Fields in Events
  • Pipelines
    • Data Flow in a Pipeline
    • Ingestion Modes
    • Familiarizing with the Pipelines UI
    • Pipeline Objects
      • Managing Objects in Pipelines
    • Working with Pipelines
      • Best Practices for Creating Database Pipelines
      • Creating a Pipeline
      • Scheduling a Pipeline
      • Modifying a Pipeline
      • Prioritizing a Pipeline
      • Viewing Pipeline Progress
      • Troubleshooting Data Replication Errors
      • Pausing and Deleting a Pipeline
      • Log-based Pipelines
        • Pausing a Log-based Pipeline
        • Handling Deletes in Log-based Pipelines
    • Transformations
      • Python Code-Based Transformations
        • Example - Splitting Nested Events into Multiple Events
        • API References
          • Event Object
          • TimeUtils
          • Utils
      • Drag and Drop Transformations
        • Transformations and Properties
        • Examples of Drag and Drop Transformations
      • Effect of Transformations on the Destination Table Structure
      • Transformation Reference
        • Datetime Field Values
        • Operators
        • Rounding Modes
        • Text Casing
        • Values and Formulas
    • Schema Mapper
      • Using Schema Mapper
      • Mapping Statuses
      • Auto Mapping Event Types
        • Modifying Schema Mapping for Auto Mapped Event Types
      • Mapping a Source Event Type with a Destination Table
      • Mapping a Source Event Type Field with a Destination Table Column
      • Schema Mapper Actions
      • Fixing Unmapped Fields
      • Resolving Incompatible Schema Mappings
      • Resizing String Columns in the Destination
      • Schema Mapper Compatibility Table
    • Failed Events in a Pipeline
      • Reasons for Event Failures
      • Resolving Event Failures
    • Pipeline FAQs
  • Events Usage
    • Understanding Events Usage for Billing
    • Events Quota Reset Date
    • Viewing Events Usage
    • Pipeline Usage Summary
    • Factors Affecting Event Usage
      • Query Modes
      • Pipeline Frequency
      • Conversion Window and Pipeline Frequency in Ad-based Sources
  • Sources
    • Free Sources
    • Analytics
      • Amplitude Analytics
      • CleverTap
      • Google Analytics
        • Google Analytics Filters
      • Google Analytics 360
      • Google Analytics 4
      • Localytics
      • Mixpanel
      • YouTube Analytics
    • Collaboration
      • Asana
      • GitHub
      • Jira
    • CRM
      • Freshdesk
      • Intercom
        • Intercom App
        • Intercom Webhook
      • Salesforce
      • Zendesk
    • Data Warehouses
      • Amazon Redshift
      • Google BigQuery
    • Databases
      • Connecting to a Local Database
      • Amazon DynamoDB
      • Elasticsearch
      • MongoDB
        • Generic MongoDB
        • MongoDB Atlas
        • Support for Multiple Data Types for the _id Field
        • Example - Merge Collections Feature
        • Troubleshooting MongoDB Change Streams Connection
        • Troubleshooting MongoDB OpLog Connection
      • MySQL
        • Amazon Aurora MySQL
        • Amazon RDS MySQL
        • Azure MySQL
        • Generic MySQL
        • Google Cloud MySQL
        • MariaDB MySQL
        • Common Issues in MySql Binary Logs Based Replication
      • Oracle
        • Generic Oracle
        • Amazon RDS Oracle
      • PostgreSQL
        • Amazon Aurora PostgreSQL
        • Amazon RDS PostgreSQL
        • Azure PostgreSQL
        • Google Cloud PostgreSQL
        • Generic PostgreSQL
        • Heroku PostgreSQL
      • SQL Server
        • Amazon RDS MS SQL
        • Azure SQL Server
        • Generic SQL Server
        • Google Cloud SQL Server
    • E-Commerce
      • Magento
      • PrestaShop
      • Shopify
        • Shopify App
        • Shopify Webhook
      • WooCommerce
      • WordPress
    • File Storage
      • File Log
      • Amazon S3
      • FTP / SFTP
      • Google Cloud Storage (GCS)
      • Google Drive
      • Google Sheets
    • Finance & Accounting
      • QuickBooks Online
      • Stripe
      • Xero
    • Marketing
      • AdRoll
      • Apple Search Ads
      • AppsFlyer
      • Criteo
      • Facebook Ads
        • Facebook Fields and Dimensions
      • Facebook Page Insights
      • Google Ads
        • Google Ads API
        • Google AdWords
      • Google Campaign Manager
      • Google Play Console
      • Google Search Console
      • HubSpot
      • Instagram Business
      • Klaviyo
      • LinkedIn Ads
      • Mailchimp
      • Marketo
      • Microsoft Advertising
      • Outbrain
      • Pardot
      • Pinterest Ads
      • Segment
      • SendGrid
      • SendGrid Webhook
      • Salesforce Marketing Cloud
      • Snapchat Ads
      • Taboola
      • Twitter Ads
    • Streaming
      • Android SDK
      • Kafka
        • Apache Kafka
        • Kafka Confluent Cloud
      • REST API
        • Writing JSONPath Expressions
      • Webhook
    • Source FAQs
  • Destinations
    • Familiarizing with the Destinations UI
    • Databases
      • Amazon Aurora
      • Microsoft SQL Server
      • MySQL
      • PostgreSQL
      • Connecting to a Local Database
    • Data Warehouses
      • Amazon Redshift
        • Loading Data to an Amazon Redshift Data Warehouse
      • Databricks
      • Firebolt
        • Mapping Events to Firebolt Tables
          • Configuring Fact and Dimension Tables
      • Hevo Managed Google BigQuery
        • Connecting BI Tools to Hevo
          • Connecting Google Data Studio to Hevo
          • Connecting Tableau to Hevo
          • Connecting Chartio to Hevo
          • Connecting Looker to Hevo
          • Connecting Metabase to Hevo
          • Connecting Microsoft Power BI to Hevo
          • Connecting Redash to Hevo
      • Google BigQuery
        • Clustering in BigQuery
        • Partitioning in BigQuery
        • Loading Data to a Google BigQuery Data Warehouse
        • Google BigQuery
        • Near Real-time Data Loading using Streaming
      • Snowflake
        • Loading Data to a Snowflake Data Warehouse
    • Destination FAQs
  • Transform
    • Models
      • Familiarizing with the Models UI
      • Types of Models
      • Key Features
        • Query Export Options
        • Templatized Queries
        • Model Reset
      • Working with Models
      • Previewing a Model
      • Viewing the Query History
      • Legacy Models
        • Legacy Models in Hevo
        • Updating Legacy Models
    • Workflows
      • Familiarizing with the Workflows UI
      • Working with Workflows
      • Viewing the Workflow History
  • Activate
    • Activate Concepts
      • Synchronization Behaviors
      • Data Synchronization Identifiers
      • Field Mapping
      • Bookkeeping
      • Activation Run Statuses
    • Familiarizing with the Activate UI
    • Working with Activate
      • Creating an Activation
      • Modifying an Activation
        • Modifying the Activation Query
        • Modifying the Target Configuration
        • Updating Field Mapping
      • Scheduling an Activation
      • Viewing Activation Run Details
    • Activate Warehouses
      • Amazon Redshift
      • Google BigQuery
      • Snowflake
    • Activate Targets
      • Google Sheets
      • HubSpot
      • Intercom
        • Tags in Intercom
      • Marketo
      • Salesforce
      • Zendesk
  • Alerts
    • Customizing Alert Preferences
    • Getting Alerts in Slack
  • Account Management
    • Personal Settings
      • Changing Your Password
      • Resetting Your Password
      • Enabling Two-Factor Authentication
    • Team Settings
      • Inviting and Moderating Team Members
      • Enabling Password or Google-Based Authentication
      • Enforcing Google Authentication Across Your Team
      • Enforcing SAML Single Sign On Across Your Team
      • Granting Temporary Access to Hevo Support
      • Deleting an Account
    • Billing
      • Pricing Plans
      • Setting up Pricing Plans, Billing, and Payments
      • On-Demand Purchases
        • Purchasing On-Demand Events
        • Setting up On-Demand Credit
      • Billing Alerts
      • Viewing Billing History
      • Billing Notifications
      • Billing FAQs
    • Account Suspension and Restoration
    • General FAQs
  • Troubleshooting
    • Troubleshooting Sources
      • Troubleshooting Amazon DynamoDB
        • Errors Post-Pipeline Creation
          • Error 2008 - Streams disabled for table
          • Error 2011 - Invalid StreamViewType
      • Troubleshooting MongoDB
        • Errors During Pipeline Creation
          • Error 1001 - Incorrect credentials
          • Error 1005 - Connection timeout
          • Error 1006 - Invalid database hostname
          • Error 1008 - Database unreachable
          • Error 1011 - Insufficient access
          • Error 1028 - Primary/Master host needed for OpLog
          • Error 1029 - Version not supported for Change Streams
      • Troubleshooting MS SQL
        • Errors During Pipeline Creation
          • Error 1003 - Authentication error
          • Error 1005 - Connection timeout
          • Error 1011 - Insufficient access
      • Troubleshooting MySQL
        • Errors During Pipeline Creation
          • Error 1003 - Connection to host failed
          • Error 1006 - Connection to host failed
          • Error 1007 - SSH connection failed
          • Error 1011 - Access denied
          • Error 1012 - Replication access denied
          • Error 1017 - Connection to host failed
          • Error 1026 - Failed to connect to database
          • Error 1027 - Unsupported BinLog format
        • Errors Post-Pipeline Creation
          • Insufficient max_allowed_packet Size
          • Out of Sort Memory
          • Pipeline failure due to BinLog expiry
      • Troubleshooting Oracle
        • Errors Post-Pipeline Creation
          • Pipeline failure due to Redo Log expiry
      • Troubleshooting PostgreSQL
        • Errors during Pipeline creation
          • Error 1003 - Authentication failure
          • Error 1006 - Connection settings errors
          • Error 1011 - Access role issue for logical replication
          • Error 1012 - Access role issue for logical replication
          • Error 1014 - Database does not exist
          • Error 1017 - Connection settings errors
          • Error 1023 - No pg_hba.conf entry
          • Error 1024 - Number of requested standby connections
      • Troubleshooting Salesforce
        • Errors Post-Pipeline Creation
          • API Quota Exhausted
    • Troubleshooting Destinations
      • Troubleshooting Databricks
        • Errors Post-Pipeline Creation
          • Schema Mapping failure due to missing Metadata
  • Glossary
  • Release Notes
    • Release Version 1.88
    • Release Version 1.87
    • Release Version 1.86
    • Release Version 1.84 & 1.85
    • Release Version 1.83
    • Release Version 1.82
    • Release Version 1.81
    • Release Version 1.80 (Jan-24-2022)
    • Release Version 1.79 (Jan-03-2022)
    • Release Version 1.78 (Dec-20-2021)
    • Release Version 1.77 (Dec-06-2021)
    • Release Version 1.76 (Nov-22-2021)
    • Release Version 1.75 (Nov-09-2021)
    • Release Version 1.74 (Oct-25-2021)
    • Release Version 1.73 (Oct-04-2021)
    • Release Version 1.72 (Sep-20-2021)
    • Release Version 1.71 (Sep-09-2021)
    • Release Version 1.70 (Aug-23-2021)
    • Release Version 1.69 (Aug-09-2021)
    • Release Version 1.68 (Jul-26-2021)
    • Release Version 1.67 (Jul-12-2021)
    • Release Version 1.66 (Jun-28-2021)
    • Release Version 1.65 (Jun-14-2021)
    • Release Version 1.64 (Jun-01-2021)
    • Release Version 1.63 (May-19-2021)
    • Release Version 1.62 (May-05-2021)
    • Release Version 1.61 (Apr-20-2021)
    • Release Version 1.60 (Apr-06-2021)
    • Release Version 1.59 (Mar-23-2021)
    • Release Version 1.58 (Mar-09-2021)
    • Release Version 1.57 (Feb-22-2021)
    • Release Version 1.56 (Feb-09-2021)
    • Release Version 1.55 (Jan-25-2021)
    • Release Version 1.54 (Jan-12-2021)
    • Release Version 1.53 (Dec-22-2020)
    • Release Version 1.52 (Dec-03-2020)
    • Release Version 1.51 (Nov-10-2020)
    • Release Version 1.50 (Oct-19-2020)
    • Release Version 1.49 (Sep-28-2020)
    • Release Version 1.48 (Sep-01-2020)
    • Release Version 1.47 (Aug-06-2020)
    • Release Version 1.46 (Jul-21-2020)
    • Release Version 1.45 (Jul-02-2020)
    • Release Version 1.44 (Jun-11-2020)
    • Release Version 1.43 (May-15-2020)
    • Release Version 1.42 (Apr-30-2020)
    • Release Version 1.41 (Apr-2020)
    • Release Version 1.40 (Mar-2020)
    • Release Version 1.39 (Feb-2020)
    • Release Version 1.38 (Jan-2020)
  • Upcoming Features
HevoData.com
API Docs
Free Trial
  1. Hevo Documentation
  2. Destinations
  3. Data Warehouses

Data Warehouses

  • Articles in this section
    • Amazon Redshift
      • Loading Data to an Amazon Redshift Data Warehouse
    • Databricks
    • Firebolt
      • Mapping Events to Firebolt Tables
        • Configuring Fact and Dimension Tables
    • Hevo Managed Google BigQuery
      • Connecting BI Tools to Hevo
        • Connecting Google Data Studio to Hevo
        • Connecting Tableau to Hevo
        • Connecting Chartio to Hevo
        • Connecting Looker to Hevo
        • Connecting Metabase to Hevo
        • Connecting Microsoft Power BI to Hevo
        • Connecting Redash to Hevo
    • Google BigQuery
      • Clustering in BigQuery
      • Partitioning in BigQuery
      • Loading Data to a Google BigQuery Data Warehouse
      • Google BigQuery
      • Near Real-time Data Loading using Streaming
    • Snowflake
      • Loading Data to a Snowflake Data Warehouse
Last updated on 14 Feb 2022
Was this page helpful?

© Hevo Data Inc. 2022. All Rights Reserved.
Privacy Terms of Service