Creating an ADX Database

Comments [0]

Azure Data Explorer (ADX) is a scalable service that allows you to manage large data sets in near-real-time. Data within ADX is stored within databases, so you will need to create a new database before working with any data in this service.

To create a database, navigate to the Azure Portal and sign in; then, navigate to your Azure Data Explorer Cluster, as shown in Fig. 1. If you have not yet created an ADX cluster, follow the steps in this article.

ADX Overview Blade
Fig. 1

Click the [Databases] button (Fig. 2) in the left menu to display the "Databases" blade, as shown in Fig. 3.

Database button in left menu
Fig. 2

Database blade
Fig. 3

Click the [Add database] button (Fig. 4) to display the "Create New Database" dialog, as shown in Fig. 5.

Add Database button
Fig. 4

Create New Database dialog
Fig. 5

At the "Database name" field, enter a name by which you will identify this database. This name should be descriptive of the data you intend to store herein. It must be unique within this cluster, it must be no more than 260 characters and must only contain letters, numbers, spaces, dashes, and dots.

At the "Retention period" field, enter the number of days you wish to retain data in this database before it is purged. If you never want data purged, check the "Unlimited days for retention period" checkbox.

At the "Cache period" field, enter the number of days you wish to keep data in cache after it is added to a cache. Caching data makes queries against that data much faster. If you wish to keep data in cache forever, check the "Unlimited days for cache period" checkbox.

Click the [Create] button to create the database.

After a few seconds, the database is created and the "Databases" blade displays with the new database listed, as shown in Fig. 6.

Database blade
Fig. 6

Click on your database row to display details about your database, as shown in Fig. 7.

Database Details
Fig. 7

From this details blade, you can edit and manage the database.

In this article, you learned how to add a new database to an Azure Data Explorer Cluster.