--- title: "Release Notes - Jun 2023" slug: "release-note-2023-06" updated: 2024-09-10T11:35:31Z published: 2024-09-10T11:35:31Z canonical: "documents.trocco.io/release-note-2023-06" --- > ## Documentation Index > Fetch the complete documentation index at: https://documents.trocco.io/llms.txt > Use this file to discover all available pages before exploring further. # 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](/docs/data-source-google-analytics4). ![image.png](https://cdn.document360.io/3a3bae1e-f157-487f-8798-01e9d820e760/Images/Documentation/release-note-2023-06-2024-08-29-14-57-0.png) ### 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](/docs/data-destination-snowflake#%E8%BB%A2%E9%80%81%E3%83%A2%E3%83%BC%E3%83%89%E3%81%AB%E3%81%A4%E3%81%84%E3%81%A6). ### 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](/docs/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](/docs/configuration-of-input-files). ### 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.](/docs/data-source-zendesk-support#%E3%83%87%E3%83%BC%E3%82%BF%E5%8F%96%E5%BE%97%E5%AF%BE%E8%B1%A1%E3%81%ABticketmetrics%E3%82%92%E9%81%B8%E6%8A%9E%E3%81%97%E3%81%9F%E5%A0%B4%E5%90%88) ### 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](/docs/managed-etl-configurations#%E8%BB%A2%E9%80%81%E5%85%83postgresql%E3%81%AE%E5%A0%B4%E5%90%88) for various entry fields. ![image.png](https://cdn.document360.io/3a3bae1e-f157-487f-8798-01e9d820e760/Images/Documentation/release-note-2023-06-2024-08-29-14-57-1.png) ## 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) | | --- | --- | | ![image.png](https://cdn.document360.io/3a3bae1e-f157-487f-8798-01e9d820e760/Images/Documentation/release-note-2023-06-2024-08-29-14-57-2.png) | ![image.png](https://cdn.document360.io/3a3bae1e-f157-487f-8798-01e9d820e760/Images/Documentation/release-note-2023-06-2024-08-29-14-57-3.png) | ## 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!**