Release Notes - July 2022
  • 07 Dec 2022
  • PDF

Release Notes - July 2022

  • PDF

Article summary

Note

This is a machine-translated version of the original Japanese article.
Please understand that some of the information contained on this page may be inaccurate.

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.
image.png

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.
image.png

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.
image.png

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 🎉

image.png

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.

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.
image.png

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.
image.png

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.
image.png

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.
image.png

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.
image.png

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

image.png


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!


Was this article helpful?