-
BigQuery Bulk Insert using Python
To insert multiple rows at once using DML in BigQuery, you can do something like this: The above snippet inserts multiple rows into the table (table with columns: id and createdAt) in one go. You can also see that values types are being supplied (id:STRING and createdAt:TIMESTAMP). Binding the values this way (using parameters) will…
-
InnoDB + MySQL Implicit Autocommit
Today, I spent about an hour debugging a part of the script that I was writing. This is what I faced: I had a function writing some logs into a table. The function was pretty simple as all it had to do was insert some data into a row (using the data passed to it).…