☁️

Loading data with Airflow

After you install SageRx, the first step is to load some data.

Launch Airflow

Go to localhost:8001 to access Airflow.

Username: airflow

Password: airflow

When you log into Airflow, you will see a list of data sources. In Airflow, these are called DAGs, or “directed acyclic graphs”.

Review this list and toggle the data sources “on” for the ones you want to extract and load into the database.

Try this with the fda_ndc DAG. It should start running as soon as you toggle it on.

💡

NOTE: Some DAGs require you to toggle them “on” and then “trigger” them by pressing the play button.

💡

NOTE: RxNorm (rxnorm) and select other DAGs require a UMLS license key in the .env file. See 💿Installation for more information.

Once the DAG starts running, click the blue “fda_ndc” hyperlink on the main dashboard to see more details about the DAG run.

You should start seeing green squares filling in for each of the “tasks” or steps of the DAG.

If you click “Graph” at the top, you can see the same tasks in a different view to understand the dependencies for each task.

Once all the tasks are green, the data should be available in the database.

← Previous

Installation

Querying the database

On this page