Release Notes - July 2022

Hello! We will bring you the release information for 07/2022!

Data Catalog

Table information

Column-based data lineage capabilities

The Data Catalog feature now automatically generates column-based data lineage.
By referring to data lineage, you can investigate the relationship between the columns you plan to use in your analysis based on the data of the columns.

Add basic metadata

You can now define basic metadata in the Table Info/Column Info tab.
You can define a "logical name" and "description" for each table.

The defined logical name is displayed in the table list and on the search result screen, so you can check what table it is at a glance.

Multiple user-defined metadata can be displayed on the column information screen

Metadata defined by customers can now be viewed on the column list of each table.

The above settings can be set from "User-defined metadata template".

Adding a favorites feature

The table "favorites" feature has been implemented.
You can add or remove favorites by clicking the star icon.
Tables that you have favorited are displayed at the top of the table list.

Forwarding settings

Destination Google Drive added 🎉

It is possible to transfer csv files etc. to the Google Drive folder used by the customer.
Please see below for the information you need to use it.

• Connection Information
• Forward to

Transfer source Marketo so that program members can obtain

It is possible to acquire target persons (program members) for various measures set up and implemented on Marketo.

When acquiring statically specific leads in the transfer source Marketo, it is possible to filter by list ID.

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

Source Salesforce supports OAuth authentication

Until now, only authentication by ID/PW was supported, but now you can use the Salesforce connection information created by OAuth authentication.

Note that the forwarding destination Salesforce, source Salesforce reports, and source Tableau CRM do not support OAuth authentication at the time of release.
For more information, please refer to the following help pages:
https://documents.trocco.io/docs/connection-configuration-salesforce

In the transfer source Shopify, so that the transaction object can be retrieved

It is now possible to acquire monetary transaction data (transaction data) related to the order held on Shopify.

By combining it with other data, you can analyze data on Shopify to a higher level.

Workflow

Added automatic retry function for workflow jobs

When a workflow fails, automatic retry is now possible.
You can set the number of automatic retries from the entire workflow setting screen.

If a child or grandchild's workflow job executed on a workflow job stops in the middle, it can be re-executed from the stopped position.

In the conventional workflow, when the parent's workflow job is reexecuted, the workflow job of the child or grandchild is executed from the beginning.
It was difficult to use when the workflow job of children and grandchildren was successful until halfway.
With this update, workflow jobs for children and grandchildren are now executed from the middle, just like parent workflow jobs.

UI/UX

Localization

The following features are now available in English:

• Data Transfer
• Datamart Definition
• Operational support
• Account settings

In addition, the following renovations have been added.

• The locations that can be specified in BigQuery integration have been modernized.
  • It is possible to connect to locations that could not be transferred before.
• The NUMRIC type can now be specified in the output option of the transfer source BigQuery.

That's all for this release.
If you have any releases that interest you, please feel free to contact our Customer Success Representative.
Happy Data Engineering!