DLT SQL language reference

This section has details for the DLT SQL programming interface.

• For conceptual information and an overview of using DLT SQL, see Develop pipeline code with SQL.
• For information on the Python API, see the DLT Python language reference.
• For more information about SQL in Databricks, see SQL language reference.

You can use Python user-defined functions (UDFs) in your SQL queries, but you must define these UDFs in Python files before calling them in SQL source files. See User-defined scalar functions - Python.

SQL statements

Use these statements to work with pipelines in DLT SQL.

• APPLY CHANGES INTO
• CREATE FLOW
• CREATE TEMPORARY VIEW
• CREATE MATERIALIZED VIEW
• CREATE STREAMING TABLE