Overview
What it is:
The Hint Data Exporter is a secure, automated tool that delivers your core Hint data directly to S3 or SFTP so you can build reports using Hint data in your existing analytics workflows.
What it does:
Sends daily CSV exports of your Hint data
Delivers structured, joinable files with primary and foreign key identifiers
What’s included:
Data tables covering memberships, patients, invoices, payments and more to help replicate existing reports in Hint
One file per table, delivered in a dated folder
Secure authentication and optional Pretty Good Privacy (PGP) encryption
Entity Relationship Diagram (ERD) and detailed developer documentation to help guide your analyses
Cost:
$500 per month add-on
Requires Core Scale or Core Enterprise package
Data Delivery & Structure
Each daily file includes records that have been created, updated, or deleted within the past 7 days. The first export of the month includes all records. A daily full sync can be enable upon request.
Data exports are delivered daily starting at 12:00 UTC (8:00 AM EST) and includes data up to end of the previous day
Each export is placed in a folder named after the date and time the export started (e.g., the folder 2024-07-27 contains data as of close of business on July 26).
Each folder includes one file per table, using the format: public_{table_name}.csv
The data structure closely mirrors Hint’s underlying product schema with minimal transformation.
Includes select tables and columns containing data from the client’s Hint account(s) and a unique identifier and foreign keys to support joins between tables.
Network/affiliate data is not included in Data Exporter at this time.
Additional queries or data modeling should be performed on your end.
Access an Entity Relationship Diagram (ERD) and detailed developer documentation in your Hint account.
Security & Onboarding
To get started with the Data Exporter, we recommend having a technical contact from your team—such as a Systems Administrator, DevOps Engineer, or Data Engineer—lead the setup process. Your technical contact should be prepared to provide the following in your Hint account during onboarding:
PGP Encryption (Optional): If you would like Hint to encrypt each file before delivery, provide a public PGP key.
For S3 Delivery:
Set up a new S3 bucket
Hint will provide an Identity and Access Management (IAM) policy for you to apply to the bucket
For SFTP Delivery:
Your server URI
The username used for authentication
The desired folder path and filename for file delivery
Any required authentication credentials (key based authentication using your private key is preferred)
IP Whitelisting: All connections from Hint’s servers will originate from these IP addresses:
52.21.105.109
3.217.19.70
Hint does not have a staging environment. All exports are sent directly to production.
Maintenance & Support
Contact support@hint.com or your Account Manager for help with Data Exporter.
What’s in scope:
Investigating and resolving data errors
Considering requests for additional tables or columns
Questions or feedback on where documentation may be unclear or incomplete
What’s out of scope:
Help using the data tables to build specific reports
Help writing complex SQL queries
Debugging SQL errors
Hint reserves the right to do the following without advance notice:
Add new files
Add new columns to existing files
Change column order
Hint will provide a minimum of 30 days’ advance notice before implementing any breaking changes, including column removals, renaming or data type modifications.