Kusto.Contents
Kusto's name for AzureDataExplorer.Contents: the databases on a cluster, the tables in a database, or the rows of a KQL query.
Group: Online services. Power Query M has it too: a query that uses it is written as in Power BI.
Syntax
Kusto.Contents(cluster as text, optional database as nullable text, optional tableOrQuery as nullable text, optional options as nullable record) as table| Parameter | Type | Description |
|---|---|---|
cluster | text | The cluster: its name (help, or help.westeurope) or its https:// address, a Fabric KQL database's too. |
database | nullable text optional | A database of the cluster. |
tableOrQuery | nullable text optional | A table's name, or a KQL query. |
options | nullable record optional | Accepted as Power Query writes it; none is read. |
Returns
table. A navigation table, or the table's or query's rows.
Remarks
- With a cluster only: its databases (Name, Data, Kind "Database"). With a database: its tables (Name, Data, Kind "Table"). With a table or a query too: its rows.
- A column's type is Kusto's: int and long Int64.Type, real and decimal number, bool logical, datetime a datetimezone, dynamic any, the others text.
- The studio's preview asks for the first rows only.
- Signed in with your Microsoft work account: the studio asks the first time this computer reads the source, and keeps the sign-in on this computer only.
Examples
A database's tables
Kusto.Contents("norwayanalytics.westeurope", "Telemetry")Result: not shown here: it needs an Azure Data Explorer cluster and a sign-in.