Release Notes - July 2022

Hello! Release information for July 2022!

data catalog

Table Information

Column-based data lineage functionality

Column-based data lineage is now automatically generated in the data catalog function.
By referring to the data lineage, you can examine the relationships between the columns you plan to use in your analysis, such as which columns were created from which data.

Adding Basic Metadata

Basic metadata can now be defined on the Table Info/Column Info tab.
For each table, a "logical name" and "description" can be defined.

The defined logical names are displayed in the table list and search results screen so that you can see at a glance what table it is.

Column information screen can now display multiple user-defined metadata

Customers can now view their own metadata on the column list of each table.

The above settings can be configured from the "Template for User-Defined Metadata".

Addition of a favorites function

A "favorite" feature for tables has been implemented.
You can set up favorite addition/deletion by clicking on the star icon.
The favorite table is displayed at the top of the table list.

Transfer Settings

Transfer destination Google Drive is added 🎉.

It is possible to transfer csv files, etc. to your Google Drive folder.
Please see below for the information required to use this service.

• Connection information
• Forwarding Destination

Forwarded to Marketo, so that program members can get

It is possible to acquire the targets (program members) of various measures that are set and executed on Marketo.

When retrieving leads by static in Marketo, the list ID can be filtered.

It is possible to acquire leads for each list that is categorized on Marketo.

Forwarding Salesforce supports OAuth authentication.

Previously, only ID/PW authentication was supported, but now Salesforce connection information created with OAuth authentication can be used.

Note that the destination Salesforce, source Salesforce report, and source Tableau CRM do not yet support OAuth authentication at the time of release.
For more information, please see the help page below.
https://documents.trocco.io/docs/connection-configuration-salesforce

Transaction object can be retrieved from the source Shopify.

It is now possible to retrieve the monetary transaction data (transaction data) associated with an order that is maintained on Shopify.

Combined with other data, the data on Shopify can be analyzed in a more sophisticated manner.

workflow

Added automatic retry function for workflow jobs

Automatic retry is now available when a workflow fails.
The number of automatic retries can be set from the overall workflow settings screen.

If a child or grandchild workflow job running on a workflow job stops in the middle of its execution, it can be re-executed from the stop position.

In the previous workflow, when a parent workflow job is re-executed, the workflow jobs of its children and grandchildren are executed from the beginning,
It was difficult to use when a child or grandchild's workflow job was successfully completed halfway through.
With this update, child and grandchild workflow jobs are now executed from the middle of the process, just like parent workflow jobs.

UI/UX

English-enabled

The following features are now available in English
* Data transfer
* Data mart definition
* Operational support
* Various account settings

In addition, the following modifications and others have been added
* The locations that can be specified in BigQuery integration have been updated.
* Connections to locations that could not previously be transferred are now possible.
* NUMRIC type can now be specified in the output options of the source BigQuery.

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