Is BigQuery a transactional database?

Can BigQuery be used for transactional data?

BigQuery supports multi-statement transactions inside scripts. A multi-statement transaction lets you perform mutating operations, such as inserting or deleting rows, on one or more tables, and either commit or roll back the changes atomically.

What type of database is BigQuery?

BigQuery stores data using a columnar storage format that is optimized for analytical queries. BigQuery presents data in tables, rows, and columns and provides full support for database transaction semantics (ACID). BigQuery storage is automatically replicated across multiple locations to provide high availability.

Is BigQuery a relational database?

You need to understand that BigQuery cannot be used to substitute a relational database, and it is oriented on running analytical queries, not for simple CRUD operations and queries. In this article, I will try to compare using Postgres (my favorite relational database) and BigQuery for real-world use case scenarios.

What is an example of a transactional database?

Some examples include: Financial transactional data: insurance costs and claims data, or a purchase or sale; Deposits or withdrawals in case of banks. Logistical transactional data: shipping status, shipping partner data. Work-related transactional data: employee hours tracking.