Comment
Author: Admin | 2025-04-28
Skip to main content This browser is no longer supported. Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support. Data Definition Queries (Data Mining) Article10/31/2023 In this article -->Applies to: SQL Server 2019 and earlier Analysis Services Azure Analysis Services Fabric/Power BI PremiumImportantData mining was deprecated in SQL Server 2017 Analysis Services and now discontinued in SQL Server 2022 Analysis Services. Documentation is not updated for deprecated and discontinued features. To learn more, see Analysis Services backward compatibility.For data mining, the category data definition query means DMX statements or XMLA commands that do the following:Create, alter, or manipulate data mining objects, such as a model.Define the source of data to be used in training or for prediction.Export or import mining models and mining structures.Creating Data Definition QueriesData Definition Queries in SQL Server Data ToolsData Definition Queries in SQL Server Management StudioScripting Data Definition StatementsScripting Data Definition Statements Creating Data Definition QueriesYou can create data definition queries (statements) by using the Prediction Query Builder in SQL Server Data Tools and SQL Server Management Studio, or by using the DMX Query window in SQL Server Management Studio. Data definition statements in DMX are part of the Analysis Services data definition language (DDL).For information about the syntax of specific data definition statements, see Data Mining Extensions (DMX) Reference. Data Definition Queries in SQL Server Data ToolsThe Data Mining Wizard is the preferred tool in SQL Server Data Tools for creating and modifying mining models and mining structures, and for defining the data sources that are used in prediction queries and for training.However, if you want to know what statements are being sent to the server by the wizard to create data structures or mining models, you can use SQL Server Profiler to capture the data definition statements. For more information, see Use SQL Server Profiler to Monitor Analysis Services.To view the statements used for defining data sources used for training or prediction, you can use the SQL View in the Prediction Query Builder. Sometimes it can be helpful to build basic queries for training and testing
Add Comment