All
waves
BigQuery Anonymize Dataset
Copies tables and view from one dataset to another and anynonamizes all rows. Used to create sample datasets for dashboards.
Impact Level
| Spend Optimization |
|
| Spend Growth |
|
| Time Savings |
|
| Account Health |
|
| Csat Improvement |
|
Value Proposition
| Create anonymous data sets for demos. |
| Anonymize dashboard data. |
Instructions
| Ensure you have user access to both datasets. |
| Provide the source project and dataset. |
| Provide the destination project and dataset. |
Details
| Open Source | YES |
| Age | Feb. 27, 2019 (3 years, 10 months) |
| Authors | kenjora@google.com |
| Manual | Triggered on demand by user. |
[
{
"anonymize": {
"auth": {
"field": {
"name": "auth",
"kind": "authentication",
"order": 0,
"default": "service",
"description": "Credentials used."
}
},
"bigquery": {
"from": {
"project": {
"field": {
"name": "from_project",
"kind": "string",
"order": 1,
"description": "Original project to read from."
}
},
"dataset": {
"field": {
"name": "from_dataset",
"kind": "string",
"order": 2,
"description": "Original dataset to read from."
}
}
},
"to": {
"project": {
"field": {
"name": "to_project",
"kind": "string",
"order": 3,
"default": null,
"description": "Anonymous data will be writen to."
}
},
"dataset": {
"field": {
"name": "to_dataset",
"kind": "string",
"order": 4,
"description": "Anonymous data will be writen to."
}
}
}
}
}
}
]Run This Workflow In Minutes On Google Cloud
Everything from a quick Google Cloud UI to reference developer code for your team in one GitHub repository.