If true, the destination has native support for Primary Keys. This means that when loading into these destinations, Stitch will likely apply Primary Key constraints to Primary Key columns.

If false, the destination doesn’t have native Primary Key support. Historically, destinations have been designed to use a Stitch-created system table to enforce the use of Primary Keys during loading.

If true, the destination natively supports nested data structures. This means that when Stitch loads JSON arrays or objects, the data will be loaded intacct.

If false, Stitch will flatten the nested structures into relational objects (tables and columns).

Additional details about nested structure support.

If true, Stitch will re-name the original column when mixed data types in a single column are encountered.

If true, users can choose which loading-behavior-type their destination uses.

The name of the loading behavior type the destination uses by default.

Must be one of the following:

• Upsert
• Append-only

A list of strings containing the loading behavior type(s) the destination supports. Each behavior type should be its own item in the list - for example:

loading-behavior-types:
  - "Upsert"
  - "Append-only"

Must be one of the following:

• Upsert
• Append-only

Additional info about the loading behavior used by the destination.