The StarThinker project will no longer receive new solution contributions from the Google team.
Please read the full StarThinker Open Source Support Ends At Google article for more details.
Move SA360 report to BigQuery.
| Spend Optimization |
|
| Spend Growth |
|
| Time Savings |
|
| Account Health |
|
| Csat Improvement |
|
| Move report data to BigQuery quickly. |
| Assemble with other tasks to create a workflow. |
| Fill in the report definition and destination table. |
| Wait for BigQuery->->-> to be created. |
| Or give these intructions to the client. |
| Open Source | YES |
| Age | Sept. 14, 2021 (1 year, 3 months) |
| Authors | kenjora@google.com |
| Shedule Days | Configured by user. |
| Shedule Hours | Configured by user. |
[
{
"sa": {
"description": "Create a dataset for bigquery tables.",
"auth": {
"field": {
"name": "auth_sa",
"kind": "authentication",
"order": 1,
"default": "service",
"description": "Credentials used for writing data."
}
},
"body": {
"field": {
"name": "report",
"kind": "json",
"order": 4,
"default": {},
"description": "Body part of report request API call."
}
},
"out": {
"bigquery": {
"auth": {
"field": {
"name": "auth_bq",
"kind": "authentication",
"order": 1,
"default": "service",
"description": "Authorization used for writing data."
}
},
"dataset": {
"field": {
"name": "dataset",
"kind": "string",
"order": 2,
"default": "",
"description": "Existing BigQuery dataset."
}
},
"table": {
"field": {
"name": "table",
"kind": "string",
"order": 3,
"default": "",
"description": "Table to create from this report."
}
},
"is_incremental_load": {
"field": {
"name": "is_incremental_load",
"kind": "boolean",
"order": 4,
"default": false,
"description": "Clear data in destination table during this report's time period, then append report data to destination table."
}
},
"header": true
}
}
}
}
]Everything from a quick Google Cloud UI to reference developer code for your team in one GitHub repository.