I hereby claim:
- I am tswast on github.
- I am timswast (https://keybase.io/timswast) on keybase.
- I have a public key ASCPBmBWMaMiH6y4FPDP2Z_EbU9q5ASgdl3zoJAXrM5fGwo
To claim this, I am signing this object:
I hereby claim:
To claim this, I am signing this object:
from google.cloud import bigquery | |
import json | |
GITHUB_USERNAME = 'crwilcox' | |
START_DATE = "2018-03-05" | |
END_DATE = "2018-08-31" | |
client = bigquery.client.Client() | |
query = f"""SELECT repository, type, event AS status, COUNT(*) AS count |
# Copyright 2020 Google LLC | |
# | |
# Licensed under the Apache License, Version 2.0 (the "License"); | |
# you may not use this file except in compliance with the License. | |
# You may obtain a copy of the License at | |
# | |
# https://www.apache.org/licenses/LICENSE-2.0 | |
# | |
# Unless required by applicable law or agreed to in writing, software | |
# distributed under the License is distributed on an "AS IS" BASIS, |
{"rowindex": 0, "repeated_struct_col": [{"nested_struct_col": [{"doubly_nested_array": [1, 2, 3], "doubly_nested_field": "a"}, {"doubly_nested_array": [4, 5, 6], "doubly_nested_field": "b"}]}, {"nested_struct_col": [{"doubly_nested_array": [-1, -2, -3], "doubly_nested_field": "z"}, {"doubly_nested_array": [-4, -5, -6], "doubly_nested_field": "y"}]}]} | |
{"rowindex": 1, "repeated_struct_col": [{"nested_struct_col": [{"doubly_nested_array": [10, 20, 30], "doubly_nested_field": "aa"}, {"doubly_nested_array": [40, 50, 60], "doubly_nested_field": "bb"}]}, {"nested_struct_col": [{"doubly_nested_array": [-10, -22, -33], "doubly_nested_field": "zz"}, {"doubly_nested_array": [-44, -55, -66], "doubly_nested_field": "yy"}]}]} |