🧩

Staging data

Documentation

🌱Getting started 💿Installation ☁️Loading data with Airflow 💻Querying the database 🔍Finding tables in pgAdmin 💡How SageRx works

Data dictionary

😎Show me the data 📁Data sources 💽Source data 🧩Staging data ✨Intermediate data 🛒Marts

Use cases

⚒️Use cases 💼Example queries

Staging data

The first transformation step results in staging (stg_) tables.

‣

Done

Name	Short Description	Source Data
ATC Drug Class		RxNorm Full
FDA NDC Class	Classes extracted from FDA NDC table.	FDA NDC Directory
NADAC	NADAC staging table.	NADAC
FDA Unfinished Substance		FDA Unfinished
FDA Unfinished		FDA Unfinished
FDA NDC Substance		FDA NDC Directory
FDA Excluded		FDA Excluded
RxNorm Reconfigured		RxNorm Full
FDA NDC		FDA NDC Directory
FDA Enforcement Reports (Recalls)		FDA Enforcement Reports (Recalls)
RxNorm Historical NDCs	Historical NDCs from RxNorm pivoted from JSON to a table for easy access.	RxNorm Historical

‣

To Do

Name	Short Description	Source Data
Orange Book NDC		Orange Book FDA NDC Directory

← Previous

Next →

Intermediate data

On this page

Staging data