VOID error message in Fabric table SQL endpoint view

[coolie]

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 flagged for a column of type string :

"Columns of the specified data types are not supported for (ColumnName: '[CommandCode] VOID')"

• If I perform this query: '... WHERE CommandCode IS NULL' there are no records found.
• For this query: '... WHERE CommandCode=''' there are many matches as expected.

I have tried resyncing and refreshing but still get the same message. As I cant match the offending records I cant correct them. Is this anything to be concerned about?

[TimoRiikonen]

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.

[v-csrikanth]

Hi @coolie 
It's been a while since I heard back from you and I wanted to follow up. Have you had a chance to try the solutions that have been offered?
If the issue has been resolved, can you mark the post as resolved? If you're still experiencing challenges, please feel free to let us know and we'll be happy to continue to help!
Looking forward to your reply!

Best Regards,
Community Support Team _ C Srikanth.

[v-csrikanth]

Hi @coolie 
We haven't heard from you since last response and just wanted to check whether the solution provided has worked for you. If yes, please Accept as Solution to help others benefit in the community.
Thank you, 
Cheri Srikanth.

[v-csrikanth]

Hi @coolie 
As highlighted by @suparnababu8 , the proposed approach appears to effectively address your requirements. Could you please confirm if your issue has been resolved?
If you are still facing any challenges, kindly provide further details, and we will be happy to assist you.

Thank you,
Cheri Srikanth

[suparnababu8 · Accepted solution]

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