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

     

  2. JSON

     

     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

  

  

  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.