Edit

Share via

database()

Applies to: ✅ Microsoft Fabric ✅ Azure Data Explorer

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

Note

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

Note

  • 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

The following example counts the records in the StormEvents table of the Samples database.

Run the query

database('Samples').StormEvents | count

Output

Count
59066

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

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.

Note

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