Databricks JDBC driver. Databasemetadata.getColumns does not return columns of VARIANT type

[151640]

Resultset returned by DatabaseMetadata.getColumns does not include the variant column in a table. Only includes the non-variant column.
Databricks JDBC driver 02.06.40.1071

create table tvariant(rnum int, c1 variant);

[filipniziol]

Hi @151640 ,

According to the documentation VARIANT data type in not supported by Databricks JDBC driver.
Here is the list of supported data types:

[151640]

When a vendor announces new features such as a data type, their documentation may need to state if their in-market drivers do not support it or the minimum mandatory version. If they do not, then mutual customers may observe an unexpected behaviour which they may mistakenly think is the application and not the driver etc.

Recommend that the Databricks Product Manager re Databricks driver review and confirm if and when SIMBA will support it.

https://www.databricks.com/blog/whats-new-with-databricks-sql?utm_source=twitter&utm_medium=organic-...