## Module 3: Importing data into TiDB Dedicated

In this module, we import some sample data into TiDB Cloud Dedicated via UI. The sample data used is the system data from Capital Bikeshare, released under the Capital Bikeshare Data License Agreement.

### Step 1. Open the Import panel

+ Click `...` on the upper-right corner.

  ![80%](https://lab-static.pingcap.com/images/2025/7/24/a1916e0d5c17e5af89e7dab79992a8b9956c0ef3.png)

+ Select `Import data from Cloud Storage`.

### Step 2. Configure the data source

+ Included Schema Files: `Yes`
+ Data Format: `SQL`
+ Folder URI: `s3://tidbcloud-sample-data/data-ingestion/`
+ Bucket Access: `AWS Role ARN`
+ AWS Role ARN: `arn:aws:iam::801626783489:role/import-sample-access`

  ![80%](https://lab-static.pingcap.com/images/2025/7/24/ac300adbcc6bd19f3fff2ea3ab1782d8872a414b.png)

### Step 4. Import the data

+ Click `Connect` > `Start Import`.

### Step 5. Check the imported data

+ Go to [Terminal 1](ssh://monitor1-ssh#1), and check the imported data

  ```sql
  USE bikeshare;
  SELECT ride_id, rideable_type, started_at, ended_at FROM `trips` WHERE start_station_name='12th & U St NW' limit 3;
  ```

  ```output
  MySQL [bikeshare]> SELECT ride_id, rideable_type, started_at, ended_at FROM `trips` WHERE start_station_name='12th & U St NW' limit 3;
  +------------------+---------------+---------------------+---------------------+
  | ride_id          | rideable_type | started_at          | ended_at            |
  +------------------+---------------+---------------------+---------------------+
  | 000B23FFC23B5FC8 | classic_bike  | 2020-12-22 12:33:12 | 2020-12-22 12:41:59 |
  | 0023EE3F7FA273AA | docked_bike   | 2020-12-31 11:02:14 | 2020-12-31 12:21:51 |
  | 0025068889EA0F45 | docked_bike   | 2020-11-19 14:45:34 | 2020-11-19 14:51:37 |
  +------------------+---------------+---------------------+---------------------+
  3 rows in set (0.004 sec)
  ```