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