onehouse-cli 0.1.4

A command-line tool for executing SQL commands against the Onehouse API

Onehouse CLI

A command-line tool for executing SQL commands against the Onehouse API with synchronous responses.

Installation

pip install onehouse-cli

Setup

Configure credentials:

onehouse-cli-configure

This will prompt you for:

• Profile name
• Account UID
• Project UID
• API Key
• API Secret
• Project Region
• User ID
• Request ID
• API Endpoint (defaults to https://api.onehouse.ai/v1)
  • Press Enter to use the default endpoint

Credentials are stored in: ~/.onehouse/credentials

Usage

Execute SQL commands:

onehouse-cli --command "SHOW LAKES" --profile myprofile

List available profiles:

onehouse-cli --list-profiles

Custom timeout (default: 10 minutes):

onehouse-cli --command "ALTER OCU SET LIMIT = '3'" --profile myprofile --timeout 5

Features

• Synchronous execution: Automatically polls for completion (1s intervals)
• Multiple profiles: Store and switch between different API credentials
• Error handling: Clear error messages with headers and response details
• Timeout control: Configurable wait time for long-running operations
• Status checking: Check the status of an existing request by providing its request ID

Examples

# Configure first profile
onehouse-cli-configure

# Execute queries
onehouse-cli --command "SHOW LAKES" --profile apex
onehouse-cli --command "DELETE CLUSTER managed_cluster_retail" --profile apex

# Manage profiles
onehouse-cli --list-profiles

# Check status of an existing request
onehouse-cli --check-status "<REQUEST_ID>" --profile myprofile