---
title: "Discussion on \"Identify Column Mismatch Between Lakehouse Tables And SQL Endpoint Tables In Fabric\" | Hashnode"
description: "Discussion on \"Identify Column Mismatch Between Lakehouse Tables And SQL Endpoint Tables In Fabric\". Compare Lakehouse tables with SQL Endpoint tables for mismatch"
url: "https://hashnode.com/posts/identify-column-mismatch-between-lakehouse-tables-and-sql-endpoint-tables-in-fabric/67f5aa786cdbd6543d739465"
---

[Feed](https://hashnode.com/feed) /

Discussion

# [Identify Column Mismatch Between Lakehouse Tables And SQL Endpoint Tables In Fabric](https://fabric.guru/identify-column-mismatch-between-lakehouse-tables-and-sql-endpoint-tables-in-fabric?utm_source=hashnode&utm_medium=feed)

Compare Lakehouse tables with SQL Endpoint tables for mismatch

Apr 8, 2025 · 3 min read · fabric.guru  
Read the article

-   [#lakehouse](https://hashnode.com/tag/lakehouse)
-   [#microsoftfabric](https://hashnode.com/tag/microsoftfabric)
-   [#deltalake](https://hashnode.com/tag/deltalake)
-   [#notebookutils](https://hashnode.com/tag/notebookutils)

## Written by

[Sandeep Pawar](https://hashnode.com/@PawarBI)

@PawarBI

  
[View profile](https://hashnode.com/@PawarBI)

Building Data Analytics and Data Science solutions using Microsoft Fabric | Principal PM, Microsoft Fabric CAT

Principal Program Manager, Microsoft Fabric CAT helping users and organizations build scalable, insightful, secure solutions. Blogs, opinions are my own and do not represent my employer.

## Responses 2

Markdown supported · ⌘↵ to post

[unblgamesg](https://hashnode.com/@unblgamesg)

[Aug 29](https://hashnode.com/posts/identify-column-mismatch-between-lakehouse-tables-and-sql-endpoint-tables-in-fabric/67f5aa786cdbd6543d739465/comment/6a924b7f401f3ef290b894c2)

Nice approach. Comparing the Delta schema against the SQL Endpoint schema early can save a lot of debugging later, especially with unsupported types like arrays and TIMESTAMP\_NTZ. Thanks for sharing the utility. [town of salem](https://town-of-salem.github.io/)

[Josh DeVries](https://hashnode.com/@gojomoso)

[Apr 9, 2025](https://hashnode.com/posts/identify-column-mismatch-between-lakehouse-tables-and-sql-endpoint-tables-in-fabric/67f5aa786cdbd6543d739465/comment/67f6aa473a23e306084aadf2)

I see a lot of the errors below. How can this be resolved?

DeltaProtocolError: The table's minimum reader version is 2 but deltalake only supports version 1 or 3 with these reader features: {'timestampNtz'}

[Sandeep Pawar](https://hashnode.com/@PawarBI)

[Apr 9, 2025](https://hashnode.com/posts/identify-column-mismatch-between-lakehouse-tables-and-sql-endpoint-tables-in-fabric/67f5aa786cdbd6543d739465/comment/67f6aa473a23e306084aadf2#reply-67f6ba2762cf124128ef726d)

take a look at my blog : [fabric.guru/working-with-delta-tables-in-fabric-p…](https://fabric.guru/working-with-delta-tables-in-fabric-python-notebook-using-polars)

It's a rust engine error : [github.com/delta-io/delta-rs/issues/2631](https://github.com/delta-io/delta-rs/issues/2631)

If nothing works, use pyspark.