title | description | ms.reviewer | ms.topic | ms.date |
---|---|---|---|---|
Create a table in Azure Data Explorer |
Learn how to easily create a table and manually define the schema in Azure Data Explorer with the table creation wizard. |
aksdi |
how-to |
03/07/2024 |
Creating a table is an important step in the process of data ingestion and query in Azure Data Explorer. The following article shows how to create a table and schema mapping quickly and easily 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/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.
The Create table window opens with the Destination tab selected.
-
The Cluster and Database fields are prepopulated. You may select different values from the drop-down menu.
-
In Table name, enter a name for your table.
[!TIP] Table names can be up to 1024 characters including alphanumeric, hyphens, and underscores. Special characters aren't supported.
-
Select Next: Schema
-
Select Add new column and the Edit columns panel opens.
-
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 schema is displayed.
-
Select Next: Create table.
:::image type="content" source="media/create-table-wizard/create-table.png" alt-text="Screenshot of create emptytable wizard with schema input in Azure Data Explorer.":::
A new table is created in your target destination, with the schema you defined.