Formsort
Search…
Formsort
Formsort documentation
Building flows
Core concepts
Adding content
Content types
Conditions and logic
Schemas
Redirects
Styling and themes
Publishing and versions
Handling data
Philosophy
Data Retention
Responder UUIDs
Environments
Passing data in
Getting data and events out
Integration reference
Amplitude
BigQuery
FullStory
Google Analytics
Google Tag Manager (GTM)
Optimizely
PostgreSQL
Redshift
S3
Segment
Stripe
Webhooks
Zapier
Going live
Custom domains
Built-in analytics
Embedding
Split testing
Preflight checklist
Teams
Accounts
Event subscriptions
Powered By GitBook
Redshift
Insert answer submissions as rows in Amazon Redshift

Authentication

To allow Formsort to write to Redshift, create a new user with insert permissions to the schema that contains your data table. You can then add the credentials for the user directly into Formsort.
Do not reuse a user with more permissions than are necessary to INSERT rows - Formsort does not even need SELECT access, and should not have any administrative permissions.
Make sure your Redshift server is set to public! By default, Redshift servers in AWS are set to private.

Schema

Because the Formsort user should not have administrative permissions, you must create it yourself, using a SQL command or the AWS UI.
Create a table named answer_set with the following fields:
Field name
Type
Description
id
INTEGER (IDENTITY)
An auto-incrementing ID, like a primary key.
submitted_at
TIMESTAMPTZ
When the answers were received by Formsort.
responder_uuid
CHAR(36)
flow_label
VARCHAR
The flow label.
variant_label
VARCHAR
The variant label.
variant_revision_uuid
CHAR(36)
The variant revision UUID.
event_type
VARCHAR
The analytics event this answer set corresponds to, either StepCompleted or FlowFinalized
answers
VARCHAR(65535)
The answers, as a JSON string.
schema_version
SMALLINT
The version of the redshift adapter (currently 1)
​
Previous
PostgreSQL
Next
S3
Last modified 4mo ago
Copy link
Contents
Authentication
Schema