Toast to Amazon Redshift integration

Connect Toast to Amazon Redshift and automatically sync your application data.

Get started free Toast connector

Toast

Data source

Authenticating...

Ready to connect

CONNECTOR SOURCE

Toast to Amazon Redshift

Connect Toast to Amazon Redshift and automatically sync your application data. Weld extracts Records, Users, and Events from Toast, loads them into Amazon Redshift, and lets you transform the data using SQL or dbt, no custom scripts required.

Toast data schema

Open full-page schema explorer

44tables

752fields

59relationships

employee_job_reference

menu_group_option_group

inherit_option_groups

boolean

inherit_unit_of_measure

menu_item_option_group

modifier_group_option

restaurant_service_guid

dining_option_entity_type

string

dining_option_external_id

order_check_selection

item_multi_location_id

string

item_external_id

string

item_group_entity_type

string

item_group_multi_location_id

string

item_group_external_id

string

order_check_selection_applied_tax

order_check_selection_guid

facilitator_collect_and_remit_tax

order_check_selection_applied_discount

order_check_selection_guid

non_tax_discount_amount

order_check_selection_modifier

order_check_selection_guid

item_multi_location_id

string

item_external_id

string

item_group_entity_type

string

item_group_multi_location_id

created_by_client_name

order_check_applied_discount

non_tax_discount_amount

order_check_applied_service_charge

service_charge_entity_type

string

service_charge_external_id

alternate_payment_type

track_break_acknowledgement

creator_or_shift_review_subject_guid

string

approver_or_shift_review_subject_guid

employee1_entity_type

string

employee1_external_id

item_picking_priority

exclude_from_reporting

management_group_guid

string

external_group_ref

string

external_restaurant_ref

string

created_by_email_address

revenue_center_entity_type

string

revenue_center_external_id

service_charge_calculation

job_reference_entity_type

service_area_entity_type

string

revenue_center_guid

string

revenue_center_entity_type

employee_reference_guid

string

employee_reference_entity_type

string

employee_reference_external_id

string

job_reference_guid

string

job_reference_entity_type

string

job_reference_external_id

Open full-page schema explorer

Everything you need to get started

Toast

Setup guide Data schema44 tables Connector page

Amazon Redshift

Setup guide Connector page

Weld Connect API

Set up programmatically

Use the Weld Connect REST API to create Toast connections, configure ELT syncs, and manage pipelines entirely through code. Built for embedding, automation, and CI/CD workflows.

Explore Weld Connect API reference

POST/elt_syncs

# Create a Toast ELT sync
curl -X POST https://connect.weld.app/elt_syncs \
  -H "x-api-key: $API_KEY" \
  -d '{
    "connection_id": "conn_abc123",
    "integration_id": "toast",
    "destination_schema_name": "toast_data",
    "sync_interval": "0 * * * *"
  }'
▌

FAQs

How do I sync Toast data to Amazon Redshift?

Sign up for Weld, connect Toast as a source and Amazon Redshift as a destination. Weld handles the extraction, loading, and lets you transform data using SQL or dbt.

What Toast data can I sync to Amazon Redshift?

You can sync Records, Users, and Events. The available objects depend on your Toast account permissions and configuration.

How often does Weld sync data from Toast?

Sync frequency depends on your Weld plan. Schedules range from every 5 minutes to daily intervals. Each sync processes only new and changed data.

Can I transform Toast data before it lands in Amazon Redshift?

Yes. Weld supports SQL-based transformations in the platform and integrates with dbt Cloud. You can clean, join, and model your data before analysis.

Is the Toast to Amazon Redshift integration secure?

Yes. Weld encrypts all data in transit and at rest, is SOC 2 Type II certified, and supports IP whitelisting. Credentials are stored encrypted and never logged.