SQL database (Postgres, MySQL)
Last updated
Was this helpful?
Last updated
Was this helpful?
SQL databases are easy to set up and often the go-to choices for less abstracted storage solutions. Terra currently supports Postgres & MySQL.
You will need to ensure your SQL database is publicly accessible. As a security measure, you may implement using the list of IPs above.
Next, create a user with enough permissions to create tables & have read & write access within those tables. You can execute the scripts below based on your database
Data will be stored in tables within your SQL database following the structure below:
Users will be created in the terra_users
table, data payloads will be placed in the terra_data_payloads
, and all other payloads sent will be added to the terra_other_payloads
.
When using as a destination, Terra handles data storage for you. All data payloads will be stored in a Terra-owned S3 bucket, and the download link for each payload will be found under the payload_url
column