/harlequin-wherobots

Harlequin adapter for Wherobots DB

Primary LanguagePythonApache License 2.0Apache-2.0

Wherobots Adapter for Harlequin

This repository provides the Harlequin adapter for WherobotsDB, using the Wherobots Spatial SQL API and its wherobots-python-dbapi-driver.

Installation

$ pip install harlequin-wherobots

Usage

Procure an API key from Wherobots, and start Harlequin with the required parameters:

$ harlequin -a wherobots --api-key <key>

Alternatively, you can use your session token:

$ harlequin -a wherobots --token <token>

The Harlequin adapter for Wherobots will automatically start a Wherobots SQL session with the default runtime (Sedona, 4 executors) in the default Wherobots public compute region (AWS us-west-2). You can override those defaults with the --runtime and --region options, respectively:

$ harlequin -a wherobots --api-key <key> --runtime NEW_YORK --region AWS_US_WEST_2

Advanced options

If your SQL session is already provisioned and running, you can force the driver to directly connect to it via its WebSocket URL (without protocol version):

$ harlequin -a wherobots --api-key <key> --ws-url <session-url>

You can also specify the base hostname of the Wherobots stack to interact with as the first positional parameter. By default, the driver connects to cloud.wherobots.com, the official public Wherobots service.

$ harlequin -a wherobots --api-key <key> [host]