Connecting to Databend Cloud using BendSQL

In this tutorial, we will guide you through the process of connecting to Databend Cloud using BendSQL.

1

Before You Start

• Ensure that BendSQL is installed on your machine. See Installing BendSQL for instructions on how to install BendSQL using various package managers.
• Ensure that you already have a Databend Cloud account and can log in successfully.

2

Obtain Connection Information

1. Log in to Databend Cloud, and then click Connect.

2. Select the database you want to connect to, for example, "default"; then choose a warehouse. If you forget the password, reset it.

3. You can find the DSN details for the current warehouse and the connection string used to connect to Databend Cloud via BendSQL in the Examples section. For this step, simply copy the content provided in the BendSQL tab.

3

Launch BendSQL

To launch BendSQL, paste the content you copied into your terminal or command prompt. If the password you copied displays as "**", replace them with your actual password.

4

Execute Queries

Once connected, you can execute SQL queries in the BendSQL shell. For instance, type SELECT NOW(); to return the current time.

5

Quit BendSQL

To quit BendSQL, type quit.