Data Sources
The foundations of all things data at Pair Team.
Overview
We have four primary data sources that feed into our analytics platform:
| Source | Description | Data Loading Method | Refresh Rate |
|---|---|---|---|
| Arc | Our internally developed and maintained application | Direct ingestion from application database | Hourly |
| Elation | Electronic health record (EHR) system | Snowflake data share | Every 1-3 hours |
| Zus | Health data aggregation platform | Snowflake data share | Every 1-3 hours |
| Regal | Customer engagement and communications platform | Snowflake data share | Every 1-3 hours |
Data Flow
How do we deliver data to our users?
These data sources are brought together in our Snowflake data warehouse (also referred to as our data lake). We then apply transformations and joins across these data sources using dbt (an open-source tool for data transformation). The transformed data is passed to Looker, our business intelligence tool, which serves as the primary interface for end users to access and analyze our data.
Accessing Raw Data
warning
Raw data can only be accessed directly within Snowflake. To obtain Snowflake access, please reach out to the Infrastructure team or the Data team.