Try the DMS Data Copilot intelligent assistant for free

Background

SQL development is a highly technical job. As information technology becomes more integrated into business, data needs are growing across different roles. This presents challenges for data management and SQL development efficiency.

DMS Data Copilot is a data intelligence assistant powered by an Alibaba Cloud large model. It combines the advanced data management and usage capabilities of DMS. It helps developers, O&M personnel, product managers, operations staff, analysts, and database administrators use and manage data more efficiently and accurately.

Alibaba Cloud provides a DB+AI Solutions experience center. You can try the natural language to SQL (NL2SQL) and chart recommendation features of DMS Data Copilot online without purchasing any resources. This lets you experience the intelligent services of DMS firsthand.

Impact

• This trial does not involve deployment in a production environment and will not affect your business.

• After you start the trial, DMS automatically adds a DMS_Copilot_Test_Instance to the Login-free Instances list under Database Instances on the left side of the DMS console home page. You can use this instance to test the features of Data Copilot. This instance is a read-only instance. If you do not need to try Data Copilot, a database administrator (DBA) or an administrator can manually delete the read-only instance.

Costs

The resources for this trial are provided at no cost. You will not be charged any fees.

Trial content

The four tables in the commerce_db database used in this trial have been created. You can use them directly.

• dim_jst_erp_co_company: ERP merchant information table

• dim_jst_erp_co_contract: ERP merchant contract table

• dwd_jst_sc_item_slf_info_ht: Distribution details table

• m_sc_web_log_detail_d: Instrumentation log information table

Procedure

1. Log on to the Alibaba Cloud ApsaraDB console.

2. On the home page of the console, click Solutions.

3. Click DB+AI Experience, and then click the Free Trial button for DMS Copilot. The following page appears:

4. Try NL2SQL.

   1. In the SQL Console window, click to open the DMS Data Copilot intelligent assistant.

   2. In the Copilot dialog box, enter a question and click Send. For example: What are the details of the top three merchants by traffic in the last month?

      Copilot returns the tables that the model considers most relevant to your question. Click Submit.

   3. Check whether the SQL statement in the model's response is accurate.

      • If the statement is inaccurate, provide feedback to adjust the result.

        1. The result from the first round is inaccurate. It incorrectly interprets the duration field of the dwd_jst_sc_item_slf_info_ht table as traffic.

           To correct the filter condition, provide feedback. In the text editing area, enter Traffic means event_id=2001 and click Add Feedback.

        2. The result from the second round adds the traffic filter condition to the SQL. However, the merchant details are in the dim_jst_erp_co_company table, not the dwd_jst_sc_item_slf_info_ht table. You still need to correct the table reference.

           In the text editing area, enter Merchant details are in dim_jst_erp_co_company and click Add Feedback.

      • If the statement is accurate, click the like icon to provide positive feedback. This feedback helps the model retrieve similar SQL statements for future queries.

   4. In the Copilot dialog box, click Execute Query in the upper-right corner of the SQL statement.

5. Try the Chat2BI feature of the AI Agent.

   On the Agent interface, you can ask questions about the tables in the current database.

   1. Click the Agent tab.

   2. In the new Agent question box, enter a question. Then, click Send or press Enter.

      For example, ask: What are the details of the top five merchants by traffic in the last two months? The Agent automatically executes the SQL, which lets you view the table data directly.

   3. Click to view the generated SQL.

   4. Click the icon to generate a recommended chart. In the configuration items on the left, you can configure the chart type, X-axis and Y-axis settings, grouping, and filters.

      Note

      Click Download Image on the right to download the generated chart.

Related topics

Data Copilot (New)