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 sheet data into a BigQuery table.
| Specify SmartSheet token. |
| Locate the ID of a sheet 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 | Jan. 23, 2020 (2 years, 11 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."
}
},
"sheet": {
"field": {
"name": "sheet",
"kind": "string",
"order": 3,
"description": "Retrieve from sheet properties."
}
},
"link": {
"field": {
"name": "link",
"kind": "boolean",
"order": 7,
"default": true,
"description": "Add a link to each row as the first column."
}
},
"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.