skills.rest
yunqiqiliang
yunqiqiliangCOMMUNITY
Explore all skills by this author →
GitHub

clickzetta-external-function

Register external functions and UDFs for SQL invocation via cloud providers.

8|3|Updated Mar 19, 2026
Search Tags:#ai#sql#lambda#udf#cloud-function#cloud-provider#external-function
One-click install
npx skills add https://github.com/yunqiqiliang/clickzetta-skills --skill clickzetta-external-function
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: clickzetta-external-function
Source: https://github.com/yunqiqiliang/clickzetta-skills/tree/main/clickzetta-external-function
Command: npx skills add https://github.com/yunqiqiliang/clickzetta-skills --skill clickzetta-external-function

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

Traditional SQL engines are limited to built-in functions and local logic. This Skill enables SQL to invoke external compute services (cloud functions) and run user-defined functions (UDFs) in Python/Java or via AI services, bridging SQL with AI, image processing, and custom algorithms.

Core Features & Use Cases

  • API connections: create and manage connections to cloud function providers (Alibaba Cloud FC, Tencent SCF, AWS Lambda) to host UDFs and AI services.
  • External functions: define and deploy UDFs/UDTFs/UDAFs that run in the cloud or in user volumes.
  • Built-in AI functions: use AI_COMPLETE and AI_EMBEDDING for LLM and embeddings directly from SQL.
  • Use cases: data enrichment, model inference, image processing, or private model integration within SQL workflows.

Quick Start

Create your first API connection to a cloud function provider, deploy a simple Python UDF, then call it from a SQL query to process a column.

Frequently Asked Questions about clickzetta-external-function

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I invoke AI services directly from SQL queries?▼

You can invoke AI services directly from SQL queries by using built-in functions like AI_COMPLETE and AI_EMBEDDING, or by registering external functions that route compute to cloud function providers.

Can I run Python UDFs on AWS Lambda from my SQL engine?▼

Yes, you can run Python UDFs on AWS Lambda by creating an API connection to the cloud provider, packaging your UDF, and registering it as an external function within your SQL engine.

What is the best way to extend SQL with custom image processing logic?▼

The best way to extend SQL with custom image processing logic is to define and deploy UDFs that execute in cloud functions or user volumes, bridging SQL with external compute services.

Does this approach support deploying external functions across different cloud providers?▼

Yes, this approach supports deploying external functions across major cloud providers, allowing you to create and manage API connections to Alibaba Cloud FC, Tencent SCF, and AWS Lambda.

When do I need to use external functions instead of built-in SQL functions?▼

You need to use external functions instead of built-in SQL functions when your workflows require custom algorithms, private model integration, or data enrichment that exceeds local SQL engine capabilities.

What types of user-defined functions can I package and deploy using external compute?▼

You can package and deploy Python and Java user-defined functions, including UDFs, UDTFs, and UDAFs, to execute external compute via API connections to cloud function providers.

Related Skills

Explore More Software Engineering Skills→
Snowflake-LabsSnowflake-Labs
1

sql-server-connection

Establish and test secure SQL Server database connections for migration workflows.

Official
Intermediate
voxel51voxel51
37

fiftyone-dataset-inference

Run Zoo model inference on FiftyOne datasets for detection, classification, and embeddings.

Official
Intermediate
Zack2626-okZack2626-ok

databricks-ai-functions

Invoke Databricks AI Functions for sentiment analysis, classification, and summarization in SQL and PySpark pipelines.

Community
Advanced
nrminornrminor

duckdb

Query Parquet, CSV, and JSON files in place with DuckDB SQL.

Community
Intermediate