Skip to content
Starburst Enterprise 448-e STS logo
Documentation: Starburst Enterprise 448-e STS SQL routines
Product:
Latest LTS (443-e) 435-e LTS 429-e LTS 423-e LTS Latest STS (449-e) 448-e STS
  • Introduction
  • Clients
  • Starburst Galaxy
  • Starburst Enterprise
  • Resources

Get started

  • Overview
  • What is Starburst Enterprise?
  • Try Starburst Enterprise
  • Learn Starburst Enterprise
  • Product 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

Deploy in cloud ecosystems

  • AWS ecosystem
  • Google Cloud
  • Microsoft Azure
  • Red Hat OpenShift

SEP deployment mechanisms

  • Starburst Enterprise license
  • Deploy with Kubernetes
  • Deploy with Starburst Admin
  • Deploy with CFT on AWS
  • Local installation

Appendix

  • Trino developer guide
  • Version-specific notices and information

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

Is the information on this page helpful?

Yes

No

Cancel
Previous Window functions
Next Introduction to SQL routines

Resources

  • Starburst Enterprise reference documentation
  • Video library
  • Glossary
  • Free O'Reilly book - Trino: The Definitive Guide
  • Trino Community Broadcast
  • Starburst blog

Contact and more

  • Starburst
  • Join our weekly demos
  • Start a trial
  • Get support
  • Contact us
Starburst Enterprise 448-e STS logo
  • Copyright © 2017-2024
    Starburst Data
  • Trademark information