Big Data Tools
The Big Data Tools plugin is available for DataGrip 2020.1 and later. It provides specific capabilities to monitor and process data with Zeppelin, AWS S3, Apache Spark, Apache Kafka, Apache Hive, Apache Flink, Google Cloud Storage, MinIO, Linode, DigitalOcean Spaces, Microsoft Azure, and Hadoop Distributed File System (HDFS).
Install the Big Data Tools plugin
This functionality relies on the Big Data Tools plugin, which you need to install and enable.
Press Ctrl+Alt+S to open the IDE settings and select.
Open the Marketplace tab, find the Big Data Tools plugin, and click Install (restart the IDE if prompted).
You can create new or edit existing local or remote Zeppelin notebooks, execute code paragraphs, preview the resulting tables and graphs, and export the results to various formats.
Getting started with Big Data Tools in DataGrip
The basic workflow for big data processing in DataGrip includes the following steps:
Configure your environment
Install the Big Data Tools plugin.
Create a new project in DataGrip.
Configure a connection to the target server.
Work with your notebooks and data files.
Work with notebooks
Execute the notebook.
Get familiar with the user interface
When you install the Big Data Tools plugin for DataGrip, the following user interface elements appear:
Big Data Tools window
The Big Data Tools window appears in the rightmost group of the tool windows. The window displays the list of the configured servers and files structured by folders. Even when no connections are configured, you can see the available types of servers to connect to.
Basic operations on notebooks are available from the context menu.
You can navigate through the directories and preview columnar structures of .csv, .parquet, .avro, and .orc files.
Basic operations on data files are available from the context menu. You can also move files by dragging them to the target directory on the target server.
For the basic operations with the servers, use the window toolbar:
Add a new connection to a server.
Delete the selected connection.
For Zeppelin: find a note in your Zeppelin server.
For storages: navigate to a file.
Refresh connections to all configured servers.
Open the connection settings for the selected server.
Only for storages. Open the storage in a separate tab of your editor
If you have any questions regarding the Big Data Tools plugin, click the Support link and select one of the available options. You can join the support Slack channel, submit a ticket in the YouTrack system, or copy the support email to send your question.
In the notebook editor, you can add and execute SQL code paragraphs. When editing your code paragraph, you can use all the coding assistance features available for a particular language. Code warnings and errors will be highlighted in the corresponding code constructs in the scrollbar. The results of paragraph execution are shown in the preview area below each paragraph.
Use the notebook editor toolbar for the basic operations with notebooks:
Executes all paragraphs in the notebook.
Stops execution of the notebook paragraphs.
Clears output previews for all paragraphs.
Select Export Note Code to HTML to save the note as an HTML file. Select Alter Code Visibility to hide code sections in paragraphs (by default, both code and result sections are shown). Select Show State Viewer Window to open State Viewer.
Opens the Interpreter Bindings dialog to configure interpreters for the selected notebook.
Click this button to open the notebook in the browser or copy a link to it.
Allows you to jump to a particular paragraph of a notebook.
Shows the minimap for quick navigation through the notebook.
A toolbar of a local note contains a list of available Zeppelin servers, so that you can select one to execute the note.
The notebook editor toolbar also shows the status of the last paragraph execution: Finished, Aborted, or Failed and the synchronization status of State Viewer.
Monitoring tool windows
These windows appear when you have connected to a Spark or Hadoop server.