Skip to main content

Data Warehouse

New

Support for Array data types in Lakehouse SQL Endpoint

Vote (4) Share
Vasu Nallasamy's profile image

Vasu Nallasamy on 23 Mar 2024 08:30:27

Currently in Fabric Lakehouse SQL Endpoint, Columns with complex data types such as array (JSON types) were not shown and not able to use them in the queries.


Would be nice if the complex data types (JSON) type is supported in the SQL endpoint.



Additionally, Unnesting the array is a pain in Synapse Serverless SQL.


Like a see a easy method for accessing the elements in the array like modern data warehouses like BigQuery or SnowFlake has (dot accessor and unnest).


Ex:

Accessing non-repeated struct

select product.name, product.price from table_a


Accessing repeated struct

select a.acc_name, prod.name, prod.price from table_a, unnest(products) as prod



Thanks,

Vasu Nallasamy