All
waves
BigQuery Anonymize Query
Runs a query and anynonamizes all rows. Used to create sample table for dashboards.
Impact Level
| Spend Optimization |
|
| Spend Growth |
|
| Time Savings |
|
| Account Health |
|
| Csat Improvement |
|
Value Proposition
| Create anonymous tables for demos. |
| Anonymize dashboard data. |
Instructions
| Ensure you have user access to both datasets. |
| Provide the source project, dataset and query. |
| Provide the destination project, dataset, and table. |
Details
| Open Source | YES |
| Age | Jan. 1, 2021 (2 years) |
| Authors | kenjora@google.com |
| Manual | Triggered on demand by user. |
[
{
"anonymize": {
"auth": {
"field": {
"name": "auth_read",
"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."
}
},
"query": {
"field": {
"name": "from_query",
"kind": "string",
"order": 3,
"description": "Query to read data."
}
}
},
"to": {
"project": {
"field": {
"name": "to_project",
"kind": "string",
"order": 4,
"default": null,
"description": "Anonymous data will be writen to."
}
},
"dataset": {
"field": {
"name": "to_dataset",
"kind": "string",
"order": 5,
"description": "Anonymous data will be writen to."
}
},
"table": {
"field": {
"name": "to_table",
"kind": "string",
"order": 6,
"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.