cli

Overview

The dremio-cli tool wraps the Dremio Cloud REST API and system tables into a cohesive command-line interface. It enables tasks like running SQL queries, managing reflections, checking catalogs, monitoring jobs, and auditing dataset access permissions through simple terminal commands or structured LLM tool integrations.

Capabilities

• ▸Execute and manage SQL queries
• ▸Browse and modify catalog items (spaces, folders, wikis, tags)
• ▸Manage reflections and compute engines
• ▸Audit permissions, user roles, and access control lists
• ▸Search across catalog entities and job history

Best for

Executing SQL queries and inspecting job statuses, Managing spaces, folders, schemas, and catalog metadata, Auditing user access, role grants, and dataset permissions, Creating and maintaining database reflections and engines, Integrating Dremio Cloud management into automated agent pipelines

Works with

Security considerations

Requires a Dremio Personal Access Token (PAT) with project-level privileges. Ensure environment variables or config files containing credentials have restricted permissions.

Categories