All Products
Search
Document Center

DataWorks:DataWorks Copilot usage scenarios

Last Updated:Aug 16, 2025

DataWorks Copilot provides two core modules: Copilot Chat and Copilot AI in Place. Copilot Chat uses the Ask module to support a wide range of question-and-answer interactions, including code generation, completion, rewriting, and debugging. It also uses the Agent module to handle complex tasks such as task planning, inference, and tool execution. This provides robust foundational support for data development and extract, transform, and load (ETL) scenarios. Copilot AI in Place focuses on providing intelligent assistance within the development environment. It offers features such as code generation, AI-powered table creation, and query result visualization to help developers complete various tasks efficiently. This document describes the primary usage scenarios for DataWorks Copilot.

Ask scenarios

Scenario 1: Code generation

  • Scenario description: Automatically transforms natural language input into SQL statements.

  • Example: For more information, see Code generation.

Scenario 2: Code rewriting

  • Scenario description: Rewrites specified code through natural language interaction.

  • Example: For more information, see Code rewriting.

Scenario 3: Code debugging

  • Scenario description: Finds and fixes faults in a specified code snippet.

  • Example: For more information, see Code debugging.

Scenario 4: Comment generation

  • Scenario description: Generates comments for specified SQL code to improve its readability.

  • Example: For more information, see Comment generation.

Scenario 5: Code explanation

  • Scenario description: Explains specified SQL code to improve its readability.

  • Example: For more information, see Code explanation.

Scenario 6: Code optimization

  • Scenario description: Optimizes selected SQL code to simplify logic and improve runtime efficiency.

  • Example: For more information, see Code optimization.

Scenario 7: Code testing

  • Scenario description: Provides a testing plan for the selected SQL code and generates test code to verify that each part of the task works as expected.

  • Example: For more information, see Code testing.

Scenario 8: Code Q&A

  • Scenario description: Provides explanations and usage examples for questions about SQL syntax or MaxCompute functions. This helps you better understand SQL syntax and functions.

  • Example: For more information, see Code Q&A.

For more information, see DataWorks Copilot Ask.

Agent scenario

  • Scenario description: Use the DataWorks Copilot Agent to analyze and execute data analysis instructions. This feature covers the entire process, from requirement analysis and code generation to node creation and production release.

  • Example: For more information, see DataWorks Copilot Agent.

For more information, see DataWorks Copilot Agent.

AI in Place scenarios

Scenario 1: Intelligent table creation

  • Scenario description: When you create a new table in the data catalog, you can quickly generate SQL CREATE TABLE statements using natural language.

  • Example: For more information, see Intelligent table creation.

Scenario 2: Node release description generation

  • Scenario description: After you complete node development, you must publish the node to the production environment. You can use this feature to automatically generate a description for the node release.

  • Example: For more information, see Node release description generation.

Scenario 3: Intelligent chart and insight generation

  • Scenario description: During data development and data analysis, you can use the DataWorks Copilot intelligent chart assistant to generate visualizations and data insights from query results with a single click.

  • Example: For more information, see Intelligent chart and insight generation.

For more information, see DataWorks Copilot AI in Place.