{"repo":"tuva-health/medicare_cclf_connector","free":true,"listed":false,"github":"https://github.com/tuva-health/medicare_cclf_connector","clone":"git clone https://github.com/tuva-health/medicare_cclf_connector.git","description":"This connector is a dbt project that maps Medicare CCLF claims data to the Tuva Input Layer.","language":null,"stars":16,"topics":["analytics-engineering","bigquery","data-analytics","data-governance","data-lineage","data-pipelines","data-warehouse","dbt","healthcare","healthcare-analysis"],"license":"Apache-2.0","category":"data-pipelines","readme_excerpt":"Medicare CCLF Connector 🔗 Docs Check out our docs to learn about the project and how you can use it. 🧰 What does this repo do? The Medicare CCLF Connector is a dbt project that maps raw Medicare CCLF claims data to the Tuva Input Layer, which is the first step in running the Tuva Project. This connector expects your CCLF data to be organized into the tables outlined in this CMS data dictionary, which is the most recent format CMS uses to distribute CCLF files. 🔌 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 CCLF 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: Data Preparation Source data: The source table names the connector is expecting can be found in the sources.yml config file. You can rename your source tables if needed or add an alias to the config. File Dates: The field file date is used throughout this connector to deduplicate data received across regular and run-out CCLFs. We recommend parsing this date from the filename (e.g., P.A .ACO.ZC1Y .Dyymmdd.Thhmmsst) and formatting it as \"YYYY-MM-DD\". Enrollment Dates: The CCLF specification does n","default_branch":null,"files":null,"tree":[],"storefront":"/r/tuva-health","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/tuva-health/medicare_cclf_connector/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}