BigQuery Remote Functions allows us to run data processing logic, using languages like Python, Golang (Go), Javascript, and Java. Specifically, BigQuery will call a Google Cloud Function when the remote function is built into any normal BigQuery SQL query. This pattern not only enables complex algorithms in BigQuery data processing, but can also democratize algorithms and specialized processing, such that non-programers can use the logic (via SQL). The setup is simple, serverless, and secure.
Example Code Repository: https://github.com/nodematiclabs/bigquery-remote-functions-example