topic Re: SQL Endpoint alerts for void columns in Data Engineering

SQL Endpoint alerts for void columns

maxkent — Thu, 26 Sep 2024 09:44:40 GMT

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?

Re: SQL Endpoint alerts for void columns

Anonymous — Fri, 27 Sep 2024 02:18:08 GMT

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!

Re: SQL Endpoint alerts for void columns

maxkent — Mon, 30 Sep 2024 11:56:50 GMT

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.

Re: SQL Endpoint alerts for void columns

Anonymous — Mon, 07 Oct 2024 05:59:40 GMT

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

Re: SQL Endpoint alerts for void columns

Joshrodgers123 — Mon, 07 Oct 2024 15:45:28 GMT

How did you get dark mode here??