Other General FAQ

summary When specifying BigQuery as the transfer source, an error may occur if the transfer volume is large (1 GB or more is the standard). The error can be resolved by following the procedure below. Add "*" to the end of the path to be enter...

summary If the JSON of the source column 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...

summary This section describes how to issue the webhook URL required for notifications to Slack. Procedure for issuing a Webhook URL The previous procedure of issuing a Webhook URL using the Webhook URL creat...

summary TROCCO can process at some transfer rate even by default. If you wish to transfer at higher speeds, the transfer rate can be increased by augmenting TROCCO's internal infrastructure.

summary TROCCO's transfer 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 transfer jobs, sync jobs, etc. Basically, it will not be del...

summary If you wish to use a specific time zone, such as Asia/Tokyo, in the destination column that indicates the time, you can do so by following the steps below. Click "Add Column" in the "STEP2 Data Preview/Detailed Settings" Output Op...

Embulk Protocol The restrictions differ depending on whether the transfer 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 c...

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 the data mart definition. https://cloud.google.com/bigq...

summary Help page for file compression that can be specified in the destination within the transfer settings. What is File Compression? Files can be compressed for transfer to some file/storage system connectors. Please refer to the help do...

summary When specifying Salesforce as the destination, SOQLs must be prepared for forwarding settings. This page explains how to create SOQLs from within the Salesforce developer console. Log in to Salesforce. Click on Developer Console f...

summary If you are using the Team function, the permissions to operate transfer settings, data mart definitions, etc. created on TROCCO depend on the resource group to which those settings belong and the relationship of the team to which the l...

summary Custom variable loop execution is a feature that can be set when transfer settings and data mart definitions with embedded custom variables are incorporated on a workflow definition. This page provides an overview of custom variable loop ...

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

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. When TROCCO uses and transfers any other app of information re...

summary TROCCO recommends the following operating environments 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 rate plans Free Plan Starter Plan Essential Plan Advanced Plan There are differences in the connectors and features...

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) ...