In the previous blog post we created an Azure Data Explorer (ADX) cluster.
In this blog post we will create a database that we will ingest data into, as part of this process:
- On the Overview tab, select Create database.
- Fill out the form with the following information.
Setting | Suggested value | Field description |
---|---|---|
Admin | Default selected | The admin field is disabled. New admins can be added after database creation. |
Database name | TestDatabase | The name of database to create. The name must be unique within the cluster. |
Retention period | 365 | The number of days that data is guaranteed to be kept available for querying. The period is measured from the time data is ingested. |
Cache period | 31 | The number of days to keep frequently queried data available in SSD storage or RAM to optimize querying |
- Select Create to create the database. Creation typically takes less than a minute. When the process is complete, you’re back on the cluster Overview tab.
- Now that we’ve created the cluster and database, we can run some basic queries and commands. The database doesn’t have data yet, but we can see how the tools work.
- Under our cluster, select Query. Paste the command
.show databases
into the query window, then select Run.
The result set shows TestDatabase, the only database in the cluster. - Paste the command
.show tables
into the query window and select Run.
This command returns an empty result set because we don’t have any tables yet. We will add a table and ingest data in one of the next blog posts.