topic Databricks JDBC driver. Databasemetadata.getColumns does not return columns of VARIANT type in Warehousing & Analytics

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

151640 — Fri, 04 Oct 2024 04:58:26 GMT

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);

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

filipniziol — Fri, 04 Oct 2024 06:21:10 GMT

Hi @151640 ,

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

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

151640 — Wed, 09 Oct 2024 19:28:24 GMT

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-social