Configure DBeaver to connect to Firebolt using the JDBC driver.
DBeaver is a free, open-source database administration tool that supports multiple database types. It provides a graphical interface for managing databases, running queries, and analyzing data. DBeaver is widely used for database development, troubleshooting, and administration, making it a versatile choice for both developers and database administrators. You can connect DBeaver to Firebolt using the Firebolt JDBC driver.
You must have the following prerequisites before you can connect your Firebolt account to DBeaver:
To connect to Firebolt, you must add the Firebolt JDBC driver to DBeaver as follows:
Firebolt
com.firebolt.FireboltDriver
To connect to Firebolt, you must configure a new database connection in DBeaver as follows:
In DBeaver, select Database, then New Database Connection.
Enter Firebolt
in the search box, then select it from the list.
Select Next>.
Enter the connection parameters in the Main tab as follows:
Parameter | Description |
---|---|
JDBC URL | Use jdbc:firebolt:<db_name>?engine=<engine_name>&account=<account_name> replacing <db_name> with your Firebolt database name, <engine_name> with your engine name and <account_name> with your account name. |
Username | Your Firebolt service account ID. |
Password | Your Firebolt service account secret. |
Select Test Connection to verify the connection. Ensure your Firebolt database is running before testing.
If the connection is successful, select Finish.