data-mining-query-tasks-and-how-tos.md

title	description	ms.date	ms.service	ms.custom	ms.topic	ms.author	ms.reviewer	author
Data Mining Query Tasks and How-tos | Microsoft Docs	Learn how to create queries to make use of data mining models by using these examples in SQL Server Management Studio and SQL Server Data Tools.	10/31/2023	analysis-services	data-mining	conceptual	kfollis	kfollis	kfollis

Data Mining Query Tasks and How-tos

[!INCLUDEappliesto-sql2019-earlier]

[!INCLUDEdm-dep-banner]

The ability to create queries is critical if you are to make use of your data mining models. This section provides links to examples of how to create queries against a data mining model by using the tools provided in [!INCLUDEssManStudioFull] and [!INCLUDEssBIDevStudioFull]. If you need more information about what a data mining query is, or the different types of queries you can create, see Data Mining Queries.

Creating Queries with Prediction Query Builder

The Prediction Query Builder is provided in both [!INCLUDEssBIDevStudioFull] and [!INCLUDEssManStudioFull] as a way of graphically building queries against data mining models. The following topics explain how you can select a model, specify a data source, customize the predictions, and save output.

• Create a Prediction Query Using the Prediction Query Builder

• Create a Singleton Query in the Data Mining Designer

• Create a Prediction Query Using the Prediction Query Builder

• View and Save the Results of a Prediction Query

• Manually Edit a Prediction Query

• Apply Prediction Functions to a Model

• Choose and Map Input Data for a Prediction Query

Using Other Data Mining Query Tools

In addition to using the Prediction Query Builder, you can type a query directly into [!INCLUDEssManStudioFull] by using DMX or by using XMLA. You can also build prediction queries programmatically and send them to an [!INCLUDEssASnoversion] server. The following topics provide more information about how to create and work with prediction queries outside of the Prediction Query Builder.

Create a Singleton Prediction Query from a Template
Describes how to use the tools in [!INCLUDEssManStudioFull] to build and run a prediction query.

Create a Singleton Prediction Query from a Template
Describes how to use the templates that are provided in [!INCLUDEssManStudioFull] to add parameters to a prediction query.

Change the Time-out Value for Data Mining Queries
Describes how to set properties on the server that control behavior related to data mining queries.

Create a Content Query on a Mining Model
Describes how to create queries that return detailed information that is stored in the mining model by using the data mining schema rowsets.

Create a Data Mining Query by Using XMLA
Describes how to create a query against mining model content by using the XMLA templates in [!INCLUDEssManStudioFull].

See Also

Query and Expression Language Reference (Analysis Services)
Data Mining Stored Procedures (Analysis Services - Data Mining)