

The automatic table discovery and registration is a feature of Lakehouse that provides a fully managed file to table experience for data engineers and data scientists. Learn more about the SQL Endpoint here Automatic table discovery and registration If you don't see your table, convert it to Delta format. Parquet, CSV, and other formats can't be queried using the SQL Endpoint. It is important to note that only the tables in Delta format are available in the SQL Endpoint.
#LAKEHOUSE WEST FULL#
This new see-through functionality allows user to work directly on top of the delta tables in the lake to provide a frictionless and performant experience all the way from data ingestion to reporting.Īn important distinction between default warehouse is that it's a read-only experience and doesn't support the full T-SQL surface area of a transactional data warehouse. The Lakehouse creates a serving layer by auto-generating an SQL endpoint and a default dataset during creation. Microsoft makes no warranties, expressed or implied, with respect to the information provided here. This information relates to a prerelease product that may be substantially modified before it's released. Microsoft Fabric is currently in PREVIEW.
