MENU
      Contents x
      Release Notes - Mar 2023
        Contents

        Release Notes - Mar 2023

          Article summary

          Hello! Release information for March 2023!

          ETL Configuration

          New Data Destination LINE Conversion API 🎉.

          • A new Data Destination LINE Conversion API has been added.
            • Data can be transferred to the LINE server via the LINE Conversion API.
            • It is necessary to map column names and types on TROCCO when creating ETL Configuration.
              See Data Destination - LINE Conversion API for details.
              image.png

          Enhanced filtering in Data Source Google Search Console 🎉.

          • The data to be acquired can now be filtered by dimension filters.
            • Clicking on the Set Details in E TL Configuration STEP 1 will bring up the Dimension Filters.
            • Currently, only PAGE items are supported.
              image.png

          Workflow

          Allow Snowflake to loop through query results 🎉.

          • Custom Variable loop execution now supports Snowflake queries.
            image.png
            • Custom Variable expansion values in a loop run can be set based on the results of a Snowflake query.
            • By storing the values of the tables you want to expand in a Snowflake table, you can define a Workflow in which the expansion values change with each execution.

          UI・UX

          TROCCO home screen UI improvements

          Dashboard expansion

          • Workflow definitions are now displayed on the Dashboard.
            image.png

          Visualization of Connector usage

          • Connector usage is now displayed.
            image.png
          Definition of "Connector in use"
          • A Connector that has created at least one ETL Configuration is counted as a Connector in use.
            • At this time, even if an ETL Job Setting has never been executed, it is counted as a Connector in use.
          • The total number of Connectors in use is expressed as " Number of Data Source Connectors in use + Number of Data Destination Connectors in use ".
            • Data Source and Data Destination Connectors are counted separately.
            • If MySQL were used for both Data Source and Data Destination, the total number of Connectors in use would be 2.

          Improved visibility of Connector list

          • The design of each Connector in the list of supported services has been redesigned.
            • The service selection screen when creating ETL Configuration has been redesigned as well.
              image.png

          Data Catalog

          notice

          Logic for obtaining metadata when using team functions

          • Metadata about the data source (e.g., metadata about MySQL) is obtained by connecting to the data source using Connection Configuration on TROCCO, which is available to Data Catalog managers.
          • When the Team function is used in conjunction with the Team function, only Connection Configuration for which the Data Catalog administrator has the Operator role or higher privileges will be used.

          For more information on this matter, please refer to the specifications for obtaining catalog data and metadata.

          API Update

          Data Destination Facebook Conversions API

          • The Facebook API used for the above Data Destination has been updated from v14 to v15.
          • Please refer to the Meta for Developers documentation for the new version.

          Data Source Shopify

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

          Was this article helpful?