All Products
Search

This Product

    Dataphin:Data download configuration

    Document Center

    Dataphin:Data download configuration

    Last Updated:Jun 23, 2026

    Dataphin supports business data downloads with project-level permission controls. Because downloaded data leaves the system's governance, you can apply watermarks to Excel files to safeguard data and discourage unauthorized sharing.

    Usage notes

    • When the compute engine is MaxCompute, result data can be downloaded from MaxCompute Logview. To disable this, set odps.forbid.fetch.result.by.bearertoken to true in the project settings of MaxCompute. For more information, see Project Operations.

    • If a project has no download and approval rules configured, downloads are enabled by default and do not require approval.

    • Full data downloads are only available in CSV format and do not support watermarks.

    Permissions

    • Security administrators can add, edit, and delete approval configurations for data downloads.

    • Security administrators can download sample data as Excel files and set watermark styles.

    Add an approval configuration

    1. In the top menu bar on the Dataphin home page, go to Management Center > Standard Settings.

    2. In the left navigation pane, choose Data Access > Data Download.

    3. On the Data Download page, click Add Approval Configuration.

    4. In the Add Approval Configuration dialog box, set the parameters.

      Parameter

      Description

      Object type

      Select Project or Data source.

      Object name

      • If you set Object type to Project, select one or more projects in the current tenant.

      • If you set Object type to Data source, select one or more data sources in the current tenant.

      Note

      You can configure the data download scope for a project only once.

      Copy query results

      The default is Allow. If you select Forbid, you cannot copy query results from the selected project.

      Data Type

      You can select Limited Result Set or Full Result Set. For each type, you can enable or disable downloads, or require approval for downloads.

      Is download supported?

      This option is enabled by default. When enabled, project data can be downloaded. When disabled, project data cannot be downloaded.

      Is Approval Required?

      • When approval is enabled, you must select an approval template. You can use system templates or custom approval templates. For more information, see Create and manage approval templates.

        • If the object type is Project: The system templates include Project administrator approval, Module administrator approval, or Security administrator approval.

        • If the object type is Data source: The system templates include Data source owner approval or Security administrator approval.

      • If you disable this option, you cannot configure an approval template.

    5. Click OK to add the approval configuration.

    View download and approval configurations

    After you configure download and approval rules, you can edit or delete them in the configuration list.

    image

    Block

    Description

    ① Default configurations

    Projects and data sources without specific rules follow these defaults. To enable full data downloads, you must add a separate configuration.

    • Sample data download: Enabled by default. Disabling this also disables sample data approval.

    • Sample data download approval: No default approval template is available. You must add one in the approval configuration.

    • Full data download: Full data downloads cannot be configured here. You must add a separate approval configuration.

    ② List area

    This area lists the Object name, Object type, Copy query results permission, Data download scope, Enable sample data approval, Sample data approval template, Enable full data approval, and Full data approval template. You can search by project or data source name.

    ③ Operations area

    You can perform Edit and Delete operations on a project.

    • Edit: You can modify the approval configuration. For more information, see Add Approval Configuration.

    • Delete: After deletion, the project reverts to the default rules: downloads are enabled for sample data only and do not require approval. This operation cannot be undone.

    File format

    1. On the Data Download page, click the File Format tab to configure the file format for full and sample data downloads and to set the number of rows for sample data.

      Parameter

      Description

      Full download file format

      Only the CSV download format is supported.

      Sample download file format

      You can use either CSV or Excel file formats. If you select Excel as the download format, you can also enable Watermarks for Excel files and configure the watermark style.

      Watermark

      If you set the sample download file format to Excel and enable watermarks, you can configure the following parameters.

      • Watermark content: Specifies the watermark text displayed in Excel files. You can select Username or Custom.

        • Username: Uses the current tenant's username and account as the watermark.

        • Custom: A custom watermark. Maximum 100 characters; cannot be empty.

      • Watermark font: Configures the font size and bold style of the watermark.

        • Font size: The default is 16 px. The range is 8 px to 80 px.

        • Bold: Click the Bold image.png button to make the font bold.

      • Rotation angle: The rotation angle of the watermark font. Default: -45°. Range: -360° (counterclockwise) to 360° (clockwise).

      • Font color: The font color is black (#000000) and cannot be changed.

      • Transparency: The font transparency. Default: 94%. Range: 0% to 100%.

      • Watermark spacing: The horizontal and vertical spacing of the watermark. Default: 240 px for both. Range: 0 px to 500 px.

      After you finish the configuration, a real-time preview appears in the Preview area.

      Sample data

      Configure the first n records returned by a download or query statement. This setting affects both ad hoc queries and downloads.

      • Project sample data: The default is 10,000 rows. The range is 1 to 10,000.

      • Data source sample data: The default is 1,000 rows. The range is 1 to 10,000.
      Note

      To restore the default system configurations, click Restore default configurations in the upper-right corner of the preview area.

    2. Click OK to save the file watermark format configuration.