Now that you're connected to your data source, you can run queries on this data. Change the existing database connection: Under Database, select the existing database connection to open the data hub.Different tabs can be connected to different databases. Add a new tab: Select the plus + to the right of the existing tabs.Rename a tab: Select the pencil icon next to the tab name.To connect your KQL queryset to a database, select Select database, and then select a database from the data hub that appears.Ī list of tables associated with this database will appear below the database name.You can change the associated database at any point, and retain the queries saved in the query editor. Queries run in the context of a database. Select the KQL queryset from the list of items that appear in the workspace. Optionally, you can reduce the number of items displayed by filtering on the item type. Select the desired KQL Queryset from the list of items. To access an existing queryset, browse to your workspace. You can create multiple KQL Querysets in a single workspace. You can use alphanumeric characters, underscores, periods, and hyphens. A new KQL queryset is always associated with the workspace you're using when you create it.Įnter a unique name. The KQL Queryset exists within the context of a workspace. A workspace with a Microsoft Fabric-enabled capacity.For more information about the query language, see Kusto Query Language overview. The KQL Queryset uses the Kusto Query language for creating queries, and also supports many SQL functions. You can also change the KQL database associated with any tab, allowing you to run the same query on data in different states. Each tab in the KQL queryset can be associated with a different KQL database, and lets your save queries for later use or share with others to collaborate on data exploration. The KQL Queryset is the item used to run queries, view, and customize query results on data from a KQL database. In this article, you learn how to create and use a new KQL queryset. Microsoft makes no warranties, expressed or implied, with respect to the information provided here. This information relates to a prerelease product that may be substantially modified before it's released. Microsoft Fabric is currently in PREVIEW.
0 Comments
Leave a Reply. |