How to deal with struct types in sqlalchemy

[DaanRademaker]

Hi,
First of all thank you for the awesome work so far. This really improves the development experience for Databricks and finally allows tools such as alembic to work with delta tables :)

However, we have some tables that contain nested columns (with struct types) and I don't see support for this right now. Is this correct or am I missing something?

Thanks in advance!

[susodapop]

I don't see support for this right now.

Correct, the SQLAlchemy integration currently doesn't expose a STRUCT(), MAP(), or ARRAY() types. However we're actively investigating how to introduce this. I'm going to leave this issue open on the repository so that other searchers can find it.

Would you please reach out to us at databricks-sql-connector-maintainers@databricks.com so we can gather more information about your use-case?

[DaanRademaker]

Thanks for the quick response. I send an email to the above mentioned email address!