PyCharm
 
Get PyCharm

Data loaders

Last modified: 22 November 2024

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 settings page  CtrlAlt0S, 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

    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 Project 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.