Python Developer

I'm trying to use try/except to query BigQuery tables, sometimes the query may not be correct i… Read more Pandas Genericgbqexception

I have a few large hourly upload tables with RECORD fieldtypes. I want to pull select records out o… Read more Bigquery: How To Preserve Nested Data In Derived Tables?

I'd like to use BigQuery Standard SQL in a new project, however I am not able to find any examp… Read more How To Define Bigquery Schema Using Standard Sql?

I am exploring ways to bring BigQuery data into Python, here is my code so far: from google.cloud i… Read more Live Data From Bigquery Into A Python Dataframe

I have a certain query which is working fine. The problem is that a part of that query is a string … Read more Union All Parameterised Queries

def downloadGbqToCsv(self,table_name,csv): credentials = GoogleCredentials.get_application… Read more Downloading Table Data As Csv To Local Machine In Big Query

Quite new to this google bigquery sql thing so please bear with me. I'm trying to build a googl… Read more Running Parameterized Queries

The Python 'teardown_class' is not behaving as I expect it to. Below is a summary of my cod… Read more Pytest Teardown_class Is Being Run Too Soon