mdatool
Healthcare Data Dictionary for the Modern Data Stack
LibraryBlogPricing
mdatool
mdatool

The healthcare data dictionary for dbt, Snowflake, Databricks, and BigQuery. 100,000+ ISO-11179 standard terms, free SQL tools, and AI data modeling.

HIPAA-AlignedEnterprise Ready

Tools

  • SQL Linter
  • DDL Converter
  • Bulk Sanitizer
  • Naming Auditor
  • Name Generator
  • AI Data Modeling
  • HCC Calculator
  • Data Model Canvas

Library

  • Glossary
  • Guides
  • Blog

Company

  • About
  • Contact
  • Pricing

Account

  • Sign Up Free
  • Sign In
  • Upgrade to Pro
  • Dashboard

Legal

  • Privacy Policy
  • Terms of Service

© 2026 mdatool. All rights reserved.

Built for healthcare data engineers & architects.

Blog

Healthcare Data Insights

In-depth guides, tutorials, and best practices for database design, data architecture, and healthcare data modeling.

Filter:All (1)Tools & ComparisonsHealthcare Data ModelingHealthcare Data PlatformsData ModelingHealthcareData ArchitectureSQL & PerformanceDatabase MigrationPharmacyData EngineeringData GovernanceCloud ArchitectureProvider DataRisk AdjustmentDDL & SQLHealthcare StandardsPharmacy DataHealthcare Data Engineering

Healthcare Data Engineering Articles

1 article

Healthcare Data Engineering

NPI Validation in Python: Luhn Algorithm, NPPES Lookup, and Snowflake UDF Guide

Every healthcare data warehouse has a provider dimension table with NPI numbers. Bad NPIs cause claims rejections, failed eligibility checks, and broken provider analytics. This guide shows you how to validate NPIs programmatically — from format checking to Luhn algorithm to bulk Snowflake UDF deployment.

10 min read·May 31
PythonNPI
Read more

Stay Updated

Get the latest healthcare data architecture articles delivered to your inbox.