Discover Microsoft Fabric KQL tables — fabric_kql

Lists tables in a Fabric KQL database through Kusto's management endpoint. With detail = TRUE, retrieves the database JSON schema once and exposes each table's ordered columns while retaining its complete metadata.

Usage

fabric_kql_tables(
  cluster,
  database = NULL,
  detail = TRUE,
  timeout = 60,
  tenant_id = Sys.getenv("FABRICQUERYR_TENANT_ID"),
  client_id = Sys.getenv("FABRICQUERYR_CLIENT_ID", unset =
    "04b07795-8ddb-461a-bbee-02f9e1bf7b46"),
  token = NULL,
  auth_args = list()
)

Arguments

cluster: Query URI, or one Eventhouse or KQLDatabase object returned by fabric_eventhouses(), fabric_kql_databases(), or fabric_item(). A KQLDatabase object also supplies database. Despite the argument name, use Fabric's Query URI here
database: KQL database display name. Supply it with a copied Query URI or an Eventhouse object; omit it when cluster is a KQLDatabase object
detail: Whether to retrieve the database JSON schema and map it to every table. Set to FALSE to issue only the table-list command.
timeout: Positive client-side HTTP timeout in seconds. This is separate from the Kusto servertimeout request property
tenant_id: Microsoft Entra tenant ID. Defaults to FABRICQUERYR_TENANT_ID
client_id: Microsoft Entra application/client ID. Defaults to FABRICQUERYR_CLIENT_ID, with the Azure CLI application ID as fallback
token: Optional access token or token-provider function. Leave NULL to let 'fabricQueryR' use its normal sign-in flow
auth_args: Additional sign-in options passed to AzureAuth::get_azure_token()

Value

A tibble with table name, database, folder, description, list-column columns, parsed schema_metadata, and the unmodified listing row in raw.

References

Kusto .show tables command

Kusto .show database schema command

Examples

if (FALSE) { # \dontrun{
workspace <- fabric_workspaces()[[1L]]
database <- fabric_kql_databases(workspace)[[1L]]

tables <- fabric_kql_tables(database)
events <- fabric_kql_read_table(database, tables[1L, ], limit = 1000)
} # }