firebolt_sdk_connect_execute_sql_query_fetch_results.py

1from firebolt.db import connect
2
3# Connection parameters
4connection = connect(
5    database="your_database",
6    engine_name="your_engine",
7    auth=ClientCredentialsAuth(
8        client_id="your_client_id",
9        client_secret="your_client_secret"
10    ),
11    account_name="your_account_name"
12)
13
14# Create a cursor to execute SQL
15cursor = connection.cursor()
16
17# Execute a query
18cursor.execute("SELECT * FROM your_table LIMIT 10")
19
20# Fetch and print results
21data = cursor.fetchall()
22for row in data:
23    print(row)
24
25# Clean up
26cursor.close()
27connection.close()