Forum Discussion
Post ProdigyHow do I solve array data type not supported for Lakehouse?
Greetings, all. I have an Array column in a lakehouse delta table that I cannot query in the SQL analytics endpoint because I get a message stating "the specified data types are not supported":
Is the only solution for this to store the data as a string? Or are there plans for Microsoft to support showing data types that exist in lakehouse?
arpost, Thanks for reaching MS Fabric community support
In Microsoft Fabric's SQL Analytics Endpoint, complex data types like ARRAY are not currently supported for direct querying. The only options available right now are:
-
Convert the ARRAY column to STRING: You can store the array as a JSON-formatted string and later parse it in Power BI or another tool.
- Since Fabric Lakehouse supports ARRAY, you can still work with it using Spark notebooks instead of SQL Analytics Endpoint.
please refer to below documentation for more info:
https://learn.microsoft.com/en-us/fabric/data-warehouse/data-types#unsupported-data-types
Microsoft's official support for such functionality is limited we recommend to submit your ideas here to Fabric team: https://ideas.fabric.microsoft.com/ideas/search-ideas/
Thanks,
Prashanth Are
MS Fabric community support.
Did I answer your question? Mark my post as a solution, this will help others!
If my response(s) assisted you in any way, don't forget to drop me a "Kudos"
-
4 Replies
v-prasareCommunity Support
arpost, Thanks for reaching MS Fabric community support
In Microsoft Fabric's SQL Analytics Endpoint, complex data types like ARRAY are not currently supported for direct querying. The only options available right now are:
-
Convert the ARRAY column to STRING: You can store the array as a JSON-formatted string and later parse it in Power BI or another tool.
- Since Fabric Lakehouse supports ARRAY, you can still work with it using Spark notebooks instead of SQL Analytics Endpoint.
please refer to below documentation for more info:
https://learn.microsoft.com/en-us/fabric/data-warehouse/data-types#unsupported-data-types
Microsoft's official support for such functionality is limited we recommend to submit your ideas here to Fabric team: https://ideas.fabric.microsoft.com/ideas/search-ideas/
Thanks,
Prashanth Are
MS Fabric community support.
Did I answer your question? Mark my post as a solution, this will help others!
If my response(s) assisted you in any way, don't forget to drop me a "Kudos"
-
- v-prasare
arpost, As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for your issue worked? or let us know if you need any further assistance here?
Thanks,
Prashanth Are
MS Fabric community support
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly and give Kudos if helped you resolve your query
- v-prasare
arpost, As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for your issue worked? or let us know if you need any further assistance here?
Thanks,
Prashanth Are
MS Fabric community support
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly and give Kudos if helped you resolve your query
- v-prasare
arpost As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for your issue worked? or let us know if you need any further assistance here?
Thanks,
Prashanth Are
MS Fabric community support
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly and give Kudos if helped you resolve your query