databricks-table-valued-functions
OfficialBuild reusable, parameterized SQL for Genie.
Authordatabricks-solutions
Version1.0.0
Installs0
System Documentation
What problem does it solve?
This Skill streamlines the creation and deployment of Databricks Table-Valued Functions (TVFs), ensuring they are optimized for natural language queries in Genie Spaces and adhere to best practices, preventing common SQL errors and improving data accessibility.
Core Features & Use Cases
- End-to-end TVF Lifecycle Management: Covers planning, creation, deployment, and validation of TVFs.
- Genie Compatibility: Ensures TVFs are easily discoverable and usable by AI assistants through proper metadata and parameter handling.
- Error Prevention: Guides users to avoid common pitfalls like incorrect parameter types, cartesian products, and LIMIT clause issues.
- Use Case: A data analyst needs to provide business users with a quick way to get the top 10 performing products by revenue for any given month. This Skill helps them create a robust, parameterized TVF that Genie can understand and execute on demand.
Quick Start
Create a TVF to get the top 5 stores by revenue for the last quarter.
Dependency Matrix
Required Modules
None requiredComponents
scriptsreferencesassets
💻 Claude Code Installation
Recommended: Let Claude install automatically. Simply copy and paste the text below to Claude Code.
Please help me install this Skill: Name: databricks-table-valued-functions Download link: https://github.com/databricks-solutions/vibe-coding-workshop-template/archive/main.zip#databricks-table-valued-functions Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
Agent Skills Search Helper
Install a tiny helper to your Agent, search and equip skill from 223,000+ vetted skills library on demand.