Introduction
The RWD Snowflake data warehouse is the cloud analytics platform that holds Natera’s clinical-genomic data. Its core database, CLINICOGENOMICS, is the single governed source of patient demographics, casefiles, partner cohorts, genomic variants, and LLM-extracted clinical events for the Real-World Data team and its internal customers.
What is the RWD warehouse?
Data is fed by dbt-managed Dynamic Tables and the variant pipelines, and consumed through Snowsight worksheets, BI dashboards, and the Cortex analytics agent. This is the entry point for everyone who accesses, queries, or administers that warehouse.
Find your path
| I am a… | I need to… | Go to |
|---|---|---|
| Researcher or Analyst | Get read-only access and start querying | For Researchers & Analysts |
| Data Engineer | Set up SnowSQL, dbt, and a dev environment | For Data Engineers |
| Member of another Natera team | Consume RWD data in your own account | Data Products & Marketplace |
| Anyone | Understand what data is available | Architecture & Data Catalog |
| Anyone | Learn performance best practices | Best Practices & Performance |
| Admin | Grant someone Snowflake access | How to Grant Access |
Environments
The RWD Snowflake accounts are separate from the main Natera Snowflake account. If you do not see them in your Snowsight account switcher, sign in once via the direct sign-in URLs on the For Researchers & Analysts page.
| Environment | Snowflake account | Purpose |
|---|---|---|
| Development (SBX) | WA16250-NATERA_RWD_DEVELOPMENT | Development, testing, experimentation |
| Pre-production (QA) | WA16250-NATERA_RWD_PREPRODUCTION | QA validation before production |
| Production | WA16250-NATERA_RWD_PRODUCTION | Production data for analytics and partner delivery |
Databases
Each environment hosts three databases:
| Database | Purpose |
|---|---|
CLINICOGENOMICS | Primary PHI database. All clinical, genomic, and operational data; all dbt models live here. |
CLINICOGENOMICS_DEID | De-identified mirror for external partners, with HIPAA Expert Determination transforms. |
ANNOTATIONS | Reference annotation data for genomic variant interpretation (gnomAD, ClinVar, CADD, REVEL, AlphaMissense, VEP). |