Data Virtuality Platform 3.10: new Klaviyo connector, Criteo improvements, and some bug fixes

We've fixed two bugs affecting the Server. Now it works correctly with BigQuery's SNAPSHOT tables, and can connect properly to a MongoDB replicaSet.

The Studio/Exporter got one, but important bug fix: previously, opening the Exporter failed if the user had limited permissions. Now all works correctly.

As for the connectors, we've upgraded our Klaviyo connector to support all the new API features.

The Criteo connector has also received an important upgrade (which will take the rest of this announcement): we've switched from MAPI to versioned API (namely, the connector has been updated to API v2023.04). It means that the previous version of the connector no longer works, and the current version of the connector implements new procedures that use the endpoints of the new Criteo API and changes some of the existing procedures.

First, we've added five new procedures (PlacementReport, AdvertisersReport, Campaigns, CategoryBids, and DisplayMultipliers). Second, we've corrected three existing procedures. For the AdSets procedure, we've changed the datatypes of the attributes_campaignId column, added four new columns (attributes_datasetId, attributes_mediaType, attributes_targeting_frequencyCapping_frequency, and attributes_targeting_frequencyCapping_maximumImpressions). For the AdsetReport procedure, we've added three new parameters (adSetIds, adSetNames, and adSetStatus), and  changed the type of a number of columns: Year, CategoryId, AppInstalls, Clicks, Displays, ExposedUsers, NonViewableDisplays, OmnichannelSalesAllPc30d, OmnichannelSalesAllPv24h, OmnichannelSalesClientAttribution, OmniChannelSalesPc30d, OmnichannelSalesPv24h, PostInstallSales, PotentialDisplays, QualifiedVisits, SalesAllClientAttribution, SalesAllPc1d, SalesAllPc30d, SalesAllPc30dPv24h, SalesAllPc7d, SalesAllPv24h, SalesClientAttribution, SalesOfflinePc30d, SalesOfflinePv24h, SalesPc1d, SalesPc30d, SalesPc30dPv24h, SalesPc7d, SalesPv24h, UntrackableDisplays, ViewableDisplays, Visits). Finally, for the TransactionsReport procedure, we've removed the AventType column and corrected the type of TransactionId as it may contain "undefined" value.

Last but not least, the Criteo connector received a fix for the bug causing the pipes__AdsetReport to fail with "In column CategoryId is an invalid long format in STRING" error. Now all is well.

Here are all issues in this release:

Server

• DVCORE-7898 (Bug Fix): BigQuery: SNAPSHOT tables are not supported
• DVCORE-7257 (Bug Fix): MongoDB: connection to replicaSet is not possible

Studio/Exporter

• DVCORE-8047 (Bug Fix): opening exporter fails for users with limited permissions

Connectors

• SQL-616 (New Feature): Klaviyo: add support for the new API features to the connector
• SQL-572 (Improvement): Criteo: update the connector to API v2023.04
• SQL-408 (Improvement): Criteo: switch from MAPI to versioned API
• SQL-483 (Bug Fix): Criteo: pipes__AdsetReport fails with "In column CategoryId is an invalid long format in STRING" error