Skip to content
Dell Data Analytics Engine 443-e.26 LTS logo
SQL routines
Type to start searching

    Get started

    • What is Starburst Enterprise?
    • Learn Starburst Enterprise
    • Versions
    • Release notes
    • Get support

    For all users

    • Starburst Enterprise web UI
    • Clients
    • Data products
    • Insights

    Use SQL

    • SQL language
    • SQL statement syntax
    • Functions and operators
    • SQL routines
      • Introduction
      • Examples
      • BEGIN
      • CASE
      • DECLARE
      • FUNCTION
      • IF
      • ITERATE
      • LEAVE
      • LOOP
      • REPEAT
      • RETURN
      • SET
      • WHILE

    For data engineers

    • Define catalogs
    • Materialized views
    • Query optimizer

    Connect to data sources

    • Connector overview
    • Object storage connectors
    • Non-object storage connectors
    • Utilities
    • Community-supported connectors
    • Starburst connectors feature matrix
    • Monitor and manage cost and performance

    For platform administrators

    • Administration topics
    • Performance, logging, and governance features
    • Security
    • Starburst Enterprise REST API

    SEP deployment mechanisms

    • Starburst Enterprise license
    • Deploy with Kubernetes
    • Manual installation and license

    Appendix

    • Trino developer guide
    • Version-specific notices and information
    • Topic areas

    SQL routines#

    A SQL routine is a custom, user-defined function authored by a user of SEP in a client and written in SQL.

    Note

    SQL routines are available as a public preview in Starburst Enterprise. Contact Starburst Support with questions or feedback.

    More details are available in the following sections:

    • Introduction
    • Examples
    • BEGIN
    • CASE
    • DECLARE
    • FUNCTION
    • IF
    • ITERATE
    • LEAVE
    • LOOP
    • REPEAT
    • RETURN
    • SET
    • WHILE
    Previous Window functions
    Next Introduction to SQL routines