Does Bigquery support triggers?

Question

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

Answer 1

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.