Problem I have the below function get_status_time which calculates the start time and the end time of the spark job […]
Tag: google-bigquery
Execute several queries and save them to files in Bash
Problem I wrote the following bash script to run queries saved in files and save them to csv files. The […]
How to fine tune the complex python function for creating merge command to run in bigquery
Problem I created a python code to run the merge command in Google BigQuery, which is used to do UPDATE, […]
building a shell command inside python function based on different conditions
Problem I have written the below python function which is working fine but there are lot of code which looks […]
Creating SQL query for relative timeframes and multiple tables
Problem What I want to achieve: I have several tables of the following schema: +——+——-+ | date | val | […]