## 模块 3：向 TiDB Dedicated 导入数据

在本模块中，我们通过 UI 向 TiDB Cloud Dedicated 导入一些示例数据。使用的示例数据是来自 Capital Bikeshare 的系统数据，根据 Capital Bikeshare 数据许可协议发布。

### 步骤 1. 打开导入面板

+ 点击右上角的 `...`。

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

+ 选择 `Import data from Cloud Storage`。

### 步骤 2. 配置数据源

+ 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)

### 步骤 4. 导入数据

+ 点击 `Connect` > `Start Import`。

### 步骤 5. 检查导入的数据

+ 前往 [Terminal 1](ssh://monitor1-ssh#1)，检查导入的数据

  ```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)
  ```