Release Notes - October 2023
    • PDF

    Release Notes - October 2023

    • PDF

    Article summary

    Hello! Release information for October 2023!


    Account User

    Add the ability to delete users 🎉.

    Users registered to a TROCCO account can now be deleted from TROCCO.
    In the future, users can be removed without contacting our Customer Success.
    See Deleting Users for more information, including permissions required to delete users.

    Connection Configuration operation restrictions can now be applied on a per-user basis 🎉.

    It is now possible to prohibit individual users from creating, editing, or deleting Connection Configuration.
    By limiting the number of users who can create Connection Configurations, you can prevent connections to data sources to which they are not intended to connect, such as privately managed storage.
    This reduces the risk of unintended data leakage.
    For more information, see User Settings.

    image.png

    Organization ID to be visible on the TROCCO screen 🎉.

    The organization ID is now displayed in the pop-up menu for logged-in users.
    Organization ID is a required field when logging in.
    In the unlikely event that you forget your organization ID, please ask a user who is already logged in to confirm your organization ID from the menu above and notify us.
    image.png

    UI・UX

    Support for reordering columns in ETL Configuration by drag-and-drop 🎉.

    Columns can now be rearranged by drag-and-drop operation in Column Setting of STEP 2 of ETL Configuration.
    The order of columns can be rearranged with intuitive operations.

    image.gif

    Managed ETL

    Add Snowflake to Data Destination 🎉

    Snowflake can now be selected as a Data Destination for Managed ETL.
    ETL Configuration, which retrieves Data Sources from the Data Source in bulk and transfers them to Snowflake, can be created and managed centrally.
    See Managed ETL Configuration for more information.

    image.png

    ETL Configuration

    Extend the normal system judgment when getting Data Source HTTP/HTTPS data 🎉.

    In STEP 1 of ETL Configuration, a status code can now be specified to determine that the system is normal when acquiring ETL Configuration data.
    For more information, see Data Source - HTTP/HTTPS.

    image.png

    TROCCO API

    TROCCO API now has an endpoint for getting a list of ETL Jobs 🎉.

    The TROCCO API can now retrieve a list of ETL Jobs.
    You can specify any ETL Configuration and get a list of ETL Jobs using that ETL Configuration.
    For more information, see About the TROCCO API.

    Data Mart Configuration

    Faster loading time for data mart job list 🎉.

    The data loading process has been sped up, and the time until the list of data mart jobs is displayed has been shortened.

    Expanded the ability to filter the list of data mart jobs 🎉.

    The filtering format has been changed from the traditional text entry format to a format where the name of the Data Mart Configuration is selected.
    This allows multiple Data Mart Configuration names to be selected as filter criteria for the Data Mart Job List.

    image.png

    dbt linkage

    Allow users to specify any dbt version to be used in a dbt job 🎉.

    The dbt version, previously fixed at dbt Core v1.3, can now be specified arbitrarily.
    On the New/Edit dbt Git Repository screen, you can choose from the following versions

    • dbt Core v1.6
    • dbt Core v1.5
    • dbt Core v1.4
    • dbt Core v1.3

    image.png

    API Update

    Data Source Yahoo! Search Ads

    The version of YahooAdsAPI used in the transfer has been updated from v9 to v10.
    For more information on the new version, please visit the YahooAdsAPI | Developer Center.

    Data Source Google Ad Manager

    The version of the Google Ad Manager API used during transfer has been updated from v202211 to v202305.
    For more information on the new version, see Google Ad Manager API.

    Data Source Facebook Ad Creative and Data Destination Facebook Offline Conversions

    The version of the Facebook API used for transfer has been updated from v16 to v17.
    See Meta for Developers for the new version.

    Other

    • JDBC driver version can be specified in Snowflake Connection Configuration.

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