Overview

NPI Registry Public Search is a free directory of all active National Provider Identifier (NPI) records. Healthcare providers acquire their unique 10-digit NPIs to identify themselves in a standard way throughout their industry.

Setup guide

Follow our step-by-step setup guide to connect NPI data to Snowflake using EasyConnect.

Capabilties

This connector is fully functional with the weekly incrementals files provided on the NPI Files webiste.

Feature	Supported
Incremental Changes	Yes
Incremental API Requests	Yes
Capture Deletes**	Yes

Sync overview

NPPES provides NPI data in 2 different zip files. The larger zip file contains historical data once per month, while the smaller zip file contains the delta each week. During the initial load, the historical data is uploaded followed by every weekly file up to the latest weekly file. During incremental loads, only the weekly file is loaded. New weekly files are checked daily.

Each zip file is composed of several different files. Only the main npidata pfile file is loaded, which contains the FOIA-disclosable NPPES provider data.

Data from the weekly file is loaded using an "insert or update" strategy, using the NPI column as the primary key. If there is a match, the record is updated. If there is no match, the record is inserted.

Schema information

There is currently no UML because there is only one table.