Basic Dremio REST API

What problem does it solve?

Many users and AI agents need a reliable, reproducible way to interact with Dremio programmatically, but struggle with authentication differences, API versioning, and the correct curl patterns for submitting SQL, polling jobs, and retrieving results. This Skill centralizes the required steps, environment variable conventions, and links to official docs so agents can build requests correctly and avoid common mistakes.

Core Features & Use Cases

• Authentication guidance for Personal Access Tokens (PATs) and fallback login tokens for self-hosted instances.
• Environment variable conventions and prompts to collect edition-specific values like DREMIO_URL, DREMIO_PAT, and DREMIO_CLOUD_PROJECT_ID.
• Practical curl patterns for SQL submission, job polling, result retrieval, and catalog listing, plus references to the Dremio Software and Dremio Cloud API docs.
• Use Case: Run an asynchronous SQL job against a Dremio cluster, poll for completion, and fetch the results programmatically using shell tools like curl and jq.

Quick Start

Authenticate to your Dremio instance using a PAT or login token, set the required environment variables for your edition, and run a catalog listing curl request to verify connectivity.