Documentation
Getting startedInstallationLoading data with AirflowQuerying the databaseFinding tables in pgAdminHow SageRx worksData dictionary
Show me the dataData sourcesSource dataStaging dataIntermediate dataMartsUse cases
Use casesExample queriesQuerying the database
Once you have some data loaded, you’re ready to use the database.
Launch pgAdmin
Go to localhost:8002 to access pgAdmin.
Username: sagerx
Password: sagerx
Write your first query
NOTE: Ensure you have run the FDA NDC Directory (
fda_ndc) DAG to completion before writing this query. See Loading data with Airflow for more information.
- In the left sidebar, click Servers → sagerx → Databases → sagerx → staging
- In the top toolbar menu, click Tools → Query Tool
- Copy and paste the query below into the Query input pane
select
*
from staging.stg_fda_ndc__ndc
limit 100- Click “Execute/Refresh” (▶️) or press F5 - your results will show up in the Data Output pane at the bottom of your screen
NOTE: You have to include the name of the schema (i.e. staging or flatfile) in front of the name of the table.
Looking for more examples of things you can do with SageRx?
← Previous