Managed Python User-Defined Functions (UDFs) in BigQuery let you define and execute Python scalar functions directly within your BigQuery SQL queries.

Google Cloud Platform provides a suite of cloud computing services for building, deploying, and managing applications and infrastructure on Google's global network. Developers can learn about cloud-native development, machine learning, and big data analytics to leverage GCP's scalable and reliable cloud infrastructure for their projects.

Google Cloud

BigQuery Managed Python User-Defined Functions (UDFs) are now generally available, enabling data practitioners to run custom Python code directly within BigQuery SQL queries without managing containers or infrastructure. Key features include access to popular Python libraries (NumPy, SciPy, pandas, scikit-learn, BeautifulSoup), external API integration, vectorized processing via PyArrow RecordBatches for up to 10x performance gains, configurable container resources (up to 16 GB RAM, 4 vCPUs), configurable concurrency up to 1,000 concurrent operations, and real-time monitoring via Cloud Monitoring. Billing is handled through BigQuery Services SKU with support for commitment-based discounts.

Python UDF in BigQuery, now generally available

Bridging SQL and the Rich Python Ecosystem