Dataphin lets you configure data downloads at the project level. After data is downloaded, it is no longer managed by the system. To improve data security and prevent unauthorized sharing, you can apply watermarks to Excel files. This topic describes how to configure data download policies and watermarks for Excel files.
Usage instructions
If the compute engine is MaxCompute, you can download result data from MaxCompute Logview. To prohibit downloads, you can set
odps.forbid.fetch.result.by.bearertoken=truein the MaxCompute project settings. For more information, see Project operations.If no data download and approval rules are configured for a project, data downloads are enabled by default and do not require approval.
Full data downloads support only the CSV format and do not support file watermarks.
Permission instructions
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
On the Dataphin home page, choose Management Center > Specification Settings in the top menu bar.
In the navigation pane on the left, choose Data Access > Data Download.
On the Data Download page, click Add Approval Configuration.
In the Add Approval Configuration dialog box, configure the parameters.
Parameter
Description
Object Type
Select Project or Datasource.
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.
NoteYou can configure the data download scope for a project only once.
Copy Query Results
The default value is Allow. If you select Forbid, you cannot copy the query results for the selected object.
Data Type
Options include Limited Result Set and Full Result Set. For each data type, you can enable or disable downloads, or require approval.
Is Download Supported
This feature is enabled by default. If enabled, data from the object can be downloaded. If disabled, data cannot be downloaded.
Is Approval Required
If you enable this option, select an approval template. You can use a system template or a custom approval template. For more information about how to create a custom template, see Create and manage approval templates.
If Object Type is set to Project: System templates include Project Administrator Approval, Section Administrator Approval, and Security Administrator Approval.
If Object Type is set to Data Source: System templates include Data Source Owner Approval and Security Administrator Approval.
If you disable this option, you cannot configure an approval template.
Click OK to add the approval configuration.
View the list of download and approval configurations
After you configure the download and approval settings, you can edit or delete the configurations from the list.
Area | Description |
①List area | The list displays information such as Object Name, File Format, whether Copy Query Results is allowed, Data Download Scope, whether Sample Data Approval is enabled, the Sample Data Approval Template, whether Full Data Approval is enabled, and the Full Data Approval Template. |
②Operation area | You can execute Edit and Delete operations for the project.
|
File format
On the Data Download page, click the File Format tab. You can configure the download file formats for full and sample data, and 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
Supports two file formats: CSV and Excel. If you select the Excel download format, you can also enable a Watermark and set its style.
Watermark
If you select Excel as the sample download file format and enable Watermark, you can configure the following parameters.
Watermark Content: Sets the information displayed as the watermark for Excel files. You can select Username or Custom.
Username: Uses the username and user account of the current tenant as the watermark.
Custom: A custom watermark text of up to 100 characters. This field cannot be empty.
Watermark Font: Set the font size and specify whether to bold the text.
Font size: The default font size is 16px. The font size can range from 8px to 80px.
Bold: Click the Bold
button to bold the font.
Rotation Angle: Set the rotation angle of the watermark font. The default angle is -45°. The angle can range from -360° (counterclockwise) to 360° (clockwise).
Font Color: The font color is black (#000000) and cannot be changed.
Transparency: Set the transparency of the font. The default value is 94%. The transparency can range from 0% to 100%.
Watermark Pitch: Set the horizontal and vertical spacing of the watermark. The default value for both is 240px. The range for both is 0px to 500px.
After you complete the configuration, you can preview the watermark in real time in the Preview Area.
Sample data
Configure the number of leading records to return for downloads or query statements. This configuration affects the number of rows returned for ad hoc queries and downloads.
Project Sample Data: The default value is 10,000 rows. The range is 1 to 10,000.
Data Source Sample Data: The default value is 1,000 rows. The range is 1 to 10,000.
NoteTo restore the default configurations, click Restore Default Configurations in the upper-right corner of the preview area.
Click OK to save the file format configuration.