Release Version 2.16 (with breaking changes)

The content on this site may have changed or moved since you last viewed it. As a result, some of your bookmarks may become obsolete. Therefore, we recommend accessing the latest content via the Hevo Docs website.

In this Release

• Upcoming Breaking Changes
• New and Changed Features
• Fixes and Improvements
• Documentation Updates

---

Upcoming Breaking Changes

Sources

• Removing Support for Calendar Events in HubSpot  

  • Effective August 31, 2023, HubSpot will stop supporting the Calendar Events object. As a result, Hevo will stop replicating data for the same.

New and Changed Features

Destinations

• Improved Support of JDBC Driver in Snowflake

  • Updated the JDBC driver to the latest version for the Snowflake accounts hosted on Google Cloud in Hevo. This change does not impact any new or existing Pipelines.

Fixes and Improvements

Security

• Support for ECDSA-Generated Public Key for SSH Connections

  • Added support for public keys generated using the Elliptic Curve Digital Signature Algorithm (ECDSA). With this addition, you can use our ECDSA public key while connecting to a Destination or Source through SSH. ECDSA keys are smaller in size and use advanced mathematical operations, thereby improving the security and performance of your SSH connection.

    Read Connecting Through SSH.

Sources

• Additional Validations while Configuring MySQL Sources

  • Enhanced the connectivity checker to validate additional prerequisites and permissions required to successfully set up a MySQL Source with the BinLog ingestion mode. This prevents any errors that may arise due to insufficient permissions post-Pipeline creation.

    This change is applicable to MySQL Pipelines (all variants) created after Release 2.16 and having BinLog as the ingestion mode.

• Handling of Change Streams Response Documents Larger than 16 MB in MongoDB

  • Enhanced the MongoDB integration to handle files larger than 16 MB and read the entire Change Streams response document during ingestion.

    This change is applicable to MongoDB Pipelines (all variants) created after Release 2.16.

• Optimizing Query Execution in MongoDB

  • Fixed an issue whereby the query executed by Hevo was causing irregularities in capturing the offset, leading to a data mismatch between the Source and the Destination data.

    This change does not impact any new or existing Pipelines.

• Ingestion of Geometry data types from MySQL Sources

  • Fixed an issue whereby some Events in Geometry formats (such as Point, LineString, Polygon, MultiPoint, MultiLineString, MultiPolygon, and GeometryCollection) were not getting ingested from MySQL Sources, leading to Pipeline failure.

    However, if customers are loading any data in Point format to a BigQuery Destination, the values must lie within -90 and +90, as that is the range that BigQuery supports. If the data lies outside this range, customers must contact Hevo Support.

• Move to Version 16.0 of the Facebook Ads Marketing API

  • Effective September 20, 2023, Facebook Ads will deprecate v15.0 of the Marketing API. As a result, starting Release 2.15.3, Hevo replicates data from your Facebook Ads account using Marketing API v16.0.

    This change does not impact any new or existing Pipelines.

• Support for Additional Data Types as Primary Keys in MySQL

  • Enhanced the integration to support tables having decimal, date, datetime, or timestamp data types as primary keys in MySQL Pipelines. Previously, such tables had to be skipped for ingestion to be successful.

    This change is applicable to MySQL Pipelines (all variants) created after Release 2.16 and having BinLog as the ingestion mode.

Documentation Updates

The following pages have been created, enhanced, or removed in Release 2.16:

Account Management

• Team Settings

Data Ingestion

• Hevo-generated Metadata

  • Metadata Column __hevo_id

Destinations

• Amazon Redshift

• Databricks

• Google BigQuery

  • Loading Data to a Google BigQuery Data Warehouse

  • Partitioning in BigQuery

    • Recreating Partitioned Tables from the BigQuery Console

• Hevo Managed Google BigQuery

• Snowflake

Getting Started

• Connecting Through SSH

  • Troubleshooting SSH Connection Errors

    • Unable to Verify SSH Details (New)

Introduction

• About Hevo

• General FAQs

  • Which Transport Layer Security (TLS) protocol version does Hevo support? (Removed and the content merged into Infrastructure Security)

  • How can I authenticate on Hevo? (Removed and the content merged into Team Settings)

  • Does Hevo copy my data anywhere other than the Destination? (Removed and the content merged into Customer Data Retention and Encryption)

• Scheduling a Demo (New)

Pipelines

• Limits on the Number of Destination Columns

• Pipeline FAQs

  • Can I alphabetically sort Events Types listed in the Schema Mapper? (Removed and the content merged into Mapping Statuses)

  • Why is there a mismatch in the count of Events in the Source and the Destination even though I selected the Unique and Incrementing query mode? (Removed and the content merged into Mismatch in Events Count in Source and Destination)

• Transformations

  • Supported Python Modules and Functions

Sources

• Google Analytics 4

• Google Campaign Manager (Deleted)

• Google Drive

• QuickBooks Online

• REST API

• Source FAQs

  • How can I transfer Excel files using Hevo? (Removed and the content merged into Google Drive)

  • How can I load an XML file from an S3 folder using Hevo? (Removed and the content merged into Amazon S3)

• Stripe

• TikTok Ads

• Xero

---

Revision History