CODEWITHSUNDEEP
google-cloud-platformgoogle-bigquery
user3878636
user3878636

Reputation: 183

Does Bigquery support triggers?

We are currently using AWS RDS as our databases. In tables, we defined some insert or update triggers on tables. I would like to know if Bigquery also support triggers?

thanks

Upvotes: 13

Views: 13176

Answers (3)

Ayush Maheshwari
Ayush Maheshwari

Reputation: 47

You can use Google Clod run for any event triggers in Big query. This is based on logs written for each record.

Reference :- https://cloud.google.com/blog/topics/developers-practitioners/how-trigger-cloud-run-actions-bigquery-events

Upvotes: -2

Vítor
Vítor

Reputation: 21

Big Query doesn't have the feature as stated by the colleague above. However it has an event api based on it's audit logs. You can inspect it and trigger events with cloud functions as per: https://cloud.google.com/blog/topics/developers-practitioners/how-trigger-cloud-run-actions-bigquery-events

Regards

Upvotes: 2

Pentium10
Pentium10

Reputation: 207952

BigQuery is a data warehouse product, similar to AWS Redshift and AWS Athena and there is no trigger support.

If you used AWS RDS so far, you need to check Google CloudSQL.

Google Cloud SQL is an easy-to-use service that delivers fully managed SQL databases in the cloud. Google Cloud SQL provides either MySQL or PostgreSQL databases.

If you have a heavy load, then check out Google Cloud Spanner it's even better for full scalable relational db.

Cloud Spanner is the only enterprise-grade, globally-distributed, and strongly consistent database service built for the cloud specifically to combine the benefits of relational database structure with non-relational horizontal scale.

Upvotes: 12

Related Questions