firebolt-sdk

What it is and what it does

Firebolt-sdk is a Python database driver that implements the DB API 2.0 specification for connecting to Firebolt, a cloud analytics database. It handles authentication via client credentials, manages connections and cursors, and provides standard SQL execution and result-fetching methods. The package uses async I/O under the hood (httpx, anyio, trio) to support non-blocking operations, though the public API presents a synchronous DB API interface.

The SDK is designed for analytics workloads where you need to execute SQL queries against Firebolt and retrieve results. It supports switching between databases and engines via SQL commands, but enforces restrictions on certain SET parameters to prevent misconfiguration. Cursors are not thread-safe and must not be shared across threads, though connections can be; this aligns with DB API thread-safety level 2. An optional faster datetime parser (ciso8601) can be installed separately for performance-critical applications.

Use it for:

• Execute SQL queries against a Firebolt database from a Python application or script.
• Build ETL pipelines that read from or write to Firebolt using standard DB API patterns.
• Integrate Firebolt analytics into Jupyter notebooks or data science workflows.
• Connect multiple Python threads to the same Firebolt database (each with its own cursor).
• Optimize datetime parsing in high-volume query result processing with the ciso8601 extra.

Worth the install?

AI-flagged interpretation of the facts on this page — verify before relying

Firebolt-sdk provides a Python DB API 2.0-compatible interface to connect to and query Firebolt databases, handling authentication, connection management, and result retrieval.

Yes. Active maintenance, low install friction, permissive license, and no known vulnerabilities make this a solid choice for Python applications needing Firebolt connectivity. The standard DB API 2.0 interface means minimal learning curve for developers familiar with Python database libraries. Install it if you are working with Firebolt; the only caveat is to respect the cursor thread-safety constraint in multi-threaded code.

Install

firebolt-sdk on PyPI

pip install firebolt-sdk

uv add firebolt-sdk

poetry add firebolt-sdk

Installing firebolt-sdk

Before you install

Low friction install with a pure-Python wheel. Active maintenance with recent releases; last commit 2026-08-14. Requires Python >=3.9 and brings in 15 runtime dependencies including httpx, pydantic, and cryptography for async HTTP and credential handling.

License in practice

Apache License 2.0 (permissive) allows use in commercial and open-source projects with minimal restrictions; you must include a copy of the license and note any modifications.

Quickstart

pip install firebolt-sdk

from firebolt.db import connect

conn = connect(
    account_name="your_account",
    client_id="your_client_id",
    client_secret="your_client_secret",
    database="your_database"
)
cursor = conn.cursor()
cursor.execute("SELECT * FROM table")
results = cursor.fetchall()

Requires Python >=3.9; Firebolt account credentials (account_name, client_id, client_secret) must be available.

Verify before relying

• Performance characteristics and query latency expectations for typical workloads.
• Whether optional ciso8601 dependency is automatically installed or requires explicit opt-in.
• Concurrency model details beyond the stated cursor thread-safety level 2.

Package facts

Evidence: firebolt_sdk-1.18.6-py3-none-any.whl

Tags

More Front-Ends packages