sempy_labs.kql_queryset package

Module contents

sempy_labs.kql_queryset.create_kql_queryset(name: str, description: str | None = None, workspace: str | UUID | None = None)

Creates a KQL queryset.

This is a wrapper function for the following API: Items - Create KQL Queryset.

Service Principal Authentication is supported (see here for examples).

Parameters:

  • name (str) – Name of the KQL queryset.

  • description (str, default=None) – A description of the environment.

  • workspace (str | uuid.UUID, default=None) – The Fabric workspace name or ID. Defaults to None which resolves to the workspace of the attached lakehouse or if no lakehouse attached, resolves to the workspace of the notebook.

sempy_labs.kql_queryset.delete_kql_queryset(kql_queryset: str | UUID, workspace: str | UUID | None = None)

Deletes a KQL queryset.

This is a wrapper function for the following API: Items - Delete KQL Queryset.

Service Principal Authentication is supported (see here for examples).

Parameters:

  • kql_queryset (str | uuid.UUID) – Name or ID of the KQL queryset.

  • workspace (str | uuid.UUID, default=None) – The Fabric workspace name or ID. Defaults to None which resolves to the workspace of the attached lakehouse or if no lakehouse attached, resolves to the workspace of the notebook.

sempy_labs.kql_queryset.list_kql_querysets(workspace: str | UUID | None = None) → DataFrame

Shows the KQL querysets within a workspace.

This is a wrapper function for the following API: Items - List KQL Querysets.

Service Principal Authentication is supported (see here for examples).

Parameters:

workspace (str | uuid.UUID, default=None) – The Fabric workspace name or ID. Defaults to None which resolves to the workspace of the attached lakehouse or if no lakehouse attached, resolves to the workspace of the notebook.

Returns:

A pandas dataframe showing the KQL querysets within a workspace.

Return type:

pandas.DataFrame