TiDB Cloud Quick Start

Estimated completion time: 20 minutes

This tutorial guides you through an easy way to get started with your TiDB Cloud. The content includes how to create a cluster, connect to a cluster, import data, and run queries.

Step 1. Create a TiDB cluster

You can either create a free Developer Tier cluster or a Dedicated Tier.

• Developer Tier
• Dedicated Tier

Step 2. Connect to your TiDB cluster

1. Navigate to the Clusters page.

2. In the area of your newly created cluster, click Connect in the upper-right corner. A connection dialog box is displayed.

   Tip

   Alternatively, you can also click the name of your newly created cluster on the Clusters page and click Connect in the upper-right corner.

3. Under Step 2: Connect with a SQL client in the dialog box, click the tab of your preferred connection method, and then connect to your cluster with the connection string.

   Note

   • For Developer Tier clusters, when you connect to your cluster, you must include the prefix for your cluster in the user name and wrap the name with quotation marks. For more information, see User name prefix.
   • TiDB Cloud is MySQL-compatible, so you can connect to your cluster using any MySQL client tools. We recommend using mysql — The MySQL Command-Line Client or mysql — The MySQL Command-Line Client from MariaDB.

4. After logging into your TiDB cluster, you can use the following SQL statement to validate the connection:

   SELECT TiDB_version();
   

   If you see the release version information, you are ready to use your TiDB cluster.

Step 3. Import the sample data

We provide Capital Bikeshare sample data for you to easily import data and run sample queries.

1. Navigate to the Clusters page.

2. In the area of your newly created cluster, click Import Data in the upper-right corner. The Data Import Task page is displayed.

   Tip

   Alternatively, you can also click the name of your newly created cluster on the Clusters page and click Import Data in the upper-right corner.

3. Fill in the import parameters:

   • AWS
   • GCP

   If your TiDB cluster is hosted by AWS (the Developer Tier is hosted by AWS by default), fill in the following parameters:

   • Data Source Type: AWS S3.
   • Bucket URL: enter the sample data URL s3://tidbcloud-samples/data-ingestion/.
   • Data Format: select TiDB Dumpling.
   • Setup Credentials: enter arn:aws:iam::385595570414:role/import-sample-access for Role-ARN.
   • Target Cluster: fill in the Username and Password fields.
   • DB/Tables Filter: leave this field blank.

   If your TiDB cluster is hosted by GCP, fill in the following parameters:

   • Data Source Type: Google Cloud Stroage.
   • Bucket URL: enter the sample data URL gcs://tidbcloud-samples-us-west1.
   • Data Format: select TiDB Dumpling.
   • Target Cluster: fill in the Username and Password fields.
   • DB/Tables Filter: leave this field blank.

4. Click Import.

   A warning message about the database resource consumption is displayed. For a newly created cluster, you can ignore the warning message.

5. Click Confirm.

   TiDB Cloud starts validating whether it can access the sample data in the specified bucket URL. After the validation is completed and successful, the import task starts automatically.

The data import process will take 5 to 10 minutes. When the data import progress bar shows Success, you successfully import the sample data and the database schema in your database.

Step 4. Query data

When the process of importing data is completed, you can start to run some queries in your Terminal:

1. Use the bikeshare database and tables:

   USE bikeshare;
   SHOW tables;
   

2. Check the structure of the trip table:

   DESCRIBE trips;
   

3. Check how many records exist in the trips table:

   SELECT COUNT(*) FROM trips;
   

4. Check the entire trip history where the start station is "8th & D St NW":

   SELECT * FROM trips WHERE start_station_name = '8th & D St NW';
   

5. Show the least ten popular bicycle stations for picking up:

   SELECT start_station_name, COUNT(ride_id) as count from `trips`
   GROUP BY start_station_name
   ORDER BY count ASC
   LIMIT 10;