Data loaders
This functionality relies on the Database Tools and SQL plugin, which is bundled and enabled in PyCharm by default. If the relevant features are not available, make sure that you did not disable the plugin.
note
The Database Tools and SQL plugin is available only in PyCharm Professional.
Press CtrlAlt0S to open settings and then select Plugins.
Open the Installed tab, find the Database Tools and SQL plugin, and select the checkbox next to the plugin name.
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:
Excel
JSON
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 Source settingsMapping settingsFor 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
You can also create and use your own scripted data loader that you can write on Groovy or JavaScript.
The supported file formats are as follows:
Script | File format |
---|---|
Excel | .xlsx, .xls |
JSON | .json |
Parquet | .parquet |
Shapefile | .shp |
Thanks for your feedback!