DeltaForge documentation

Every documented command, function, operator, type, and setting, linked directly so you (and search engines) can reach any reference page in two clicks.

Prefer to browse interactively? Open the interactive documentation. Building with an agent? The corpus is machine-readable at llms.txt.

• SQL Commands

  Every SQL statement DeltaForge understands, from DDL and DML through catalog, security, pipeline, and graph commands.

  207 entries

• Built-in Functions

  The built-in scalar and aggregate functions for math, strings, dates, JSON, regex, hashing, geospatial work, and H3 indexing.

  415 entries

• Operators

  Arithmetic, comparison, logical, pattern-matching, JSON, array, and bitwise operators with their precedence and semantics.

  40 entries

• SQL Keywords

  The full reserved and non-reserved keyword vocabulary, including the DeltaForge extensions on top of standard SQL.

  474 entries

• Data Types

  The numeric, string, temporal, boolean, binary, and complex types, with their storage and casting behaviour.

  58 entries

• Table Properties

  Delta table properties that control auto-optimize, deletion vectors, statistics, clustering, retention, and Universal Format.

  105 entries

• PL/pgSQL

  The procedural language for stored logic: declarations, control flow, cursors, dynamic SQL, and error handling.

  25 entries

• Pipeline Configuration

  Clauses and defaults that define pipelines and their schedules, from lifecycle to cron and approval workflow.

  40 entries

• Data Sources

  The external sources DeltaForge reads, spanning cloud storage, databases, file formats, EDI, and healthcare feeds.

  23 entries

• Spatial Functions

  PostGIS-style geospatial functions and Uber H3 hexagonal indexing exposed directly as SQL.

  40 entries

• Graph Analytics

  Graph algorithms for centrality, community detection, pathfinding, and similarity, callable as SQL and Cypher.

  48 entries

• ODBC Driver

  The native ODBC driver: getting started, connection-string options, type mapping, and BI-tool setup.

  30 entries

• CLI Reference

  The command-line client: authentication, configuration, scripting, the REPL, and every global flag.

  90 entries

• GUI Reference

  The desktop application reference covering the catalog, compute, connections, access control, and workflow surfaces.

  31 entries

• Demos

  Runnable end-to-end demos across Delta, Iceberg, graph, healthcare, EDI, geospatial, and every supported file format.

  68 entries