Skip to main content

Data Exporter

CC Canepa avatar
Written by CC Canepa
Updated over a week ago

Overview

What it is:

The Hint Data Exporter is a secure, automated tool that delivers secure, daily csv exports of your core Hint data directly to S3 or SFTP so you can build reports using Hint data in your existing analytics workflows.

What’s included:

  • One file per table, delivered in a dated folder.

  • Secure authentication and optional Pretty Good Privacy (PGP) encryption.

For Standard Data Exporter:

  • Structured, joinable files with primary and foreign key identifiers

  • Over 40 data tables covering memberships, patients, invoices, payments and more to help replicate existing reports in Hint

  • Entity Relationship Diagram (ERD) and detailed developer documentation to help guide your analyses

For Customized Data Exporter:

  • A single file containing the agreed on columns and data

Cost:

Standard Data Exporter:

  • $500 per month add-on

  • Requires Core Scale or Core Enterprise package

Customized Data Exporter:

  • $500 one time setup fee

  • $50 per month add-on

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 (Admin > Data Exporter > Settings):

    1. PGP Encryption (Optional): If you would like Hint to encrypt each file before delivery, provide a public PGP key.

    2. 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.

    3. For SFTP Delivery:

      • SFTP Host

      • SFTP Username

      • SFTP Private Key

  • 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.

Data Delivery

  • Choose between a daily full sync or incremental sync (i.e., 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.)

  • Data exports are delivered daily starting at 12:00 UTC (8:00 AM EST) and include data up to end of the previous day

  • Exports use the following naming convention: YYYYMMDDHHMMSS / public_{table_name}.csv

    • Each export is placed in a folder named after the date and time the export started in the format YYYYMMDDHHMMSS (e.g., the folder 20240727121114 was sent 2024-07-27 at 12:11:14 UTC and contains data as of close of business on July 26)

    • Each folder includes one file per table, using the format public_{table_name}.csv

  • Users with an Admin role can view Data Exporter Settings and monitor the sending of Exports under Admin > Data Exporter.

Standard Data Exporter Structure

  • 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 under Admin > Data Exporter > Exports.

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 standard data exporter 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 with the standard data exporter 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.

FAQ

Can Hint send data directly to Tableau?

Hint sends data to SFTP or S3 and it's up to you to get the data from SFTP to Tableau via a Data Warehouse.

Recommended users of Hint Data Exporter have, at minimum:

  • SFTP or S3

  • Data Warehouse to ingest data from SFTP or S3 (popular examples include Snowflake or Redshift)

  • A Business Intelligence (BI) tool to visualize data in the warehouse (popular examples include Tableau or Looker)

Did this answer your question?