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 queriesFinding tables in pgAdmin
How to find tables using pgAdmin.
Click Servers
Click Databases
Click SageRx
Click Schemas
Datasource schema
Click datasource as one example - this is where the raw data from a datasource is downloaded and stored.
Click Tables to see the list of tables in this schema
Click rxnorm_rxnconso and then click Columns to see all the columns in this table
RIGHT click rxnorm_rxnconso → click View/Edit Data → click First 100 Rows to see some example data in the right-side of the window
Staging schema
Go back to your list of schemas, but this time, click on staging.
While there may be a few views in the staging schema, generally we will use tables.
Click on Tables.
You can see that the staging tables are objects like “dose forms” and “ingredients”.
You can inspect columns and view top 100 rows just like you did with the datasource tables.
Intermediate schema
You can repeat the above steps for the intermediate schema, which will also mostly consist of tables
← Previous
Next →