GoogleCloudPlatform / GoogleCloudPlatform/pubsec-declarative-toolkit
Developer Docs: Add local dev environment/authentication docs with googleapis.com example
- Dominant language
- Shell
- Stars
- 36
- Forks
- 26
- PR merge metrics
- No merged PRs in 30d
Description
Several client requests for development environment setup beyond the default google cloud shell
We have a containerized Dockerfile dev environment referenced in gcp-tools https://github.com/ssc-spc-ccoe-cei/gcp-tools/tree/main/devcontainer
We need some initial documentation on creating a minimal dev environment locally outside of a full containerized version
## wiki entry
- https://github.com/GoogleCloudPlatform/pubsec-declarative-toolkit/wiki/DevOps#local-to-gcp-api-calls-over-public-ips
- https://github.com/GoogleCloudPlatform/pubsec-declarative-toolkit/wiki/DevOps#local-development---manual
Include 1 or more specific examples of calling google apis to BigQuery for example via python or java client APIs
# BigQuery Example API call from a local M1 Macbook pro
- BigQuery API call from https://github.com/GoogleCloudPlatform/pubsec-declarative-toolkit/issues/494#issuecomment-1715822826
get auth token
https://cloud.google.com/bigquery/docs/authorization
https://cloud.google.com/docs/authentication/provide-credentials-adc#how-to
https://github.com/GoogleCloudPlatform/shell-samples/blob/HEAD/bigquery/authorization/snippets.sh
```
gcloud auth application-default login
```
after we work with
```
gcloud auth application-default print-access-token
ACCESS_TOKEN="$(gcloud auth application-default print-access-token)"
```
create a default big query table - in this case one of my GPS data exports
[201611185_gps_distinct_rollerblad.csv](https://github.com/GoogleCloudPlatform/pubsec-declarative-toolkit/files/12587461/201611185_gps_distinct_rollerblad.csv)
```
biometric:benchmark michaelobrien$ export GOOGLE_CLOUD_PROJECT=bigquery-ol
biometric:benchmark michaelobrien$ export GOOGLE_CLOUD_PROJECT=bigquery-ol
biometric:benchmark michaelobrien$ curl -H "Authorization: Bearer $ACCESS_TOKEN" \
> "https://www.googleapis.com/bigquery/v2/projects/$GOOGLE_CLOUD_PROJECT/datasets"
{
"kind": "bigquery#datasetList",
"etag": "irRvAdMvQcDWywbnuMPyBg==",
"datasets": [
{
"kind": "bigquery#dataset",
"id": "bigquery-ol:rollerblade",
"datasetReference": {
"datasetId": "rollerblade",
"projectId": "bigquery-ol"
},
"location": "northamerica-northeast1"
}
]
}
curl -H "Authorization: Bearer $ACCESS_TOKEN" https://bigquery.googleapis.com/bigquery/v2/projects/bigquery-ol/datasets/rollerblade
{
"kind": "bigquery#dataset",
"etag": "YGr4j2cVE8o77F0DFWySFg==",
"id": "bigquery-ol:rollerblade",
"selfLink": "https://bigquery.googleapis.com/bigquery/v2/projects/bigquery-ol/datasets/rollerblade",
"datasetReference": {
"datasetId": "rollerblade",
"projectId": "bigquery-ol"
},
...
}
biometric:benchmark michaelobrien$ curl -H "Authorization: Bearer $ACCESS_TOKEN" https://bigquery.googleapis.com/bigquery/v2/projects/bigquery-ol/datasets/rollerblade/tables/rollerblade/data?maxResults=2
{
"kind": "bigquery#tableDataList",
"etag": "wVKEep3xEdb51S3g1w7o3w==",
"totalRows": "4331",
"pageToken": "BHGUBPMJRIAQAAASAUIIBAEAAUNAICACCABCB77777777777757SUACKQAAQUSYKCYFAWYTJM5YXKZLSPEWW63ARQX7PZB65AAAAAEQLOJXWY3DFOJRGYYLEMUNCINLEHE2GIYTEHEWWMMJUMUWTIM3GMQWTQZJQMYWTEMJVGFRWEOJTME3DMMQSBNZG63DMMVZGE3DBMRSRUJBYG5RTQNZUGM3S2YZZGBSC2NBWGVTC2OJYGA4C2ZJXGY4WGMBTGRSGEMLE",
"rows": [
{
"f": [
{
"v": "45.424712"
},
{
"v": "-75.698209"
```
# Developer Guide
- Refer to https://cloud.google.com/java/docs/reference
- https://cloud.google.com/storage/docs/reference/libraries#client-libraries-install-java
- https://github.com/googleapis/google-cloud-java
Contributor guide
Assessment
This issue has not been assessed yet.