cancel
Showing results forย 
Search instead forย 
Did you mean:ย 
Warehousing & Analytics
Engage in discussions on data warehousing, analytics, and BI solutions within the Databricks Community. Share insights, tips, and best practices for leveraging data for informed decision-making.
cancel
Showing results forย 
Search instead forย 
Did you mean:ย 

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

151640
New Contributor III

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

1 REPLY 1

filipniziol
New Contributor III

Hi @151640 ,

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

filipniziol_0-1728022862306.png

 




Connect with Databricks Users in Your Area

Join a Regional User Group to connect with local Databricks users. Events will be happening in your city, and you wonโ€™t want to miss the chance to attend and share knowledge.

If there isnโ€™t a group near you, start one and help create a community that brings people together.

Request a New Group