Destinations

A Destination is any database or data warehouse to which you want to replicate your data. You can configure multiple Pipelines with the same Destination. You can also replicate data from multiple Sources into the same Destination. The data is loaded from all the Pipelines as per the replication schedule you configure for the Destination.

Note: You can use both Hevo UI and API to create Destinations.

You can view the current status of Events being loaded to a Destination by using:

• The Load Status page in the Pipelines Detailed View: This page displays the number of Events being loaded to the Destination by the specific Pipeline.

• Destination Overview page in the Destinations Detailed View: This page displays the status of Events being loaded to the Destination from all Pipelines using that Destination.

Note: Ensure that your Destination is configured correctly. If you try to replicate your data in an inactive or deleted database or data warehouse, the data replication fails.

Once your data is loaded to the Destination, you can use Models to transform the data and present it in a format according to your business requirements. Read SQL Models and Working with SQL Models for more information on transforming your Destination data.

• Articles in this section
  • Familiarizing with the Destinations UI
  • Cloud Storage-Based
    • Amazon S3
      • AWS Regions Supported by Hevo
  • Databases
    • Amazon Aurora MySQL
    • SQL Server
    • MySQL
    • PostgreSQL
      • Structure of Data in the PostgreSQL Database
      • Troubleshooting PostgreSQL Destination
        • Errors During Pipeline Creation
          • Error 1003 - Authentication Error
          • Error 1006 - Connection to host failed
          • Error 1014 - Database does not exist
          • Error 1017 - Connection settings errors
        • Errors Post-Pipeline Creation
          • Remaining connection slots are reserved
    • Connecting to a Local Database
    • Limitations of using MySQL as a Destination
  • Data Warehouses
    • Amazon Redshift
      • Structure of Data in the Amazon Redshift Data Warehouse
      • Loading Data to an Amazon Redshift Data Warehouse
      • Troubleshooting Amazon Redshift Destination
        • Errors During Pipeline Creation
          • Error 1003 - Authentication error
          • Error 1006 - Invalid database hostname
        • Errors Post-Pipeline Creation
          • Pipeline Failure due to Connection Timeout
      • Amazon Redshift FAQs
        • How do I change sort keys and their order in a Redshift Destination table?
    • Amazon Redshift Serverless
    • Azure Synapse Analytics
    • Databricks
      • Troubleshooting Databricks
        • Errors Post-Pipeline Creation
          • Schema Mapping failure due to missing Metadata
    • Firebolt
      • Mapping Events to Firebolt Tables
        • Configuring Fact and Dimension Tables
    • Google BigQuery
      • Clustering in BigQuery
      • Partitioning in BigQuery
      • Structure of Data in the Google BigQuery Data Warehouse
      • Loading Data to a Google BigQuery Data Warehouse
      • Near Real-time Data Loading using Streaming
      • Troubleshooting Google BigQuery
        • Errors Post-Pipeline Creation
          • Billing disabled for project
      • Google BigQuery FAQs
        • Is there a way to specify that the BigQuery objects created should be in a multi-region rather than a single region?
    • 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
    • Snowflake
      • Structure of Data in the Snowflake Data Warehouse
      • Loading Data to a Snowflake Data Warehouse
      • Snowflake
      • Troubleshooting Snowflake
        • Errors Post-Pipeline Creation
          • Hevo could not find your Database
          • Connection timeout
          • Insufficient access
          • Schema not found
          • Snowflake account disabled
          • Warehouse Suspended
      • Snowflake FAQs
        • Can I replicate data in variant (XML) format to my Snowflake Destination?
  • Destination FAQs
    • Can I change the primary key in my Destination table?
    • How do I change the data type of a Destination table column?
    • Can I change the Destination table name after creating the Pipeline?
    • How can I change or delete the Destination table prefix after creating a Pipeline?
    • Why does my Destination have records that are deleted in the Source?
    • How do I filter deleted Events from the Destination?
    • If I remove Hevo metadata columns from the Destination table, are these regenerated in the next load?
    • How do I filter out specific fields before loading data to the Destination?

Revision History