Running Python Functions in SQL (BigQuery Example)

Published: 06 March 2023
on channel: Nodematic Tutorials

1,853

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/bigq...

Free Trial - Our New Diagram Tool: https://softwaresim.com/pricing/ ("YOUTUBE24" for 25% Off)

0:00 Conceptual Overview
1:09 Dataset and Table Setup
2:26 Cloud Function Setup
5:08 Data Connection and IAM Setup
7:11 SQL Queries

On this page of the site you can watch the video online Running Python Functions in SQL (BigQuery Example) with a duration of hours minute second in good quality, which was uploaded by the user Nodematic Tutorials 06 March 2023, share the link with friends and acquaintances, this video has already been watched 1,853 times on youtube and it was liked by 11 viewers. Enjoy your viewing!

8,150

620