To do a real-time insert of records into BigQuery, use the streaming insert feature. Loading records from a file to a BigQuery table is free but inserting rows via API is not free. Streaming insert is an inevitable feature if your vision is to implement real-time reporting and analytics. The following code shows inserting simple records via API to a table in BigQuery. The column values are loaded into a dictionary object added to a collection and passed to BigQuery API via the InsertRows method:

Call the InsertRowsViaAPI method to insert the framed records to the BigQuery table. The rows inserted by API are available for querying in a few seconds, but to copy or export those records, it can take up to 90 minutes. When using the streaming insert feature, consider the cost of inserting and the limitations of copying or exporting the records: