Back to the Index

SQL UDF in Python

What is a python UDF in SQL?

A SQL UDF (User-Defined Function) is a custom function that extends the capabilities of SQL by allowing users to implement complex logic and transformations that are not available with built-in SQL functions. This is important for feature engineering and model inference, as custom feature functions or inference pipelines can be written in a language like Python and can then be invoked from within a SQL query.

Interested for more?

Does this content look outdated? If you are interested in helping us maintain this, feel free to contact us.
S
AI Lakehouse
AI Pipeline
Auto-regressive Models
AutoML
S
Backfill features
Backfill training data
Backpressure for feature stores
Batch Inference Pipeline
S
CI/CD for MLOps
Compound AI Systems
Context Window for LLMs
S
DAG Processing Model
Data Compatibility
Data Contract
Data Lakehouse
Data Leakage
Data Modeling
Data Partitioning
Data Pipelines
Data Quality
Data Transformation
Data Type (for features)
Data Validation (for features)
Data Warehouse
Data-Centric ML
Dimensional Modeling and Feature Stores
Downstream
Query Engines
S
ELT
ETL
Embedding
Encoding (for Features)
Entity
S
Feature
Feature Data
Feature Engineering
Feature Freshness
Feature Function
Feature Groups
Feature Logic
Feature Monitoring
Feature Pipeline
Feature Platform
Feature Reuse
Feature Selection
Feature Service
Feature Store
Feature Type
Feature Value
Feature Vector
Feature View
Filtering
Fine-Tuning LLMs
S
Generative AI
Gradient Accumulation
Grouped Query Attention
S
Hallucinations in LLMs
Hyperparameter
Hyperparameter Tuning
S
Idempotent Machine Learning Pipelines
In Context Learning (ICL)
Inference Data
Inference Logs
Inference Pipeline
Instruction Datasets for Fine-Tuning LLMs
S
LLM Code Interpreter
LLM Temperature
LLMOps
LLMs - Large Language Models
Lagged features
LangChain
Latent Space
S
ML
ML Artifacts (ML Assets)
MLOps
MLOps Platform
MVPS
Machine Learning Infrastructure
Machine Learning Logs
Machine Learning Observability
Machine Learning Pipeline
Machine Learning Systems
Model Architecture
Model Bias
Model Deployment
Model Development
Model Evaluation (Model Validation)
Model Governance
Model Inference
Model Interpretability
Model Monitoring
Model Performance
S
Natural Language Processing (NLP)
S
Offline Store
On-Demand Features
On-Demand Transformation
Online Inference Pipeline
Online Store
Online-Offline Feature Skew
Online-Offline Feature Store Consistency
Orchestration
S
KServe
PagedAttention
Pandas UDF
Parameter-Efficient Fine-Tuning (PEFT) of LLMs
Point-in-Time Correct Joins
Precomputed Features
Prompt Engineering
Prompt Store
Prompt Tuning
Python UDF
S
RLHF - Reinforcement Learning from Human Feedback
Real-Time Machine Learning
Recommender System
Representation Learning
Retrieval Augmented Generation (RAG) for LLMs
RoPE Scaling
S
Sample Packing
Schema
Similarity Search
Skew
Splitting Training Data
Streaming Feature Pipeline
Streaming Inference Pipeline
S
Test Set
Theory-of-Mind Tasks
Time travel (for features)
Train (Training) Set
Training Data
Training Pipeline
Training-Inference Skew
Transformation
Two-Tower Embedding Model
Types of Machine Learning
S
Upstream
S
Validation Set
Vector Database
Versioning (of ML Artifacts)
vLLM