Data Source - MySQL binlog (CDC)
- Print
- PDF
Data Source - MySQL binlog (CDC)
- Print
- PDF
Article summary
Did you find this summary helpful?
Thank you for your feedback
summary
Help page for ETL Configuration of Data Setting from MySQL (binlog).
constraints
none in particular
Setting items
STEP1 Basic settings
| (data) item | indispensable | default value | Contents |
|---|---|---|---|
| MySQL Connection Configuration | Yes | - | Select the previously registered Connection Configuration that has the necessary permissions for this ETL Configuration. |
| database | Yes | - | Specify the name of the database containing the data you wish to transfer in MySQL. You can use the auto-completion function when typing. You can also load a list of databases by pressing "Load Database List". |
| table | Yes | - | Specify the name of the table containing the data you wish to transfer. |
| Default time zone | No | - | Enter the server-side time zone setting for MySQL. For example, if the time zone is Japan, enter Asia/Tokyo. |
| schema tracking | Yes | invalid | Schema tracking selects whether to automatically change the schema on the BigQuery side when columns are added, deleted, or changed on the MySQL side. When schema tracking is enabled, if a column named col_new is added on the MySQL side, a column named col_new is also added on the BigQuery side. *For the default type, please refer to the MySQL and BigQuery schema typeshere. |
Was this article helpful?