database()

Changes the reference of the query to a specific database within the cluster scope.

Note

• For more information, see cross-database and cross-cluster queries.
• For accessing remote cluster and remote database, see cluster() scope function.

Syntax

database(databaseName)

Learn more about syntax conventions.

Parameters

Name	Type	Required	Description
databaseName	string	The name of the database to reference. The databaseName can be either the DatabaseName or PrettyName. The argument must be a constant value and can't come from a subquery evaluation.

Examples

Use database() to access table of other database

Run the query

database('Samples').StormEvents | count

Output

Count
59066

Use database() inside let statements

The query above can be rewritten as a query-defined function (let statement) that receives a parameter dbName - which is passed into the database() function.

let foo = (dbName:string)
{
    database(dbName).StormEvents | count
};
foo('help')

Output

Count
59066

Use database() inside stored functions

The same query as above can be rewritten to be used in a function that receives a parameter dbName - which is passed into the database() function.

.create function foo(dbName:string)
{
    database(dbName).StormEvents | count
};

Note

Such functions can be used only locally and not in the cross-cluster query.

This capability isn't supported in Azure Monitor