Release Notes - March 2022

Hello! We will bring you the release information for March 2022!

Data Catalog

Greatly improved query editor usability

Column completion is now displayed

Column completion that was not previously displayed is now displayed.

Metadata is displayed together when displayed in the supplement display

Metadata such as Salesforce's Japanese column names automatically retrieved by the Data Catalog function are now displayed at the time of completion display.
Please use it to choose which columns to use when writing queries.
In the future, we plan to improve the ability to display customer-defined metadata and the ability to choose which metadata to display.

So that details are displayed when completing functions

The function completion view now shows function details and links to BigQuery documentation.

Improved editor color scheme

In the past, the coloring did not recognize the syntax of BigQuery correctly, but it has been improved as shown in the reference image below.

In addition, improvements have been made to make it easier to use, such as improving the completion display logic.

Support for kintone metadata display

You can now browse kintone metadata in the Data Catalog feature.
If you have created a transfer setting that specifies kintone as the transfer source and Google BigQuery as the transfer destination, the "kintone metadata" field is displayed in the table and column information.

Sharding tables under any dataset are displayed together

Previously, sharding tables were displayed separately by date, but the same sharding tables have been improved to be displayed together.

By default, the most recent table information is displayed, but you can switch the date from the select box next to the table name.

* As of 2022/03/31, sharding tables are displayed together only when the display type is "Table View".
Please note that if the display type is "ER diagram display", it will be displayed for each date as before.

Connection Information

OAuth 2.0 can now be selected as the authentication method in the HubSpot connection information

In your HubSpot connection information, you can now select OAuth 2.0 as the authentication method.

Oracle Database connection information supports SSH connection

Oracle's connection information now supports SSH connections, making the connection range wider.
Both password authentication and public key authentication can be used.

Please check the help page for details on how to set it up.

Forwarding settings

Transfer source HubSpot now captures "Pipeline", "Pipeline Stage" and "Assignee"

We've added 'Pipelines', 'Pipeline stages' and 'Assigne' to the source HubSpot's availability.
By linking the pipeline managed on HubSpot with the stage information for each pipeline, it is possible to visualize the status of deals and tickets in more detail.
You can also link contact information with other HubSpot data to analyze and visualize the movement of reps on HubSpot.

Please check the help page for details on how to set it up.

Deleted and archived records can now be retrieved in Salesforce.

SourceSalesforce now has an option to "Extract Deleted and Archived Records".
You will be able to extract deleted records and archived records such as task objects.

Please check the help page for details on how to set it up.

In the transfer destination kintone, "update" and "upsert" are added to the transfer mode.

Transfer modes "update" and "upsert" have been added to the transfer destination kintone.
Until now, you could only input data to kintone, but by setting this setting, you can update kintone data.

Please check the help page for details on how to set it up.

Datamarts

Improved error messages when connection information is specified incorrectly in Snowflake

The error message display has been improved to make it easier for users to identify the cause.

UI/UX

"FTP" listed as a data source has been changed to "FTP/FTPS", and "http" has been changed to "HTTP (S)".

It was possible to use FTPS with the transfer source FTP from the past, but it was changed because it was difficult to understand on the UI.
For the same reason, the notation of the transfer source HTTP has been changed to include HTTPS.
There is no change in the function itself.

In addition, the following renovations have been added.

• At the transfer source RTB House, the items "subCampaignId" and "subCampaginName" can be obtained.
• In the transfer destination spreadsheet, "truncate_insert" is added to the transfer mode.

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!