Forum Discussion

coolie's avatar
coolie
Helper I
1 year ago
Solved

VOID error message in Fabric table SQL endpoint view

I have a Fabric database table (created with PySpark script in notebook). There are no problems flagged in Lakehouse view or in the Semantic model, but in SQL endpoint view I am getting a warning fla...
one lake
  • suparnababu8's avatar
    suparnababu8
    1 year ago

    Hello coolie 

     

    I think it's becuase of your table metadata of the column might be out of dated or corrupted. Please fowllow the below steps.

    • Check the data types of in sparknotebook is to match with SQL end point data types.
    • Refresh the data in your sql end point. 

    •  

    • If issue not solved, delete the table and reload again. 

     

    Please go through this url SQL Endpoint alerts for void columns - Microsoft Fabric Community it might helps you.

     

    Thanks

TimoRiikonen's avatar
TimoRiikonen
Advocate V
1 year ago

I believe this fixed the issue for me:

Don't submit empty string "" to string columns but instead NULL value.

 

IMHO this is a good feature in lakehouse and warehouse: you don't need to compare both against empty string and against null value as only the latter one is accepted.