CODEWITHSUNDEEP
google-cloud-platformgoogle-bigquerygoogle-cloud-sql
vaishali bisht
vaishali bisht

Reputation: 201

Big Query vs Cloud SQL for audit data

Which database is better for transactional data - cloud SQL or Google Big query?

I have a requirement wherein from multiple jobs I need to load data into a single table. Which database will be better for this Google Big query or Cloud SQL?

I know that in terms of cost effectiveness cloud sql is a better choice. But are there any other pointers apart from this?

Upvotes: 0

Views: 661

Answers (1)

Iñigo González
Iñigo González

Reputation: 3955

CloudSQL is a managed database for transactional loads (OLTP). It can be tweaked to work with OLAP (analytical); but it is intended to be a transactional database.

BigQuery is for analytical data (OLAP), that's data that won't change. Think of it as data "at rest" that's not going to be changed.

If some of your transactions are not finalized (there are in-flight transactions, or your end-to-end process need some steps), you need a transactional database - like the ones from Cloud SQL.

If your data won't change, use BigQuery.

Upvotes: 1

Related Questions