July 2023 Release Notes

What's New? 🚀

Features

• Variable Looping in Action Rivers - This feature brings a groundbreaking change to how variables are managed in the REST Action River. It introduces a smooth and efficient method of iteration by allowing you to loop directly within the Action, using a list of parameter values. This eliminates the need to iterate over Source to Target Rivers for each endpoint individually.
  Please note that the availability of this feature is currently limited. If you would like to use it, please feel free to contact us. The feature is scheduled to be fully released in the upcoming month.

• Unity Catalogs in Databricks Connection - Users now have the ability to set a Default Catalog at the Databricks Connection page. When a Default Catalog is selected, it will be applied to all the Rivers that make use of the corresponding Databricks connection.

• Reserved Words in Redshift as a Target - Previously, we only allowed reserved words in the table column names. With the latest update, we have extended this support to include table names as well.

• The Plans & Billing page has been enhanced to offer a detailed analysis of account usage, specifically focusing on the expenditure and remaining RPUs. This comprehensive breakdown provides valuable insights into how RPUs are used and the overall account balance.

  

Sources Updates

• Oracle's latest update includes support for Change Data Capture (CDC), a fast and effective method that continuously retrieves data from databases using Redo Logs. It enables real-time data synchronization and reduces data latency for efficient integration processes.
• Google Analytics 4 now includes support for Predefined Reports. This enhancement streamlines data interpretation and empowers users with ready-to-use reports, saving time and effort.
• TikTok API was updated to version 1.3.

Kits ⭐

JIRA Changelog to Snowflake Kit enables the extraction of data from various JIRA entities, generating both a historical changelog for JIRA issues and an issue table featuring custom fields as separate columns. Leveraging Rivery's predefined reports feature, this Kit efficiently retrieves data from JIRA entities, including issues, issue fields, projects, users, groups, group users, and resolutions.

The YouTube Reporting Kits offer a powerful integration of data by combining the Analytics and Dimensions reports, specifically focusing on the user level. This integration results in the creation of a comprehensive and informative table that provides valuable insights into both user behavior and video performance on a weekly basis. Furthermore, it enables you to conveniently load this data into your data warehouses, including:

• YouTube Reporting to BigQuery

• YouTube Reporting to Snowflake.