Data catalog
Data catalogUse cases
Use casesExample queriesDocumentation
Getting startedInstallationLoading data with AirflowQuerying the databaseFinding tables in pgAdminHow SageRx worksQuerying 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 → sagerx_dev
- In the top toolbar menu, click Tools → Query Tool
- Copy and paste the query below into the Query input pane
select
*
from sagerx_dev.stg_fda_ndc__ndcs
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. sagerx_dev or sagerx_lake) in front of the name of the table.
Looking for more examples of things you can do with SageRx?
← Previous