https://community.databricks.com/t5/data-engineering/variant-support-in-sql-alchemy/m-p/82574#M36689 <P>This is actually an open source project. By looking <A href="https://github.com/databricks/databricks-sql-python/blob/2d2b3c1c442223be5b8ce21742c66bd27b56b51f/src/databricks/sqlalchemy/_types.py" target="_self">at the code</A>, it seems that VARIANT is not yet supported. Depending on your knowledge of the code base, you could create an own PR. Or just open an issue there, and wait for the support of the devs.</P> Fri, 09 Aug 2024 15:23:28 GMT Witold 2024-08-09T15:23:28Z https://community.databricks.com/t5/data-engineering/variant-support-in-sql-alchemy/m-p/82556#M36678 <DIV><DIV><SPAN>Databricks now supports the VARIANT data type, which works well </SPAN><SPAN>in</SPAN><SPAN> the UI </SPAN><SPAN>and</SPAN><SPAN> within Spark environments. However, when working </SPAN><SPAN>with</SPAN><SPAN> SQLAlchemy, the VARIANT type doesn</SPAN><SPAN>'t seem to be fully implemented in the latest databricks-sql-connector[sqlalchemy]. Could you provide a custom type snippet to use the VARIANT data type with SQLAlchemy?</SPAN></DIV></DIV> Fri, 09 Aug 2024 13:03:55 GMT https://community.databricks.com/t5/data-engineering/variant-support-in-sql-alchemy/m-p/82556#M36678 anand_k 2024-08-09T13:03:55Z https://community.databricks.com/t5/data-engineering/variant-support-in-sql-alchemy/m-p/82574#M36689 <P>This is actually an open source project. By looking <A href="https://github.com/databricks/databricks-sql-python/blob/2d2b3c1c442223be5b8ce21742c66bd27b56b51f/src/databricks/sqlalchemy/_types.py" target="_self">at the code</A>, it seems that VARIANT is not yet supported. Depending on your knowledge of the code base, you could create an own PR. Or just open an issue there, and wait for the support of the devs.</P> Fri, 09 Aug 2024 15:23:28 GMT https://community.databricks.com/t5/data-engineering/variant-support-in-sql-alchemy/m-p/82574#M36689 Witold 2024-08-09T15:23:28Z