Release Notes - Feb 2024

Hello! Release information for Feb 2024!

UI・UX

ETL Configuration list can be filtered by Connection Configuration 🎉.

Connection Configuration has been added as a filter item in the ETL Configuration list.
You can filter by the ETL Configuration in which the specified Connection Configuration is used.
For more information, see List of ETL Configurations > Filter.

ETL Configuration

Expanded the columns of master data for ads that can be retrieved from Data Source LINE Ads 🎉.

Added small_delivery to the column of data retrieved as master data for ads.
Master data for advertisements can be obtained when Master Data (Advertisements) is selected for the Download Typeand Advertisements is selected for the Master Data Type in STEP 1 of ETL Configuration.

Note that to incorporate the small_delivery column in an existing ETL Configuration, you must edit the ETL Configuration and run the Automatic Data Setting.
Select "Execute Automatic Data Setting" on the screen that appears when moving from STEP1 to STEP2 of the Edit ETL Configuration screen, and save it.

Changed the merge key configuration method for Data Destination PostgreSQL 🎉.

The method of setting the merge key when the transfer mode is set to UPSERT (MERGE) in ETL Configuration STEP1 has been changed.
Previously, a merge key had to be set in ETL Configuration STEP 2.
With this change, when UPSERT (MERGE) is selected as the transfer mode in ETL Configuration STEP 1, the Merge Key setting item will appear directly below.

Allow regular expressions to be used to specify the path to the file to be retrieved by Data Source SFTP 🎉.

In ETL Configuration STEP1, the path to the file to be retrieved can now be specified with a regular expression.
For example, if you enter .csv$ in the path regular expression, only csv files under the directory specified by the path prefix will be retrieved.

Microseconds and nanoseconds added to time units for UNIX Time conversion 🎉.

The number of UNIX Time units that can be handled in UNIX Time conversion in ETL Configuration STEP 2 has been expanded.
Microseconds and****nanoseconds can now be selected as the unit of UNIX Time conversion before and after conversion.
For more information, see UNIX Time conversion.

Managed ETL

Add Microsoft SQL Server as Data Source 🎉.

Microsoft SQL Server can now be selected as the Data Source for Managed ETL.
Microsoft SQL Server tables can be imported in bulk, and the associated ETL Configuration can be created centrally.
See Managed ETL Configuration > Data Source Microsoft SQL Server for various entry fields.

Data Catalog

Snowflake version of Data Catalog supports "Automatic Metadata Takeover" and "Column Lineage" 🎉.

Until now, automatic metadata takeover andcolumn linage for Data Catalogs were supported only in the Google BigQuery version.
With this change, the same functionality is now available in the Snowflake version of the Data Catalog.

Workflow

Manually executed Workflow Jobs to show the user who executed them 🎉.

Previously, when a Workflow Job was manually executed, it was not indicated which user executed it.
With this change, the email address of the user who executed the following cases is now displayed.

• When executed by clicking the Execute button on the Workflow definition details screen
• When executed by clicking Re-Execute from the stop position on the Workflow Job Details screen .

Link to the Workflow Job from which it was run 🎉.

Previously, Workflow Jobs that were executed as tasks of another Workflow Job did not indicate by which Workflow Job they were executed.
With this change, a link to the Workflow Job from which it was run is now displayed.

API Update

Data Source Shopify

The version of the Shopify API used for transfers has been updated from 2023-01 to 2024-01.
Please refer to the documentation in the Shopify API reference docs for the new version.

Notice

About TROCCO Web Activity Log Help Documentation

Until now, the help documentation for TROCCO Web Activity Log has been available on the Confluence space.
The help documentation has now been transferred to the TROCCO Help Center. Please refer to the TROCCO Web Activity Log in the future.
The help documentation on the Confluence side will be closed soon.

**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!