SELECT(On the tables that are to be loaded, usually all tables)
SHOW DATABASES(this is only necessary if the server was started with the --skip-show-database option)
ROWmode. You can follow these instructions to check if it's enabled and configure it if you are using your own MySQL server: https://debezium.io/documentation/reference/connectors/mysql.html#enable-mysql-binlog
ROWin the parameter group settings for the cluster:
call mysql.rds_set_configuration('binlog retention hours', 24);
staging_for a table named
orders. The destination table name will be
data.* as *to your SQL statement.
orders, it will show up as
split_ordersin Athena with the example given below. Click on NEXT.
Neverwill continuously read updates from your MySQL source.