DocsICP FilingConsole
官方文档
首页

Data download configuration

更新时间：
复制 MD 格式
产品详情
我的收藏

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.

  • To download sample data as Excel files and set watermark styles, activate the Intelligent R&D Edition or Basic R&D Edition.

  • 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.

Previous：Security SettingsNext：Data permission configuration