Sho't left to data science

Tag: bigquery

  • GCP BigQuery Scripting

    —

    by

    shotlefttodatascience
    in

    BigQuery stored procedures are incredibly useful. Google defines them as being “a collection of statements that can be called from other queries or other stored procedures. A procedure can take input arguments and return values as output.” Lovely! So we can declare some variables and then feed them as input arguments to our stored procedure…

  • Tutorial: BigQuery arrays and structs

    —

    by

    shotlefttodatascience
    in

    The first time I encountered the BigQuery export schema this year my heart sank: arrays and structs were not something covered in my SQL intro course! But having spent a few months extracting data like this I’ve come to appreciate the logic. These are all the ‘notes to self’ I wish I’d had at the…