DataGrip 2024.2 Help

Data loaders

Data loaders are specialized scripts that allow you to import your tabular data files into a database. They also enable the visual representation of this data in the data editor. The view of such files in the data editor is read-only.

  • Data display in data editor. For example:

    1. Excel

      Contents of an Excel file are displayed in the data editor
    2. JSON

      Contents of a JSON file are displayed in the data editor

      To disable the Data tab with table view for JSON files, in the Advanced Settings page of settings  Ctrl+Alt+S, set the Open file as table if detected by scripted loader to Table-first formats.

    For more information about viewing data in data editor, refer to Data editor and viewer.

  • Data import from a file to a database

    Import tabular data file: Tabular data Source settings
    Import tabular data file: mapping settings

    For more information about importing data from a tabular data file to a database, refer to Import data from tabular data files.

To locate data loaders, open the Files tool window and navigate to Scratches and Consoles | Extensions | Database Tools and SQL | data | loaders.

You can also create and use your own scripted data loader that you can write on Groovy or JavaScript.

Supported file formats

The supported file formats are as follows:

Script

File format

Excel

.xlsx, .xls

JSON

.json

Parquet

.parquet

Shapefile

.shp

Last modified: 18 July 2024