How do I set up a Postgres SQL destination?

The SQL destination requires a specific schema and tables to exist before delivery.

The SQL destination requires a specific schema and tables to exist before delivery. To set it up:

1

Create a schema named terra (the name is fixed, not freely choosable).

2

Create the terra_users, terra_data_payloads and terra_other_payloads tables.

3

Set the Scheme field to the database type (postgres or mysql), not a custom value, or delivery will return 500.

reference_id is stored in the users table; join it on user_id to associate data with your internal users.

Updated payloads (for example revised dailies) are inserted as new rows with a new created_at rather than overwriting, since there is no unique constraint. Deduplicate downstream.