Question 1: DataWorks page query content desensitization?

DataWorks page query content desensitization?

Reference Answer:

Refer to

https://help.aliyun.com/zh/dataworks/use-cases/perform-data-governance?spm=a2c4g.11186623.0.0.12d41265taOW9g#section-9sk-pbl-31t:~ :text=%E8%A7%84%E5%88%99%E7%AE%A1%E7%90%86%E3%80%82-,%E6%95%8F%E6%84%9F%E6%95%B0%E6%8D%AE%E4%BF%9D%E6%8A%A4,-%E5%AF%B9%E4%BA%8E%E4%B8%9A%E4%BA%8E%E4%BA%8E%E4%BA%8E%E4%BA%8E%E4%BA%8E%E4%BA%8E%E4%BA%8E%E4%BA%8E%8E e4%b8%9a%e5%8a%a1%e4%b8%ad

More answers to this question can be found by clicking on the original article:

https://developer.aliyun.com/ask/629375

Question 2: How can I synchronize the data of partition fields together when this dataworks partition fields all write *?

This dataworks offline data synchronization node, I want to synchronize the partitioned table in full volume, how can I synchronize the data of the partitioned fields together if the partitioned fields all write *?

Reference Answer:

Secondary partition all sync can be configured * , is it desired to map the partition as a field to the target Is it possible to add fields in the field mapping

More answers to this question can be found in the original article:

https://developer.aliyun.com/ask/629373

Question 3: odps spark in DataWorks, will there be some security issues involved if it is put under resources?

DataWorks in odps spark, because the content of this file will involve accesskey and accessId of odps, if put under resources will it involve some security issues?

Refer to the answer:

Space parameters support cipher constants https://help.aliyun.com/zh/dataworks/user-guide/use-workspace-parameters?spm=a2c4g.11186623.0.i2

See if it can be configured by passing parameters

More answers to this question can be found in the original article:

https://developer.aliyun.com/ask/629371

Question 4: How can I get the current instance of ecs where dataworks is located?

How to get the current ecs instance where dataworks is located? I'm running a spark task that needs to read the contents of a local server file, which needs to be uploaded to the server where the job is running.

Refer to the answer:

May I ask what is the scenario to use it This is not supported to get, odps spark or emr spark You can consider uploading it as dataworks and engine resources first Then refer to the resources

More answers to this question can be found in the original article:

https://developer.aliyun.com/ask/629370

Question 5: How do I enable all tables in DataWorks?

How do I enable access to all tables in DataWorks?

Reference Answer:

1. Create a custom role in the target project (the project name of this demo is your_projectname).

create role select_only_role.

2. Give the custom role select_onlyrole the Select permission on all tables in the project (including new tables created in future projects)

All tables under the project _

GRANT SELECT ON table * TO Role select_only_role privilegeproperties(“policy” = “true”);

3. Give the user the custom role privilege (you can also add a member to the custom role in Dataworks' custom role web-ui) _

grant role select_only_role to RAM$account@company_name.com:ram_account01;

More answers to this question can be found in the original article:

https://developer.aliyun.com/ask/629369