Databases

Applies to: ✅ Microsoft FabricAzure Data ExplorerAzure MonitorMicrosoft Sentinel

Databases are named entities that hold tables and stored functions. Kusto follows a relation model of storing the data where the upper-level entity is a database.

A single cluster can host several databases, in which each database hosts its own collection of tables, stored functions, and external tables. Each database has its own set of permissions that follow the Role Based Access Control (RBAC) model.

Note

  • The maximum limit of databases per cluster is 10,000.
  • Database names must follow Identifier naming rules with the exception of case-sensitivity rule. Database names are case-insensitive.
  • Both queries combining data from multiple tables in the same database and queries combining data from multiple databases in the same cluster have comparable performance.

A single Eventhouse can host several databases, in which each database hosts its own collection of tables, stored functions, and external tables. Each database has its own set of permissions that follow the Role Based Access Control (RBAC) model.

Note

  • The maximum limit of databases per Eventhouse is 10,000.
  • Database names must follow Identifier naming rules with the exception of case-sensitivity rule. Database names are case-insensitive.
  • Both queries combining data from multiple tables in the same database and queries combining data from multiple databases in the same Eventhouse have comparable performance.

A database hosts its own collection of tables, stored functions, and external tables. Each database has its own set of permissions that follow the Role Based Access Control (RBAC) model.