Other General FAQ

summary When specifying BigQuery as the Data Source, an error may occur if the amount of data transferred is large (1 GB or more is a good rule of thumb). The error can be resolved by following the procedure below. In "STEP1 ETL Configuration...

summary If the Data Source column JSON contains an array and you wish to retrieve and use the value of a specific element, you can take the following steps to retrieve the necessary element. Details Check the Expand JSON Column for the t...

summary TROCCO can process at some transfer rate by default. If you want to transfer at higher speeds, you may be able to improve the transfer rate by augmenting the infrastructure inside TROCCO. For more information, please refer to the detai...

summary TROCCO's ETL Job system logs are basically not deleted and are retained. Details There is no specific retention period for logs generated during the execution of TROCCO's transfer jobs, sync jobs, etc. Basically, it will not be delete...

summary If you wish to use a specific time zone, such as Asia/Tokyo, in the Data Destination column, you can do so by following the steps below. Click on Add Column****in the Column Settings item on the Output Option tab of "STEP2 Data Pre...

Embulk Protocol The restrictions differ depending on whether the Data Source service is file-based or database-based. file-based system S3/GCS/BigQuery/FTP/SFTP, etc. (file format to be specified in the form) The maximum transferable capac...

summary When BigQuey is specified as the data mart, BigQuery scripts can be used for execution queries. TROCCO allows BigQuery scripts to be used for queries when BigQuery is specified in Data Mart Configuration. https://cloud.google.com/bigqu...

summary This is a help page on file compression that can be specified in Data Destination within ETL Configuration. What is File Compression? Files can be compressed for Data Destination to some file/storage-based Connectors. Please refer t...

summary When specifying Data Destination as Data Destination, a SOQL must be prepared for ETL Configuration. This page explains how to create SOQLs from within the Salesforce developer console. Log in to Salesforce. Click on Developer Cons...

summary If you are using the Team feature, the permissions to operate ETL Configurations, Data Mart Configurations, etc. created on TROCCO depend on the Resource Group to which those configurations belong and the relationship of the team to wh...

summary Custom Variable Loop Execution is a feature that can be set when an ETL Configuration/Data Mart Configuration with embedded Custom Variables is embedded on a Workflow definition. This page provides an overview of Custom Variable loop exec...

summary This page introduces how to reflect changes to DWH tables "efficiently" and "without data duplication. Introduction. Data Destination Google BigQuery does not have transfer modes such as``UPSERT or``MERGE . Therefore, the following a...

When TROCCO uses and transfers any other app of information received from Google APIs, TROCCO adheres to the Google API Services User Data Policy, including the Limited Use requirements. For details on Google API Services User Data Policy, please r...

summary TROCCO recommends the following operating environment If you are using an environment that is not recommended, you are not eligible for support. Please understand that we are not responsible for any loss or damage to your property. OS ...

summary This page describes various detailed information about rate plans. Rate Plans TROCCO offers the following fee plans Free Plan Starter Plan Essential Plan Advanced Plan Professional Plan There are differences in the Conn...

summary This page describes the various features and services available when subscribing to a Professional Plan. Resource Augmentation Options Relaxed limit on number of concurrent executions Various service quality assurance (SLA) ...

Summary Effective date The content of this page is effective from December 1, 2024. This page describes maintenance with downtime for TROCCO/COMETA. Two types of maintenance are defined: maintenance performe...