💻

Querying 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?

💼Example queries

← Previous

Loading data with Airflow

Finding tables in pgAdmin

On this page