Examples of Amazon S3 Datastores - connect_cdc_sqdata - Latest

Example 1: Static File in AVRO Format

DATASTORE s3://mybucket/employee.dat
     OF AVRO
     AS TARGET
     DESCRIBED BY GROUP SOURCE;

Example 2: Rotated Files in JSON Format

DATASTORE s3://mybucket/cdcdata
     OF JSON
     AS TARGET
     DESCRIBED BY GROUP SOURCE
     STAGING SIZE 4G
     STAGING DELAY 120;