Skip to content

Maps Medicare LDS claims data to the Tuva Input Layer so you can easily run the Tuva Project.

Notifications You must be signed in to change notification settings

tuva-health/medicare_lds_connector

Repository files navigation

Apache License dbt logo and version

Medicare LDS Connector

🔗  Docs

Check out our docs to learn about the project and how you can use it.

🧰  What does this repo do?

The Medicare LDS Connector is a dbt project that maps Medicare LDS claims data to the Tuva claims data model which then makes it simple to run the entire Tuva Project. This connector expects your LDS data to be organized into the tables outlined in the LDS data dictionaries.

🔌 Database Support

  • BigQuery
  • Redshift
  • Snowflake

✅  Quickstart Guide

Step 1: Clone or Fork this Repository

Unlike the Tuva Project, this repo is a dbt project, not a dbt package. Clone or fork this repository to your local machine.

Step 2: Import the Tuva Project

Next you need to import the Tuva Project dbt package into the Medicare LDS Connector dbt project. For example, using dbt CLI you would cd into the directly where you cloned this project to and run dbt deps to import the latest version of the Tuva Project.

Step 3: Configure Input Database and Schema

Next you need to tell dbt where your Medicare LDS source data is located. Do this using the variables input_database and input_schema in the dbt_project.yml file. You also need to configure your profile in the dbt_project.yml.

Step 4: Run

Now you're ready to run the connector and the Tuva Project. For example, using dbt CLI you would cd to the project root folder in the command line and execute dbt build. Next you're now ready to do claims data analytics! Check out the data marts in our docs to learn what tables you should query.

🤝 Join our community!

Join our growing community of healthcare data practitioners on Slack!