Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Switch services using the Version drop-down list. Learn more about navigation.
Applies to: ✅ Microsoft Fabric ✅ Azure Data Explorer
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.
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.
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.