| title | Create a Table in Azure Data Explorer |
|---|---|
| description | Learn how to easily create a table and manually define the schema in Azure Data Explorer with the table creation wizard. |
| ms.reviewer | aksdi |
| ms.topic | how-to |
| ms.date | 02/12/2026 |
Creating a table is an important step in the process of data ingestion and querying in Azure Data Explorer. The following article shows how to create a table and schema mapping quickly and easily by using the Azure Data Explorer web UI.
Note
To create a new table based on existing data, see Get data from file or Get data from Azure storage.
- A Microsoft account or a Microsoft Entra user identity. An Azure subscription isn't required.
- An Azure Data Explorer cluster and database. Create a cluster and database.
- Database User or Database Admin permissions. For more information, see Kusto role-based access control.
- Sign in to the Azure Data Explorer web UI and add a connection to your cluster.
Note
To enable access between a cluster and a storage account without public access (restricted to private endpoint or service endpoint), see Create a Managed Private Endpoint.
-
In the navigation pane, select Query.
-
Select + Add > Table or right-click on the database where you want to create the table and select Create table.
:::image type="content" source="media/create-table-wizard/add-table.png" alt-text="Screenshot of the Add Table option in the left navigation pane.":::
The Create table window opens with the Destination tab selected.
-
The portal prepopulates the Cluster and Database fields. You can select different values from the dropdown menu.
-
In Table name, enter a name for your table.
[!TIP] Table names can be up to 1,024 characters including alphanumeric, hyphens, and underscores. Special characters aren't supported.
-
Select Next: Schema.
-
Select Add new column to open the Edit columns panel.
-
For each column, enter Column name and Data type. Create more columns by selecting Add column.
:::image type="content" source="media/create-table-wizard/edit-columns.png" alt-text="Screenshot of Edit columns pane, in which you input the column name and data type in Azure Data Explorer.":::
-
Select Save. The portal displays the schema.
-
Select Next: Create table.
:::image type="content" source="media/create-table-wizard/create-table.png" alt-text="Screenshot of create empty table wizard with schema input in Azure Data Explorer.":::
The portal creates a new table in your target destination, using the schema you defined.