Read JSON into BigQuery | Dataford Interview Questions

Write a function that reads a JSON file and loads it into BigQuery.

Asked in the round 1 stage. For deterministic grading, the file contents are supplied as file_content; the function validates a JSON array of objects and returns the number of records that would be loaded.

Input and Output

file_path, project_id, dataset_id, and table_id are strings. file_content is a JSON string whose root must be an array of objects. Return the record count. Raise ValueError for an invalid root.

Constraints

All file and destination parameters are strings
file_content is valid JSON for valid inputs
The JSON root must be an array
Every array element must be a JSON object
The number of records is between 0 and 10^4

Function Signature

def load_json_to_bigquery(file_path, project_id, dataset_id, table_id, file_content):

Your question is Read JSON into BigQuery. Start with the requirements in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.

Problem