Lakehouse - Create table

Question

Hi Team,

Do we have an option to create table in Onelake using DDL statement without using warehouse , or notebook and ADF?

I tried creating a simple table and ended up in error stating external policy action 'Microsoft.sql/sqlservers/databases/Schemas/Tables/Create' was denied on the requested resource'

Answer 1

Hi Ganesan, Jothy,

Thank you for reaching out to us on the Microsoft Q&A forum.

Currently Microsoft Fabric doesn't support directly creating tables in OneLake using DDL statements. OneLake functions as the data lake storage layer, and DDL statements are typically used for structured data management within a data warehouse environment.

OneLake:  This serves as the data lake layer, ideal for storing unstructured, semi-structured, and structured data. DDL statements, commonly used for schema definition within data warehouses, are not directly applicable in OneLake. 

Data Warehouse: For structured data analysis, Fabric offers a dedicated Warehouse environment. This allows you to create and manage tables using familiar T-SQL statements accessible through the SQL endpoint or any T-SQL compatible tool. 

Data Transformation: While OneLake stores the data, transformation and processing are handled through Azure Data Factory (ADF) or Notebooks. These tools can then generate tables within the Warehouse or other designated destinations based on your analytical needs.

For creating tables in a Warehouse please refer: https://learn.microsoft.com/en-us/fabric/data-warehouse/tutorial-create-tables

If you encounter any future issues, please feel free to contact us, and we will be pleased to assist you further.

If you have found the answer provided to be helpful, please click on the "Upvote and Accept Answer" button so that it is useful for other members in the Microsoft Q&A community.