Release Notes - Jun 2023

Hello! Release information for June 2023!

ETL Configuration

Data Source Google Analytics 4 is new 🎉.

Data Source Google Analytics 4 is newly added.
Data can still be transferred using TROCCO after moving from the previous version of GA (UA) to GA4.
For more information, see Data Source - Google Analytics 4.

UPSERT (MERGE) added to Data Destination Snowflake's transfer mode 🎉.

UPSERT (MERGE) has been added as a transfer mode.
If there is a record in the existing table based on the UPSERT key, the record is updated; if there is no record, the record is appended.
For more information, see Data Destination - Snowflake.

Data Source TROCCO to support Data Mart and Workflow historical data transfer 🎉.

Data Mart and****Workflow have been added to the list of data to be transferred.
ETL Job transfers historical data about previously executed data mart and workflow jobs.
For more information, see Data Source - TROCCO.

XML (beta version)" has been added as an input file format for some Connectors 🎉.

XML files can now be selected as the input file format for ETL Configuration for some Data Source file and storage-based Connectors.
For more information, see About input file format settings.

Data Source Zendesk Support added ticket_metrics as a target to retrieve data 🎉.

Ticket_metrics has been added to the data acquisition target.
Various indicator data about the ticket, such as the date and time it was resolved and the time of the first reply, can now be retrieved and forwarded.
For more information, see Data Source - Zendesk Support.

Data Source TikTok Ads supports loading of Advertiser IDs 🎉.

Support for loading of advertiser IDs has been added.
By clicking on "Load Advertiser ID, " the advertiser ID associated with the Connection Configuration you selected earlier will be suggested.
This allows you to create ETL Configurations without having to manually enter the advertiser ID.

Managed ETL

Add PostgreSQL as Data Source

PostgreSQL can now be selected as the Data Source for Managed ETL.
You can import PostgreSQL tables in a batch and create the associated ETL Configuration in one place.
See Managed ETL Configuration for various entry fields.

UI・UX

Expanded edit area on workflow edit screen

The add task sidebar on the workflow editing screen can now be opened and closed.
By closing the sidebar, a larger display area can be used for workflow editing.

Sidebar (open)	Sidebar (closed)

Other

• Data Destination Amazon Redshift Allows Specifying Batch Size
• Allow JDBC drivers to be selected in MySQL Connection Configuration
• Improved visibility of data lineage on data mart detail pages

**The contents of this release are described above. **
**Please feel free to contact our Customer Success Representative if you have a release you are interested in. **
Happy Data Engineering!