Applies to: Admins
Overview
Endear can sync your data out to the data warehouse your team already runs, so you can analyze it alongside the rest of your business data.
Endear syncs into your data warehouse (for example BigQuery or Snowflake) rather than directly into downstream tools such as a CDP. Once the data lands in your warehouse, you can route it onward to whatever systems you use.
Supported destinations
Endear can sync to any of the destinations below. Those marked Beta are in limited release.
Data warehouses & analytics
Snowflake
Google BigQuery
Amazon Redshift
Amazon Redshift Serverless
Databricks
Amazon Athena
ClickHouse
MotherDuck (Beta)
Open table formats
Delta Lake
Apache Iceberg (Beta)
Databases
PostgreSQL
Amazon Aurora PostgreSQL
MySQL
Amazon Aurora MySQL
MongoDB
Microsoft SQL Server
Oracle (Beta)
SingleStore (Beta)
Object storage
Amazon S3
S3-compatible storage
Google Cloud Storage
Azure Blob Storage
SFTP
Spreadsheets
Google Sheets
Connection options
Staging buckets: Amazon S3, Google Cloud Storage or Azure Blob Storage
SSH tunneling: AWS, GCP or Azure
Cross-cloud authentication: AWS to GCP role assumption
What data syncs
The sync includes the following tables. Every table carries brand_id / organization_id keys and record_created_at / record_updated_at timestamps so you can join across tables and track changes.
appointments: Appointments booked, along with the calendar, booking link and service they were booked on
brands: Your brands and the organization they belong to
campaigns: A schedule of messages to be sent to a particular audience
contact_methods: The phone numbers and email addresses Endear sends from
conversations: All messages between one of your contact methods and a particular external contact
customers: Individual contacts as ingested into Endear
customer_profiles: Integration-specific customer records that link Endear customers to their records in external systems (for example Shopify or Lightspeed)
integrations: An external data source connected to Endear
marketing_subscriptions: Marketing subscription (consent) statuses for customers
message_attributions: The link between a message and an order attribution
messages: A message exchanged between an Endear user and an external contact
order_attributions: A conversion linked to an order and a message
purchases: Your purchase data as ingested by Endear
purchase_locations: The locations of purchases as defined by your POS systems
teams: A physical store or virtual team
templates: A template for creating messages
users: A person or bot that can access Endear
Full field-level schemas (every column and its description for each table) are available from your account manager or the Endear Solutions team.
Getting started
Data warehouse sync is set up with help from the Endear team. To get started, reach out via live chat or your account manager and let us know which warehouse you use.
Still Need Help?
We are happy to assist you for more 1:1 direction. Reach out to our live chat!