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.

---

Destinations - Explore Topics

• Familiarizing with the Destinations UILearn how to view, filter, and manage the Destinations created by you or your team.
• Amazon S3Load data from your Pipelines into an Amazon S3 bucket.
• Amazon Aurora MySQLLoad data from your Pipelines into an Amazon Aurora MySQL database.
• SQL ServerLoad data from your Pipelines into a SQL Server database.
• MySQLLoad data from your Pipelines into a MySQL database.
• PostgreSQLLoad data from your Pipelines into a PostgreSQL database.
  • Structure of Data in the PostgreSQL Database
• Connecting to a Local DatabaseLearn how to connect Hevo to a database running on your local system.
• Limitations of using MySQL as a DestinationLearn about the limitations of using MySQL as a Destination for production Pipelines.
• Amazon RedshiftLoad data from your Pipelines into an Amazon Redshift data warehouse.
  • Structure of Data in the Amazon Redshift Data Warehouse
  • Loading Data to an Amazon Redshift Data Warehouse
• Amazon Redshift ServerlessLoad data from your Pipelines into an Amazon Redshift Serverless data warehouse.
• Azure Synapse AnalyticsLoad data from your Pipelines into an Azure Synapse Analytics dedicated SQL pool.
• DatabricksLoad data from your Sources into a Databricks data lakehouse.
• Google BigQueryLoad data from your Pipelines into a Google BigQuery data warehouse.
  • 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
  • Modifying BigQuery Destinations to Use Service Account Authentication
• Hevo Managed Google BigQueryLearn about the Hevo Managed BigQuery data warehouse Destination and how to connect your BI tools to it.
  • Connecting BI Tools to Hevo
• SnowflakeLoad data from your Pipelines into a Snowflake data warehouse.
  • Structure of Data in the Snowflake Data Warehouse
  • Loading Data to a Snowflake Data Warehouse
• Destination FAQsFind answers to frequently asked questions about Destinations.