skills.rest
developer-advocacy-dremio
developer-advocacy-dremioOFFICIAL
Explore all skills by this author →
WebsiteGitHub

Dremio CLI

Manage Dremio Software and Cloud via the dremio-cli command-line interface.

Updated Mar 6, 2026
Search Tags:#automation#cli#catalog#sql#gitops#dremio#dremio-cli
One-click install
npx skills add https://github.com/developer-advocacy-dremio/dremio-skills-bundle --skill dremio-cli
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: Dremio CLI
Source: https://github.com/developer-advocacy-dremio/dremio-skills-bundle/tree/main/dremio-cli-skill
Command: npx skills add https://github.com/developer-advocacy-dremio/dremio-skills-bundle --skill dremio-cli

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill helps operators and AI agents install, configure, and use the dremio-cli to manage Dremio Software and Dremio Cloud from the command line, removing the need to craft raw API requests and reducing manual, error-prone workflows.

Core Features & Use Cases

  • Profile-based Authentication & Configuration: Create and switch named profiles for Software and Cloud, or use environment variables for automation.
  • Catalog, SQL, and Job Management: Execute and validate SQL, poll and manage jobs, list and inspect catalog objects with machine-readable JSON/YAML output.
  • Dremio-as-Code (GitOps): Sync catalog objects to local YAML and SQL files for pull/push Git workflows, enabling reproducible deployments and reviews.
  • Operational Tasks: Create sources, manage spaces/folders, set tags and wiki content, and manage users, roles, and grants for governance.

Quick Start

Install dremio-cli, create a cloud profile with your PAT for the target project, and return the catalog list in JSON format.

Frequently Asked Questions about Dremio CLI

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I manage Dremio catalog objects and execute SQL from the command line?▼

You can manage the Dremio catalog and execute SQL from the command line by using the dremio-cli package. It supports asynchronous SQL execution and outputs machine-readable JSON/YAML for both Dremio Software and Dremio Cloud.

What is Dremio-as-Code and how does it support GitOps workflows?▼

Dremio-as-Code is a sync workflow that pulls Dremio catalog objects into local YAML and SQL files. It enables GitOps workflows by allowing reproducible deployments and pull/push reviews for version-controlled infrastructure.

Do I need Python to use the Dremio command-line interface?▼

Yes, you need Python 3.8 or higher to install and use the dremio-cli package. The command-line interface relies on Python to manage profiles, execute SQL, and synchronize Dremio catalog objects.

Can I automate Dremio source configuration and user management without crafting raw API requests?▼

Yes, you can automate operational tasks like creating sources, managing spaces, and configuring users without raw API requests. The dremio-cli uses profile-based credentials and environment variables to streamline automated Dremio workflows.

How do I configure authentication for Dremio Cloud and Dremio Software in a CLI environment?▼

You configure authentication by creating named profiles with your personal access token or by using environment variables. This profile-based approach supports automation for both Dremio Cloud and Dremio Software.

Related Skills

Explore More Software Engineering Skills→
developer-advocacy-dremiodeveloper-advocacy-dremio

Dremio Python Libraries

Connect Python to Dremix Cloud and Software via Arrow Flight or dataframe workflows using dremio-simple-query and dremioframe libraries.

Official
Intermediate
jluo41jluo41

haipipe-data-1-source

Convert CSV, XML, Parquet, and JSON files into standardized SourceSet assets.

Community
Advanced
gonzalezpazmonicagonzalezpazmonica
47

savia-hub-sync

Synchronize SaviaHub repositories between local and remote instances with Git.

Community
Advanced
developer-advocacy-dremiodeveloper-advocacy-dremio

Basic Dremio REST API

Authenticate to Dremio REST APIs and submit SQL via curl.

Official
Intermediate