Issue
Some columns have default values at the time of table creation. However, they are not synced automatically.
Environment
Connector: MySQL
Resolution
The table in which the particular column resides needs to be re-synced. The re-sync will populate the column with the values defined.
Cause
Values set for a column using default
does not generate any DML entries in the change log, so the connector does not recognize the values. As such, it does not write the values into the warehouse.