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 report data into a BigQuery table.
| Specify SmartSheet Report token. |
| Locate the ID of a report by viewing its properties. |
| Provide a BigQuery dataset (must exist) and table to write the data into. |
| StarThinker will automatically map the correct schema. |
| Open Source | YES |
| Age | July 14, 2020 (2 years, 5 months) |
| Authors | kenjora@google.com |
| Shedule Days | Configured by user. |
| Shedule Hours | Configured by user. |
[
{
"smartsheet": {
"auth": {
"field": {
"name": "auth_read",
"kind": "authentication",
"order": 0,
"default": "user",
"description": "Credentials used for reading data."
}
},
"token": {
"field": {
"name": "token",
"kind": "string",
"order": 2,
"default": "",
"description": "Retrieve from SmartSheet account settings."
}
},
"report": {
"field": {
"name": "report",
"kind": "string",
"order": 3,
"description": "Retrieve from report properties."
}
},
"out": {
"bigquery": {
"auth": {
"field": {
"name": "auth_write",
"kind": "authentication",
"order": 1,
"default": "service",
"description": "Credentials used for writing data."
}
},
"dataset": {
"field": {
"name": "dataset",
"kind": "string",
"order": 4,
"default": "",
"description": "Existing BigQuery dataset."
}
},
"table": {
"field": {
"name": "table",
"kind": "string",
"order": 5,
"default": "",
"description": "Table to create from this report."
}
},
"schema": {
"field": {
"name": "schema",
"kind": "json",
"order": 6,
"description": "Schema provided in JSON list format or leave empty to auto detect."
}
}
}
}
}
}
]Everything from a quick Google Cloud UI to reference developer code for your team in one GitHub repository.