Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Data Days is here! Join us now for 60+ days of learning, challenges, and connection. Learn more

Regex support in lakehouse/datawarehouse

SQL Server 2025 adds Regex functions support, this is present also in SQL database in Fabric, Azure SQL DB and Azure Managed Instance as per:

 

https://learn.microsoft.com/en-us/sql/relational-databases/regular-expressions/overview?view=sql-ser...

 

it would be beneficial to have Regex support also in lakehouse and warehouses.

Status: Planned
Comments
sahinad
Regular Visitor
I have just tested it via the SQL analytics endpoint and am disappointed that it is not working yet 😞 I am looking forward to seeing this features in the lakehouse.
jovanpop-msft
Microsoft Employee
Status changed to: Planned
 
Anonymous
Not applicable
I hope this simple query will work : SELECT * FROM REGEXP_SPLIT_TO_TABLE('a.b.c', '\.');