Skills
.Work. You
Rest

Dremio SQL Reference

Official

Accurate Dremio SQL for Iceberg & versioning

Data & Analytics#rbac#sql#iceberg#time-travel#reflections#dremio#copy-into
Authordeveloper-advocacy-dremio
Version1.0.0
Installs0

System Documentation

What problem does it solve?

This skill removes guesswork when authoring SQL for Dremio by summarizing Dremio-specific syntax, constraints, and best practices so agents produce queries and DML that run correctly against Dremio engines and Iceberg tables.

Core Features & Use Cases

  • Dialect Guidance: Explains identifier quoting, path formats, and Calcite-based syntax differences.
  • Iceberg DML & Maintenance: Covers INSERT/UPDATE/DELETE/MERGE, OPTIMIZE, VACUUM, ROLLBACK and when DML is allowed.
  • Versioned Queries & Time Travel: Shows AT BRANCH / AT TAG / AT SNAPSHOT / AT TIMESTAMP usage for Nessie/Arctic catalogs.
  • Reflections, RBAC & PIPE: Includes reflection creation syntax, grant/revoke patterns, and COPY INTO / PIPE ingestion examples.
  • Reference Index: Direct links to official Dremio docs for exact command semantics and edge-case details.

Quick Start

Ask the agent to write a Dremio-compatible query that selects from an Iceberg table at branch main and includes proper quoting for identifiers.

Dependency Matrix

Required Modules

None required

Components

Standard package

💻 Claude Code Installation

Recommended: Let Claude install automatically. Simply copy and paste the text below to Claude Code.

Please help me install this Skill:
Name: Dremio SQL Reference
Download link: https://github.com/developer-advocacy-dremio/dremio-skills-bundle/archive/main.zip#dremio-sql-reference

Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
View Source Repository

Agent Skills Search Helper

Install a tiny helper to your Agent, search and equip skill from 471,000+ vetted skills library on demand.