Category : google-bigquery

I stream my data from AppEngine into Bigquery with this code: errors = client.insert_rows(table, bigquery_rows_to_insert) # API request() try: assert errors == [] except AssertionError: handle_error() But I’m getting a server error BadRequest 400 POST No rows present in the request. Why this error could happen? Why didnt exception catch it? Source: Python..

Read more

I am using bigquery and getting the Schema details using the below command bq show –schema –format=prettyjson [PROJECT_ID]:[DATASET].[TABLE] The above command gives me something like the below structure [ { "mode": "NULLABLE", "name": "flt_date", "type": "DATE" }, { "mode": "NULLABLE", "name": "month", "type": "INTEGER" }, { "mode": "NULLABLE", "name": "year", "type": "INTEGER" }, ] I ..

Read more

I am working on GCP and trying to schedule queries in BigQuery by creating transfer configs through programming and required permissions are assigned to the new service account (bigquery.transfers.get, bigquery.transfers.update) and trying to create transfer config using below code. I am able get the information about other already created schedule queries and able to update ..

Read more