Forum Discussion

maxkent's avatar
maxkent
Frequent Visitor
1 year ago

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.


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?

data engineering
Lakehouse

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    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's avatar
    maxkent
    Frequent Visitor
    1 year ago

    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's avatar
      Anonymous
      Not applicable
      1 year ago

      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.

       

      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!