---
metadata:
  - name: generator
    content: Diplodoc Platform v5.50.6
alternate:
  - https://ydb.tech/docs/en/analyst/datasets.md?version=main
  - https://ydb.tech/docs/ru/analyst/datasets.md?version=main
sourcePath: en/core/analyst/datasets/index.md
---
> **Documentation Index:** Fetch the complete configuration index at https://ydb.tech/docs/en/llms.txt

# Overview

These pages describe popular datasets that you can load into YDB to familiarize yourself with the database's functionality and test various use cases.

## Prerequisites

To load the datasets, you will need:

1. Installed [YDB CLI](https://ydb.tech/docs/en/reference/ydb-cli/index.md?version=main)
2. [Optional] Configured [connection profile](https://ydb.tech/docs/en/reference/ydb-cli/profile/create.md?version=main) to YDB to avoid specifying connection parameters with every command

## General Information on Data Loading {#general-info}

YDB supports importing data from CSV files using the [command](https://ydb.tech/docs/en/reference/ydb-cli/export-import/import-file.md?version=main) `ydb import file csv`. Example command:

```bash
ydb import file csv --header --null-value "" --path <table_path> <file>.csv
```

Where:

* `--header` indicates that the first row of the file contains the column names, and the actual data starts from the second row;
* `--null-value ""` specifies that an empty string in the CSV will be interpreted as a null value during data import into the table.

A table must already exist in YDB for data import. The primary way to create a table is by executing the [`CREATE TABLE` YQL query](https://ydb.tech/docs/en/yql/reference/syntax/create_table/index.md?version=main). Instead of writing the query manually, you can try running the import command from a file, as shown in any example in this section, without creating the table first. In this case, the CLI will suggest a `CREATE TABLE` query, which you can use as a base, edit if necessary, and execute.

To import data into YDB, a table must be pre-created. Typically, a table is created using the [YQL `CREATE TABLE` query](https://ydb.tech/docs/en/yql/reference/syntax/create_table/index.md?version=main). However, instead of crafting such a query manually, you can initiate the import command `ydb import file csv` as shown in the import examples in this section. If the table doesn't exist, the CLI will automatically suggest a `CREATE TABLE` query that you can use to create the table.

{% note info "Selecting a Primary Key" %}

YDB requires a primary key for the table. It significantly speeds up data loading and processing, and it also allows for deduplication: rows with identical values in the primary key columns replace each other.

If the imported dataset doesn't have suitable columns for a primary key, we add a new column with row numbers and use it as the primary key, as each row number is unique within the file.

{% endnote %}

## Features and Limitations

When woimporting data to YDB, consider the following points:

1. **Column Names**: Column names should not contain spaces or special characters.

2. **Data Types**:
   - Date/time strings with timezone (e.g., "2019-11-01 00:00:00 UTC") will be imported as Text type.
   - The Bool type is not supported as a column type; use Text or Int64 instead.

## Available Datasets

* [Chess Position Evaluations](https://ydb.tech/docs/en/analyst/datasets/chess.md?version=main) - Stockfish engine chess position evaluations
* [Video Game Sales](https://ydb.tech/docs/en/analyst/datasets/video-games.md?version=main) - video game sales data
* [E-Commerce Behavior Data](https://ydb.tech/docs/en/analyst/datasets/ecommerce.md?version=main) - user behavior data from an online store
* [COVID-19 Open Research Dataset](https://ydb.tech/docs/en/analyst/datasets/covid.md?version=main) - open research dataset on COVID-19
* [Netflix Movies and TV Shows](https://ydb.tech/docs/en/analyst/datasets/netflix.md?version=main) - data on Netflix movies and shows
* [Animal Crossing New Horizons Catalog](https://ydb.tech/docs/en/analyst/datasets/animal-crossing.md?version=main) - item catalog from the game