Python

Learn about using the Python SDK for Firebolt.

You can use the Python SDK to work with Firebolt.

Prerequisites

• Python >=3.10
• firebolt-sdk version 1.18.3 or higher

Installation

pip install "firebolt-sdk>=1.18.3"

Connect to managed Firebolt

from firebolt.db import connect
from firebolt.client.auth import ClientCredentials

with connect(
        auth=ClientCredentials(client_id, client_secret),
        account_name="your_account",
        database="your_database",
        engine_name="your_engine"
) as connection:
    cursor = connection.cursor()
    cursor.execute("SELECT 1")

Further reading

• Firebolt Python SDK documentation
• The firebolt-python-sdk repository on GitHub
• Code examples (in Jupyter notebooks) in the SDK repository that demonstrate common data tasks and management tasks