All Products
Search

This Product

    Dataphin:Create SQL queries based on the analysis platform

    Document Center

    Dataphin:Create SQL queries based on the analysis platform

    Last Updated:Jun 23, 2026

    Dataphin's analysis platform lets you create and run SQL queries to retrieve data, and visualize query results for analysis.

    Scenarios

    Extract and Download Data: Extract, aggregate, filter, and sort data from the compute source, and download the results for analysis or reporting.

    Data Visualization: Present query results as charts to help you understand and analyze business data for informed decision-making.

    Overview of the SQL query development page

    The SQL query development page consists of a SQL query folder, an editor menu, an editing area, and a console.

    The project SQL query and database SQL query areas share the same compute source. The following figure uses the database SQL query as an example.

    image.png

    ```markdown

    Area

    Description

    ①SQL Query Directory

    The SQL query directory has two root directories: My and Shared With Me.

    • The My directory stores SQL queries you create and supports multiple subdirectories. To create SQL queries, see Create a new SQL query.

    • Shared With Me: Contains SQL queries shared with you by others.

    SQL queries owned by your account support copy, rename, move, and delete operations.

    ②SQL Query Editor Menu

    The SQL Query Editor Menu provides data source switching, query acceleration, run, save, share, parameter configuration, formatting, locate, project switching.

    • Data Source Switching: For an SQL query that uses a data source, you can change the active data source from the dropdown box when querying data.

    • Run: Click Run or press Cmd+Enter to execute the selected SQL code.

    • Save: Click image..png to save the current query.

    • Share: Share your SQL query with other users within the Dataphin instance.

    • Query Acceleration: When MaxCompute is the offline compute engine, you can enable MCQA for faster query processing. MCQA is subject to per-tenant job and concurrency limits, which may cause acceleration failures. For more information, see Query Acceleration (MCQA).

    • Parameter Configuration: Click image.png to set SQL query parameter values. For more information, see Notebook Parameter Configuration.

    • Formatting: Format the SQL code within the query.

    • Locate: Click image..png to locate the current SQL query in the directory.

    • Project Switching: Switch the active project for the SQL query, which also changes the compute source for the analysis platform.

      Note

      • The AccessKey for the compute engine in the selected project must have access privileges for the project that contains the query table. Otherwise, the query fails.

      • If your analysis platform is not linked to a default compute source, a super administrator or system administrator can assign one. For more information, see Analysis platform settings.

      • You can only switch to a Dev or Basic project linked to an offline engine under the current account. The account must also have ad hoc query execution permissions for that project. For more information, see Request, renew, and return table permissions.

    ③Editing Area

    Write and edit SQL code in this area.

    ④Console

    The console displays query results after execution. You can view results, logs, code, and visual analytics.

    • Running Results: Displays column information for the query results. Database SQL queries do not support saving results as temporary tables.

      Note

      Database SQL queries do not support saving results as temporary tables.

      • Display Columns: Display column information for the results.

      • Single Row Details: View details for a selected row, including the row number, ordinal number, field name, and value.

      • Result Query: Search for a specific value in the results.

      • Download Data: Click image.png to download the execution results as data files in CSV or Excel format.

        Note

        The file format and whether download approval is required are configured in Management Center > Data download. For more information, see Data download configuration .

      • Row and Column Transformation: Click image.png to toggle between row and column display modes.

    • Visual analytics: Display query results as line charts, bar charts, pie charts, and other visualizations. For more information, see SQL visual charts.

    • Logs: View log information detailing SQL query execution times.

    • Code: View the SQL query code.