- Tutorials
- ETL/ELT and Orchestration
- Connection Configurations
- A8.net Connection Configuration
- Connection Configuration for Adobe Marketo Engage
- Amazon DynamoDB Connection Configuration
- Connection Configuration for Amazon Redshift
- Apple Search Ads Connection Configuration
- Connection Configuration for AppsFlyer
- Connection Configuration for Azure Blob Storage
- Connection Configuration for Azure Synapse Analytics
- Connection Configuration for Google BigQuery
- Connection Configuration for Box
- Connection Configuration for Databricks
- Connection Configuration for e-Sales Manager
- Connection Configuration for Facebook Ad Insights
- Facebook Ad Reporting, Conversions, Offline Conversions, Custom Audience Application Creation and Token Acquisition Procedures for Custom Audiences
- freee accounting connection information
- Connection Configuration for GitHub
- Connection Configuration for Google Ad Manager
- Connection Configuration for Google Analytics
- Connection Configuration for Google Analytics 4
- Connection Configuration for Google Cloud Spanner
- Connection Configuration for Google Cloud Storage
- Connection Configuration for Google Drive
- Connection Configuration for Google Play
- Connection Configuration for Google Search Console
- Connection Configuration for Google Sheets
- Connection Configuration for Google Ads
- HTTP/HTTPS Connection Configuration
- HubSpot Connection Configuration
- Connection Configuration for JIRA
- Connection Configuration for KARTE Datahub
- Connection Configuration for kintone
- Connection Configuration for LINE Ads
- Connection Configuration for MongoDB
- Connection Configuration for Microsoft Advertising
- Connection Configuration for Microsoft SQL Server
- Connection Configuration for MySQL
- Connection Configuration for Oracle Database
- Connection Configuration for PostgreSQL
- Connection Configuration for RTB House
- Rtoaster insight+ with Google Account integration Connection Configuration
- S3 Connection Configuration
- Connection Configuration for Salesforce Marketing Cloud Account Engagement
- Connection Configuration for Salesforce
- Sansan接続情報
- Connection Configuration for SHANON MARKETING PLATFORM
- Connection Configuration for Slack
- SmartHRの接続情報
- Connection Configuration for Snowflake
- Square接続情報
- Stripe接続情報
- Tableau Connection Configuration
- Connection Configuration for ValueCommerce
- Connection Configuration for X Ads (Formerly Twitter Ads)
- Connection Configuration for Yahoo! Search Ads and Display Ads (managed)
- Connection Configuration for Zendesk Support
- Zoho Books Connection Configuration
- Connection Configuration for Zoho CRM
- Connection Configuration for Next SFA
- Notes on referencing BigQuery tables generated from SpreadSheets
- Connecting via SSH Tunnel
- Obtain Google Cloud JSON Key
- ETL Configurations
- ETL Configuration List
- Data Sources
- Data Source - A8.net
- Data Source - Adobe Marketo Engage
- Data Source - Amazon Aurora MySQL
- Data Source - Amazon CloudWatch Logs
- Data Source - Amazon DynamoDB
- Data Source - Amazon Redshift
- Data Source - Amazon S3
- Data Source - App Store Connect API
- Data Source - Apple Search Ads
- Data Source - AppsFlyer
- Data Source - Amazon Athena
- Data Source - Azure Blob Storage
- Data Source - Google BigQuery
- Data Source - Box
- Data Source - Cisco Secure Endpoint
- Data Source - Criteo
- Data Source - CrowdStrike
- Data Source - Databricks
- Data Source - Elasticsearch
- Data Source - e-Sales Manager
- Data Source - Facebook Ad Creative
- Data Source - Facebook Lead Ads
- Data Source - Facebook Ad Insights
- Transfer source - freee accounting
- Data Source - FTP/FTPS
- Data Source - GitHub GraphQL API
- Data Source - Google Ad Manager
- Data Source - Google Ads
- Data Source - Google AdSense
- Data Source - Google Analytics
- Data Source - Google Analytics 4
- Data Source - Google Cloud Spanner
- Data Source - Google Cloud Storage
- Data Source - Google Drive
- Data Source - Google Play
- Data Source - Google Search Console
- Data Source - Google Sheets
- Data Source - HTTP/HTTPS
- Data Source - DataSpot
- Data Source - JIRA
- Data Source - KARTE Datahub
- Data Source - kintone
- Data Source - LINE Ads
- Data Source - Microsoft SQL Server
- Data Source - Microsoft Advertising
- Data Source - MongoDB
- Data Source - MySQL
- Data Source - MySQL binlog (CDC)
- Data Source - Oracle Database
- Data Source - PostgreSQL
- Data Source - RDBMS Version Support Chart
- Data Source - Repro
- Data Source - Rtoaster insight+ with Google Account integration
- Data Source - RTB House
- Data Source - Salesforce Report
- Data Source - Salesforce
- Data Source - Salesforce Marketing Cloud Account Engagement
- 転送元 - Sansan
- Data Source - SFTP
- Data Source - Shopify
- Data Source - SHANON MARKETING PLATFORM
- Data Source - Slack
- 転送元 - SmartHR
- Data Source - Snowflake
- 転送元 - Square
- 転送元 - Stripe
- Data Source - Tableau CRM Analytics
- Data Source - TikTok Ads
- Data Source - Treasure Data
- Data Source - X Ads (Formerly Twitter Ads)
- Data Source - TROCCO Web Activity Log
- Data Source - TROCCO
- Data Source - Yahoo! Display Ads (Managed)
- Data Source - ValueCommerce
- Data Source - Yahoo! Search Ads
- Data Source - Zendesk Support
- Data Source - Zoho Books
- Data Source - Zoho CRM
- Data Source - Next SFA
- Data Source - Local Files
- Data Destinations
- Data Destination - Adobe Marketo Engage
- Data Destination - Amazon Redshift
- Data Destination - Amazon S3
- Data Destination - Amazon S3 Parquet
- Data Destination - Azure Blob Storage
- Data Destination - Azure Synapse Analytics
- Data Destination - Google BigQuery
- Data Destination - Box
- Data Destination - Braze
- Data Destination - Databricks
- Data Destination - e-Sales Manager
- Data Destination - Facebook Offline Conversions
- Data Destination - Facebook Custom Audience(Beta Feature)
- Data Destination - Facebook Conversions API
- Data Destination - FTP/FTPS
- Data Destination - Google Ads Conversions
- Data Destination - Google Analytics 4 Measurement Protocol
- Data Destination - Google Analytics Measurement Protocol
- Data Destination - Google Cloud Storage
- Data Destination - Google Drive
- Data Destination - Google Sheets
- Data Destination - Google Offline Conversion
- Data Destination - Data Destination - HubSpot
- Data Destination - KARTE Datahub
- Data Destination - kintone
- Data Destination - LINE Conversion API
- Data Destination - Microsoft SQL Server
- Data Destination - MySQL
- Data Destination - PostgreSQL
- Data Destination - Rtoaster insight+.
- Data Destination - Salesforce
- Data Destination - Salesforce Marketing Cloud
- Data Destination - SFTP
- Data Destination - Snowflake
- Data Destination - Treasure Data
- Data Destination - X Ads (Formerly Twitter Ads) Web Conversions
- Data Destination - Yahoo! JAPAN Ads Display Ads Conversion Measurement API (Beta Feature)
- Data Destination - Zoho CRM
- Common Settings
- Other Settings
- Managed ETL Configurations
- Data Mart
- dbt Integration
- Workflow
- Useful Features
- Connection Configurations
- Data Management
- Data Catalog
- About Data Catalog
- How to Start Using
- Understanding Data (Table Information)
- View and analyze relationships between data (ER diagram, JOIN analysis)
- Defining Data Relationships (see Column Setting)
- Finding data (table/column search)
- Write a query (Query Editor)
- Data Catalog Setting
- Data Store Coordination Management
- List of functions supported by each data store
- Automatic asset capture function
- Automatic metadata acquisition function
- Data Catalog Glossary
- Data Catalog
- Teams
- System Management
- Account Management
- TROCCO Web Activity Log
- FAQ
- Error Handling
- Other General FAQ
- How to resolve the error due to the high volume of transfers from Data Source BigQuery
- How to get the value by specifying the element when the Data Source column's JSON contains an array.
- Can I speed up the transfer rate?
- Retention period for logs of ETL Job system in TROCCO
- How to specify the time zone in the Data Destination column representing the time
- About transferable capacity
- Use of BigQuery Scripts when Creating Data Mart Configuration
- About file compression settings
- How to create a SOQL from the developer console
- Access rights to the created ETL Configuration, Data Mart Configuration, etc.
- Custom Variable Loop Execution
- Efficiently update master tables on DWH without duplication
- Google API Disclosure
- recommended system requirements (software)
- Detailed information about your plan
- More information about Professional Plans
- Maintenance with Downtime
- Release Notes
- List of Release Notes
- リリースノート-2025年01月
- リリースノート-2024年12月
- リリースノート-2024年11月
- Release Notes - October 2024
- Release Notes - Sep 2024
- Release Notes - August 2024
- Release Notes - July 2024
- Release Notes - Jun 2024
- Release Notes - May 2024
- Release Notes - Apr 2024
- Release Notes - Mar 2024
- Release Notes - Feb 2024
- Release Notes - January 2024
- Release Notes - December 2023
- Release Notes - November 2023
- Release Notes - October 2023
- Release Notes - Sep 2023
- Release Notes - August 2023
- Release Notes - July 2023
- Release Notes - Jun 2023
- Release Notes - May 2023
- Release Notes - Apr 2023
- Release Notes - Mar 2023
- Release Notes - Feb 2023
- Release Notes - January 2023
- Release Notes - December 2022
- Release Notes - November 2022
- Release Notes - October 2022
- Release Notes - Sep. 2022
- Release Notes - August 2022
- Release Notes - July 2022
- Release Notes - Jun 2022
- Release Notes - May 2022
- Release Notes - Apr 2022
- Release Notes - Mar 2022
- Announcement
- Terms of Service
summary
Column Settings can be reloaded at Data Setting > Column Setting in ETL Configuration STEP 2.
By reloading the Column Setting, if columns are added or deleted in the Data Source data, or if the query is changed, the Column Setting can be updated to keep up with the changes.
Reloading a Column Setting does not change the existing settings.
The settings for each column that were previously set in the Column Setting and the various settings under Data Setting will not be changed.
Reloading Column Setting is not supported by some Data Source Connectors.
Flow of Reloading Column Setting
Using the CSV file at the time of ETL Configuration creation and a CSV file that has since been modified as an example, this section describes the process of reloading the Column Setting.
CSV file at the time of creating ETL Configuration
The following CSV files were targeted for transfer when the ETL Configuration was created.
hoge,fuga
1,aaa
2,bbb
3,ccc
CSV file after creating ETL Configuration
After creating ETL Configuration, the data to be transferred was changed to the following CSV file.
The fuga column is removed and the piyo column is added.
hoge,piyo
1,true
2,false
3,true
Setup procedure
In the above situation, STEP 2 of the relevant ETL Configuration is displayed.
Under Column Setting in Data Setting, click Reload Column Setting.
Click Reload Column Setting.
It takes a while to reload. Please wait until loading is complete.
Review the differences and click on Apply changes to Column Setting.
Click Preview Changes.
**Be sure to click here. ** Changes will not take effect until you click Preview Changes.
Save ETL Configuration.
The ETL Configuration is saved with the Column Setting reloaded.