SQL

Redpanda SQL (Oxla), the distributed PostgreSQL-wire-compatible columnar analytical database, for writing and running SQL queries. Use when connecting via psql or a PostgreSQL driver, creating tables and schemas, loading data with COPY (CSV/Parquet/ORC, S3), running analytical queries with joins, aggregate and window functions, CTEs, or set operations, creating views, explaining a query plan with EXPLAIN, or working with Oxla's data types and role-based grants. Also covers Oxla's external-source integration for querying Redpanda/Kafka topics and Apache Iceberg tables directly with SQL, including CREATE REDPANDA/KAFKA CATALOG, CREATE ICEBERG CATALOG, CREATE STORAGE, and mapping PostgreSQL SQL features to what Oxla supports.

redpanda-data Updated 34 repo stars

File contents

redpanda-data/skills commit a9b34483c7

Frequently asked questions

npx get-skill add redpanda-data/sql-2