Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Reply
maxkent
New Contributor II

SQL Endpoint alerts for void columns

Hi everyone,

 

since two days we started noticing a warning in the SQL Endpoint stating that some colums (void ones) are not supported.

maxkent_0-1727343720834.png


All good, except that in our case as you can see per the screenshot below, out column is NOT void at all! 

 

How is that behaviour present?

4 REPLIES 4
Anonymous
Not applicable

Hi @maxkent ,

 

The error message indicates that the data type of the “monthlyworkdayspy” column is not supported. Although the column actually contains numeric data, it is incorrectly labeled as a VOID type (no type or null type).

 

This could be due to:

 

The metadata used by the SQL endpoint may be out of date or corrupt. Try refreshing or reloading the metadata.

 

Data types may have been incorrectly converted during data transfer or processing. Try reimporting the data to see if that solves the problem.

 

Best Regards,
Yang
Community Support Team

 

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

maxkent
New Contributor II

Hi,

 

thanks for this.

 

Can you suggest on how to do this?

The metadata used by the SQL endpoint may be out of date or corrupt. Try refreshing or reloading the metadata.

Anonymous
Not applicable

Hi @maxkent ,

 

Look for the option to refresh metadata in the SQL endpoint interface. The highlighted icon in the upper left corner of the screenshot is for refreshing metadata, clicking on this icon should refresh your metadata or data views.

vhuijieymsft_0-1728280706904.png

 

If the problem persists after refreshing, you can try reimporting the data.

 

Best Regards,
Yang
Community Support Team

 

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

Joshrodgers123
Contributor III

How did you get dark mode here??

Helpful resources

Announcements
Users online (4,086)