# Import

Procedure: Enable the Database Tools and SQL plugin

This functionality relies on the  Database Tools and SQL plugin, which  is bundled and enabled in IntelliJ IDEA   by default. If the relevant features are not available, make sure that you did not disable the plugin.

> **Note:**
> Database Tools and SQL functionality support is limited in IntelliJ IDEA without the Ultimate subscription.

1. Press `Ctrl+Alt+S` (Windows), `⌘ Comma` (macOS), `⌘ Comma` (IntelliJ IDEA Classic (macOS)), `⌘ Comma` (macOS System Shortcuts), `Ctrl+Alt+S` (XWin), `Ctrl+Alt+S` (GNOME), `Ctrl+Alt+S` (KDE), `Ctrl+Alt+S` (Emacs), `Ctrl+Alt+S` (Sublime Text), `⌘ Comma` (Sublime Text (macOS)), `Ctrl+Alt+S` (NetBeans), `Ctrl+Alt+S` (Visual Studio), `⌘ Comma` (Visual Studio (macOS)), `Ctrl+Alt+S` (Eclipse), `⌘ Comma` (Eclipse (macOS)) to open settings and then select `Plugins`.

2. Open the Installed tab, find the Database Tools and SQL plugin, and select the checkbox next to the plugin name.

To import data from a script file, run the file as it is described in the [Run SQL files](run-sql-files.html) page. In addition to script files, you can import data from a CSV, TSV, or any other text files that contain delimiter-separated values.

> **Tip:**
> To learn how to share data sources, refer to [Share data sources between IDE instances](managing-data-sources.html#share-data-sources-between-different-ide-instances).

Procedure: Import data

1. In the   Database   tool window ,  right-click a data source, or a schema and select `SQL Scripts | Run SQL Script…`.

![Run an SQL file from the Database tool window](https://resources.jetbrains.com.cn/help/img/idea/2026.2/run_sql_file_from_database_tool_window.png)

2. In the file browser window that opens, navigate to the SQL file that you want to run .

3. Click Open.

You can view the output in the Run tool window.   For more information about tool window controls, refer to  [Run tool window](run-tool-window.html).

> **Tip:**
> To see other options of how you can run an SQL file against a database, refer to [Run SQL files](run-sql-files.html).

Procedure: Import data from CSV files

IntelliJ IDEA uses data extractors to import data from CSV files.  For more information about data extractors, refer to   the [Data extractors](data-extractors.html) topic.

1. In the   Database   tool window ,  right-click a schema or a table and select `Import/Export | Import Data from File(s)`.

2. Navigate to the CSV files and select them.

3. In the mapping tree of Import dialog, select the mapping node (![the Mapping icon](https://resources.jetbrains.com.cn/help/img/idea/2026.2/database-plugin.icons.expui.synonym.svg)) and specify the data conversion settings.

You can select in which schema to create a table and whether to import data to a new table or an existing one. To select a schema or a table, use Schema and Table fields.

4. In the mapping tree, select the source file to configure its settings. To mark the first row as a header, select First row is header.

5. Apply the changes and close the dialog.

Mapping settings:

![Import DSV file: mapping settings](https://resources.jetbrains.com.cn/help/img/idea/2026.2/db_import_csv_mapping.png)

CSV Source settings:

![Import DSV file: CSV Source settings](https://resources.jetbrains.com.cn/help/img/idea/2026.2/db_import_csv_source.png)

Procedure: Import data from tabular data files

IntelliJ IDEA uses scripted data loaders to import data from tabular data files.   For more information about scripted data loaders, refer to  the [Data loaders](data-loaders.html) topic.

1. In the   Database   tool window ,  right-click a schema or a table and select `Import/Export | Import Data from File(s)`.

2. Navigate to the tabular data files and select them.

3. In the mapping tree of Import dialog, select the mapping node (![the Mapping icon](https://resources.jetbrains.com.cn/help/img/idea/2026.2/database-plugin.icons.expui.synonym.svg)) and specify the data conversion settings.

You can select in which schema to create a table and whether to import data to a new table or an existing one. To select a schema or a table, use Schema and Table fields.

4. In the mapping tree, select the source file to configure its settings. To mark the first row as a header, select First row is header.

5. Apply the changes and close the dialog.

Mapping settings:

![Import tabular data file: mapping settings](https://resources.jetbrains.com.cn/help/img/idea/2026.2/db_import_tabular_data_format_mapping.png)

Tabular data file Source settings:

![Import tabular data file: Tabular data Source settings](https://resources.jetbrains.com.cn/help/img/idea/2026.2/db_import_tabular_data_format_source.png)

> **Note:**
> If you drag a file into a schema or carry out the Import Data from File(s) command for a schema, IntelliJ IDEA creates a new table for the data that you import. If you perform the same actions for an existing table, IntelliJ IDEA adds the data to that table.

Procedure: Import tables

1. Select the tables that you want to copy to a different schema, database, or existing table.

2. Open the Import dialog. To do that, you can use the following actions:

* Right-click the selection and navigate to `Import/Export | Copy Tables to`.

* Drag the selection to a schema or a database.

* Press `Ctrl+Shift+A` (Windows), `⌘ ⇧ A` (macOS), `⌘ ⇧ A` (IntelliJ IDEA Classic (macOS)), `⌘ ⇧ P` (macOS System Shortcuts), `Ctrl+Shift+A` (XWin), `Ctrl+Shift+A` (GNOME), `Ctrl+Shift+A` (KDE), `Escape, X` (Emacs), `Ctrl+Shift+P` (Sublime Text), `⌘ ⇧ P` (Sublime Text (macOS)), `Ctrl+I` (NetBeans), `Ctrl+Shift+A` (Visual Studio), `⌘ ⇧ A` (Visual Studio (macOS)), `Ctrl+Shift+A` (Eclipse), `⌘ 3` (Eclipse (macOS)), type `copy tables to` and press `Enter` (Windows), `⏎` (macOS), `⏎` (IntelliJ IDEA Classic (macOS)), `⏎` (macOS System Shortcuts), `Enter` (XWin), `Enter` (GNOME), `Enter` (KDE), `Enter` (Emacs), `Enter` (Sublime Text), `⏎` (Sublime Text (macOS)), `Enter` (NetBeans), `Enter` (Visual Studio), `⏎` (Visual Studio (macOS)), `Enter` (Eclipse), `⏎` (Eclipse (macOS)).

3. In the mapping tree of Import dialog, select the mapping node (![the Mapping icon](https://resources.jetbrains.com.cn/help/img/idea/2026.2/database-plugin.icons.expui.synonym.svg)) and specify the data conversion settings.

You can select in which schema to create a table and whether to import data to a new table or an existing one. To select a schema or a table, use Schema and Table fields.

4. In the mapping tree, select the source file to configure its settings.

5. (Optional) Select Insert inconvertible values as null if you want to insert NULL when the IDE meets an inconvertible value.

6. Apply the changes and close the dialog.

Mapping settings:

![Import tables: mapping settings](https://resources.jetbrains.com.cn/help/img/idea/2026.2/db_import_table_mapping.png)

Table Source settings:

![Import tables: table source settings](https://resources.jetbrains.com.cn/help/img/idea/2026.2/db_import_table_source.png)

Procedure: Restore Microsoft SQL Server table data

You can restore a Microsoft SQL Server table data by using the bcp utility. The tool is not integrated into IntelliJ IDEA. You can read about it at [learn.microsoft.com](https://learn.microsoft.com/en-us/sql/tools/bcp-utility?view=sql-server-ver16).

1. In the   Database   tool window ,  right-click the table that you want to import your data to and select `Import/Export | Restore with 'bcp'`.

2. In the Restore with bcp (<data_source_name>) dialog, specify the path to the bcp executable in the Path to bcp field.

> **Note:**
> Specify the full explicit path to the dump tool executable.

3. In the Source file , specify the path to the file that you want to restore the data from.

4. Click Run.

![Restore a Microsoft SQL Server table data using bcp](https://resources.jetbrains.com.cn/help/img/idea/2026.2/db_restore_ms_sql_server_table_data.png)

## Restore a full data dump for MySQL and PostgreSQL

You can restore data dumps by using the `mysql` client utility for MySQL, or [pg_restore](https://www.postgresql.org/docs/current/app-pgrestore.html) or [psql](https://www.postgresql.org/docs/current/backup-dump.html) for PostgreSQL. The pg_restore option is used for custom-format `pg_dump -Fc` or directory-format `pg_dump -Fd` dumps. The psql option is used for SQL-format dumps.

If you see no restore options in the context menu, verify that you use a correct JDBC URL for the data source.

Procedure: Restore data with mysql or pg_restore

1. In the   Database   tool window ,  right-click a schema or a database and navigate to the Import/Export group:

* Restore with 'mysql': for MySQL data sources. In the Path to executable field, specify the path to the mysql executable (for example, `C:\Soft\mysql-8.0.19-winx64\bin\mysql.exe`).

* Restore with 'pg_restore': for PostgreSQL data sources. The pg_restore option is available for the most database objects except for the data source level.

* Restore with 'psql': for PostgreSQL data sources. The psql option is available for data sources.

* Restore with 'pg_restore'/'psql': for PostgreSQL data sources. Includes two tabs: pg_restore and psql. The option is available for databases.

2. In the Restore with <dump_tool> dialog, specify the path to the restore tool executable in the Path to executable field.

> **Note:**
> Specify the full explicit path to the dump tool executable.

(Optional) Edit the command-line options in the lower part of the dialog.

3. Click Run.

![Restore a full data dump with pg_restore](https://resources.jetbrains.com.cn/help/img/idea/2026.2/db_restore_full_dump_with_pg_restore.png)

> **Tip:**
> For PostgreSQL, you can use Restore with "pg_restore" on a table level.

### 'Restore with' dialogs reference

mysql:

![the Restore with mysql dialog](https://resources.jetbrains.com.cn/help/img/idea/2026.2/db_restore_with_mysql.png)

| Item | Description |
| --- | --- |
| Where to run |    Sets where to run the tool. You can either run it locally or in a Docker container.       1.    Locally       * Path to executable: Defines the path to the mysql executable on your machine.       2.    In a Docker container     > **Note:** > This functionality relies on the [Docker](https://plugins.jetbrains.com/plugin/7724-docker)  plugin, which  is bundled and enabled in IntelliJ IDEA   by default. If the relevant features are not available, make sure that you did not disable the plugin.    For more information, refer to [Open plugin settings](managing-plugins.html#open-plugin-settings).       * Server: Sets the server used to run the container.    * Container: Sets the container to run the mysql executable in.    * Path to executable: Defines the path to the mysql executable inside the container. > **Tip:** > If you use the IDE [Docker](https://plugins.jetbrains.com/plugin/7724-docker) plugin, type path to the mysql executable inside the container (for example, `/usr/bin/mysqldump`).    * Path to dump (in container): Defines the path to the dump file inside the container.       |
|    Options    |
| Database |    `--database`     Name of the database to connect to.    |
| Path to dump |    Defines the path to the dump file on your machine.    |

pg_restore:

![the Restore with pg_restore dialog](https://resources.jetbrains.com.cn/help/img/idea/2026.2/db_restore_with_pg_restore.png)

> **Tip:**
> Hover over the export option to see the command line arguments in a tooltip.

| Item | Description |
| --- | --- |
| Where to run |    Sets where to run the tool. You can either run it locally or in a Docker container.       1.    Locally       * Path to executable: Defines the path to the pg_restore executable on your machine.       2.    In a Docker container     > **Note:** > This functionality relies on the [Docker](https://plugins.jetbrains.com/plugin/7724-docker)  plugin, which  is bundled and enabled in IntelliJ IDEA   by default. If the relevant features are not available, make sure that you did not disable the plugin.    For more information, refer to [Open plugin settings](managing-plugins.html#open-plugin-settings).       * Server: Sets the server used to run the container.    * Container: Sets the container to run the pg_restore executable in.    * Path to executable: Defines the path to the pg_restore executable inside the container. > **Tip:** > If you use the IDE [Docker](https://plugins.jetbrains.com/plugin/7724-docker) plugin, type path to the pg_restore executable inside the container (for example, `/usr/bin/mysqldump`).    * Path to dump (in container): Defines the path to the dump file inside the container.       |
|    Options    |
| Database |    `--dbname`      Connect to the specified database and restore directly into it.     |
| Schemas |    `--schema`      Restore only objects that are in the specified schema.    |
| Tables to dump |    `--table`      Restore only the specified tables.    |
| Format |    `--format`     Format of the output:       * Auto: pg_restore determines the format automatically.    * Directory: `--format=d`. Directory-format archive.    * Custom-format archive: `--format=c`. The pg_dump custom-format archive.    * Tar archive: `--format=t`. Tar-format archive.    |
| Path to dump |     Defines the path to the dump file on your machine.     |
| Clean database |    `--clean`, `-c`      Drops all the database objects that will be restored before restoring them.    |
| Add "IF EXISTS" |    `--if-exists`      Uses `DROP ... IF EXISTS` to drop objects when Clean database is enabled.     |
| Create database |    `--create`, `-C`      Creates a new database first and then  restores into it. If Clean database is enabled, drops and recreates the target database before  connecting to it.     |
| Data only |    `--data-only`, `-a`       Restores only the data, not the schema.     |
| Single transaction |    `--single-transaction`, `-1`      Performs the restore within a single transaction by wrapping it in `BEGIN` and `COMMIT`.      |

For more information about export options, refer to  the [pg_restore documentation](https://www.postgresql.org/docs/current/app-pgrestore.html).

psql:

![the Restore with psql dialog](https://resources.jetbrains.com.cn/help/img/idea/2026.2/db_restore_with_psql.png)

> **Tip:**
> Hover over the export option to see the command line arguments in a tooltip.

| Item | Description |
| --- | --- |
| Where to run |    Sets where to run the tool. You can either run it locally or in a Docker container.       1.    Locally       * Path to executable: Defines the path to the psql executable on your machine.    * Output result to: Defines the path to the output result on your local machine.       2.    In a Docker container     > **Note:** > This functionality relies on the [Docker](https://plugins.jetbrains.com/plugin/7724-docker)  plugin, which  is bundled and enabled in IntelliJ IDEA   by default. If the relevant features are not available, make sure that you did not disable the plugin.    For more information, refer to [Open plugin settings](managing-plugins.html#open-plugin-settings).       * Server: Sets the server used to run the container.    * Container: Sets the container to run the psql executable in.    * Path to executable: Defines the path to the psql executable inside the container. > **Tip:** > If you use the IDE [Docker](https://plugins.jetbrains.com/plugin/7724-docker) plugin, type path to the psql executable inside the container (for example, `/usr/bin/mysqldump`).       |
|    Options    |
| Database |    `--dbname`      Connect to the specified database and restore directly into it.     [psql documentation.](https://www.postgresql.org/docs/17/app-psql.html#APP-PSQL-OPTION-DBNAME)    |
| Path to dump |    `--file`     Defines the path to the dump file on your machine.     [psql documentation.](https://www.postgresql.org/docs/17/app-psql.html#APP-PSQL-OPTION-FILE)    |
| Single transaction |    `--single-transaction`, `-1`      Performs the restore within a single transaction by wrapping it in `BEGIN` and `COMMIT`.      [psql documentation.](https://www.postgresql.org/docs/17/app-psql.html#APP-PSQL-OPTION-SINGLE-TRANSACTION)    |

For more information about export options, refer to  the [psql documentation](https://www.postgresql.org/docs/17/app-psql.html).

## Import dialog

The Import dialog appears when you import [a file](#intro_csv), [a table](#intro_table), or [a query result set](#intro_query) into your database.

In the mapping tree that is in the upper-left pane of this dialog, you can create file-to-table, table-to-table, and query-to-table mappings (![the Mapping icon](https://resources.jetbrains.com.cn/help/img/idea/2026.2/database-plugin.icons.expui.synonym.svg)). In the settings pane in the upper-right part of the dialog, configure mapping settings and change settings of the sources (CSV file, table, and query). The preview pane in the bottom part of the dialog displays generated previews of your data, of the source data with different source settings, and of DDL statements.

1. [Mapping tree.](#mapping_tree)

2. [Source settings.](#settings)

3. [Preview pane.](#preview)

CSV Source:

Tabular data file Source:

Table Source:

Query Source:

Mapping:

### Mapping tree

| Icon | Item | Shortcut | Description |
| --- | --- | --- | --- |
| ![the Add icon](https://resources.jetbrains.com.cn/help/img/idea/2026.2/app-client.expui.general.add.svg) | Add | `Alt+Insert` (Windows), `⌘ N` (macOS), `⌃ N` (IntelliJ IDEA Classic (macOS)), `⌘ N` (macOS System Shortcuts), `Alt+Insert` (XWin), `Alt+Insert` (GNOME), `Alt+Insert` (KDE), `Alt+Insert` (Emacs), `Ctrl+N` (Sublime Text), `⌘ N` (Sublime Text (macOS)), `Alt+Insert` (NetBeans), `Ctrl+N` (Visual Studio), `⌘ N` (Visual Studio (macOS)), `Alt+Insert` (Eclipse), `⌘ N` (Eclipse (macOS)) | Create a new object.   |
| ![the Remove icon](https://resources.jetbrains.com.cn/help/img/idea/2026.2/app-client.expui.general.remove.svg) | Remove | `Alt+Delete` (Windows), `⌘ ⌦` (macOS), `⌘ ⌦` (IntelliJ IDEA Classic (macOS)), `⌘ ⌦` (macOS System Shortcuts), `Alt+Delete` (XWin), `Alt+Delete` (GNOME), `Alt+Delete` (KDE), `Alt+Delete` (Emacs), `Alt+Delete` (Sublime Text), `⌘ ⌦` (Sublime Text (macOS)), `Alt+Delete` (NetBeans), `Ctrl+R, D` (Visual Studio), `⌘ R, D` (Visual Studio (macOS)), `Alt+Delete` (Eclipse), `Alt+Delete` (Eclipse (macOS)) | Delete the selected object. |
| ![the Edit icon](https://resources.jetbrains.com.cn/help/img/idea/2026.2/app-client.expui.general.edit.svg) | Edit | `F4` (Windows), `⌘ ↓` (macOS), `F4` (IntelliJ IDEA Classic (macOS)), `F4` (macOS System Shortcuts), `F4` (XWin), `F4` (GNOME), `F4` (KDE), `F4` (Emacs), `F4` (Sublime Text), `F4` (Sublime Text (macOS)), `F4` (NetBeans), `F4` (Visual Studio), `⌘ ↓` (Visual Studio (macOS)), `F12` (Eclipse), `F3` (Eclipse (macOS)) | Open selected object in the object editor. |
| ![the Edit On Selection icon](https://resources.jetbrains.com.cn/help/img/idea/2026.2/app-client.expui.general.autoscrollToSource.svg) | Edit On Selection |  | Toggle between opening the object in object editor on selection and by double-clicking it. |
| ![the Back icon](https://resources.jetbrains.com.cn/help/img/idea/2026.2/app-client.expui.general.left.svg) | Back | `Ctrl+Alt+Left` (Windows), `⌘ [` (macOS), `⌘ ⌥ ←` (IntelliJ IDEA Classic (macOS)), `⌘ [` (macOS System Shortcuts), `Ctrl+Alt+Left` (XWin), `Alt+Shift+Left` (GNOME), `Ctrl+Alt+Left` (KDE), `Ctrl+Alt+Left` (Emacs), `Alt+NumPad -` (Sublime Text), `⌃ NumPad -` (Sublime Text (macOS)), `Alt+Left` (NetBeans), `Ctrl+Minus` (Visual Studio), `⌘ Minus` (Visual Studio (macOS)), `Alt+Left` (Eclipse), `⌘ [` (Eclipse (macOS)) | Previous object. |
| ![the Forward icon](https://resources.jetbrains.com.cn/help/img/idea/2026.2/app-client.expui.general.right.svg) | Forward | `Ctrl+Alt+Right` (Windows), `⌘ ]` (macOS), `⌘ ⌥ →` (IntelliJ IDEA Classic (macOS)), `⌘ ]` (macOS System Shortcuts), `Ctrl+Alt+Right` (XWin), `Alt+Shift+Right` (GNOME), `Ctrl+Alt+Right` (KDE), `Ctrl+Alt+Right` (Emacs), `Alt+Shift+NumPad -` (Sublime Text), `⌃ ⇧ NumPad -` (Sublime Text (macOS)), `Alt+Right` (NetBeans), `Ctrl+Shift+Minus` (Visual Studio), `⌘ ⇧ Minus` (Visual Studio (macOS)), `Alt+Right` (Eclipse), `⌘ ]` (Eclipse (macOS)) | Next object. |

### Settings

CSV Source:

| Item | Description |
| --- | --- |
| Path | Defines the path to source file.   |
| Charset | Determines which charset is used to read the file.   |
| Format |    Determines which format to use to read the file.     Click ![](https://resources.jetbrains.com.cn/help/img/idea/2026.2/app-client.expui.general.edit.svg) to configure the CSV file format.    |
| First row is header | Treat the first row as a row that contains column names. |
| First column is header | Treat the first column as a column that contains row names. |
| Trim whitespaces |  Ignore or remove whitespace characters. If this checkbox is cleared, the whitespace characters are treated as parts of the corresponding values.  |
| Column | Source file column name.   |
| Type | Source file column data type.   |

Tabular data file Source:

| Item | Description |
| --- | --- |
| Path | Defines the path to source file.   |
| Loader | Determines which [scripted data loader](data-loaders.html) is used to import the file data.   |
| First row is header | Treat the first row as a row that contains column names. |
| Column | Source file column name.   |
| Type | Source file column data type.   |

Table Source:

| Item | Description |
| --- | --- |
| Table | Defines the source table. |

Query Source:

| Item | Description |
| --- | --- |
| Target | Defines the target object against which the query is run. |
| Query | Defines the source SQL query. |

Mapping:

| Item | Description |
| --- | --- |
| Schema |  Schema in which you want to create or to copy a table. You can select schemas in another data source.  |
|  Table |    Name of a new table or an existing table in case you want to add data to the existing table.       * Click ![](https://resources.jetbrains.com.cn/help/img/idea/2026.2/database-plugin.icons.expui.textAutoGenerate.svg) Auto Generate for the name to be generated automatically.    * If available, click ![](https://resources.jetbrains.com.cn/help/img/idea/2026.2/app-client.expui.general.edit.svg) to create a new table with the specified name in the same Import dialog. The table with its objects will appear in the mapping tree as a new node.    |
| Mapping |  ![the Add icon](https://resources.jetbrains.com.cn/help/img/idea/2026.2/app.expui.general.add.svg), ![the Remove icon](https://resources.jetbrains.com.cn/help/img/idea/2026.2/app.expui.general.remove.svg), ![the Up icon](https://resources.jetbrains.com.cn/help/img/idea/2026.2/app.expui.general.moveUp.svg), ![the Down icon](https://resources.jetbrains.com.cn/help/img/idea/2026.2/app.expui.general.moveDown.svg)  |  Use these buttons to add items, remove them, and move them up and down the list.  |
| Target Column | Column name in the target table. |
| Source Column | Column name in the source table. |
| Encoding: | Select the character encoding for your data in the source file. |
| Write errors to file: | Write errors that occur during the import in a text file. |
| Insert inconvertible values as null | Insert the `NULL` value into the table instead of the data that cannot be converted. |
| Disable indexes and triggers, lock table (may be faster) |  Disable indexes and triggers during the import. Note that if you selected this option, it might lead to a situation when a trigger does not fire and fails to pass its results. Though it might improve the performance of the importing process. The option is available only when the target table (to which you copy values) has indexes or triggers.  |

### Data Preview pane

CSV Source settings:

| Item | Description |
| --- | --- |
|    ![the Modify Source icon](https://resources.jetbrains.com.cn/help/img/idea/2026.2/app-client.expui.general.edit.svg) Modify Source     and     file: <file_name> format: <file_format>    | Opens the CSV Source section with source file settings.   |
| Data Preview | The generated preview of how the data is read using the configured settings. |

Tabular data file Source settings:

| Item | Description |
| --- | --- |
|    ![the Modify Source icon](https://resources.jetbrains.com.cn/help/img/idea/2026.2/app-client.expui.general.edit.svg) Modify Source    | Selects the source file path in the Path field.   |
|    ![the Reload Page icon](https://resources.jetbrains.com.cn/help/img/idea/2026.2/app-client.expui.general.refresh.svg) Reload Page    | Reloads the generated preview.   |
| Data Preview | The generated preview of how the data is read using the configured settings. |

Table Source:

| Item | Description |
| --- | --- |
|    ![the Reload Page icon](https://resources.jetbrains.com.cn/help/img/idea/2026.2/app-client.expui.general.refresh.svg) Reload Page    | Reloads the table preview.   |
|    ![the Modify Source icon](https://resources.jetbrains.com.cn/help/img/idea/2026.2/app-client.expui.general.edit.svg) Modify Source     and     table: <table_name>    | Opens the Table Source section with source table settings.   |
| Data Preview | The generated preview of how the data is read using the configured settings. |

Query Source:

| Item | Description |
| --- | --- |
|    ![the Reload Page icon](https://resources.jetbrains.com.cn/help/img/idea/2026.2/app-client.expui.general.refresh.svg) Reload Page    | Reloads the query result set.   |
|    ![the Modify Source icon](https://resources.jetbrains.com.cn/help/img/idea/2026.2/app-client.expui.general.edit.svg) Modify Source     and     table: <table_name>    | Opens the Query Source section with source query settings.   |
| Data Preview | The generated preview of how the data is read using the configured settings. |

Mapping:

| Item | Description |
| --- | --- |
| Data Preview | The generated preview of how your data will be imported to the database. |
| DDL Preview |  A statement or statements that IntelliJ IDEA will run to create a table. You can edit the statements in the DDL preview field.  |