Connecting to CMS SNF
This guide provides a step-by-step approach to effortlessly connecting CMS SNF with skyData. The CMS SNF Connector integrates CMS Skilled Nursing Facility data into skyData’s Lakehouse, ensuring compliance, efficiency, and real-time insights by ingesting data via API calls, storing it in azure blob storage, and processing it through Databricks into Delta Lake via Unity Catalog. With Databricks as a fully managed warehouse, SNFs gain real-time insights, personalized reports, and proactive alerts to optimize patient care.To import data using the CMS SNF connector
Follow these steps to create and configure a new dataflow for the CMS SNF import connector:- Navigate to Dataflow > Imports.

- Click New dataflow as indicated by an arrow.

- Enter the desired name for the dataflow in the Name text field.
- Click Next to proceed.

Add CMS SNF connector
- On the Choose Connector page, use the Search feature to locate and select the CMS SNF Connector.
- Enter the Display Name for your dataflow in the provided text field.
- Optionally, add a Description in the designated text area.

- Click Next to proceed.

Connect to the CMS SNF account
- The credentials gets auto populated on the Configuration page.
- Click Connect.

- Scroll down to the Table Details section, select the checkboxes for the tables you wish to import, and use the dropdown menu to label them as either Data or Metadata.

By default, all tables in the Table Details section are selected. You can choose to import only specific tables that are relevant to your data processing needs. For example, to import customer data, select tables containing details like name, email, address, and contact information.
- Click Save to apply the changes.

Run, Edit, and Delete the imported data
Once the table is imported, you can execute, modify, and remove the imported table from the Dataflow. Follow the below steps:- Go to the Dataflow > Imports page.

- Select the horizontal ellipsis under the Actions column and do the following:
- Click Run to execute the dataflow. Once the execution is successful, the data pipeline status will update to Completed, as illustrated in the figure below.

In the Dataflow’s Run History Description, you can view error messages related to data import failures from a data source. Additionally, you can check the status, start time, and end time of the data pipeline execution.

