DataGrip 2023.1 Help

Amazon EMR

The Big Data Tools plugin let you monitor clusters and nodes in the Amazon EMR data processing platform.

Connect to an AWS EMR server

  1. In the Big Data Tools window, click Add a connection and select AWS EMR.

  2. In the Big Data Tools dialog that opens, specify the connection parameters:

    Configure AWS EMR connection
    • Name: the name of the connection to distinguish it between the other connections.

    • Region: select a region to get clusters from.

    • Authentication type lets you select the authentication method:

      • Default credential providers chain: use the credentials from the default provider chain. For more info on the chain, refer to Using the Default Credential Provider Chain.

      • Explicit access key and secret key: enter your credentials manually.

      • Profile from credentials file: select a profile from your credentials file. You can also select Use custom configs to use a profile file and credentials file from another directory.

    With the Default credential providers chain or Profile from credentials file option selected, you can click Open Credentials to locate the directory where the credential file is stored. If you use the default location, it's usually ~/.aws/credentials on Linux or macOS, or C:\Users\<USERNAME>\.aws\credentials on Windows. Or it can be your custom location if you have selected Use custom configs.

    Optionally, you can set up:

    • Per project: select to enable these connection settings only for the current project. Deselect it if you want this connection to be visible in other projects.

    • Enable connection: deselect if you want to restrict using this connection. By default, the newly created connections are enabled.

    • HTTP Proxy: select if you want to use IDE proxy settings or if you want to specify custom proxy settings.

    • Click the Open SSH Key Settings link to create an SSH connection authenticated with a private key file. You need to specify the Amazon EC2 key pair private key in the EMR SSH Keystore dialog.

  3. Once you fill in the settings, click Test connection to ensure that all configuration parameters are correct. Then click OK.

At any time, you can open the connection settings in one of the following ways:

  • Go to the Tools | Big Data Tools Settings page of the IDE settings Control+Alt+S.

  • Click settings on the AWS EMR tool window toolbar.

Once you have established a connection to the server, the AWS EMR tool window appears.

The window consists of the several areas to monitor clusters:

Cluster info

This tab shows details about the selected cluster. You can start typing any parameter name in the Search field and it will be highlighted in the list of parameters.

Obtain more info

  • You can preview the cluster details in the web interface. Click Browse the cluster details or the Open Subnet, Muster Security Group, or Core and Tasks Security Group.

  • Click Open an SFTP connection to establish an SFTP connection to the target server, then specify the path to the config file in your file system.

  • You can preview EMR logs for the selected cluster. Click Open EMR logs to open the logs in the Big Data Tools tool window.

    EMR logs in the Big Data Tools window
  • For JSON representation of the selected cluster configuration, click View JSON representation.

Cluster steps

This tab shows application steps, their IDs, and execution status. You can start typing any ID or name in the Search field and it will be selected in the list of steps.

Manage steps

  • Click Browse the step details to preview the application step in the web interface.

  • You can add more steps of different types. Click More steps and select a step type to add. Then, specify its parameters.

    Add an application to Steps
  • Click Clone a step to duplicate the selected step.

  • For JSON representation of the selected cluster configuration, click View JSON representation.

Cluster instances

This tab shows details about instances of the selected cluster. You can start typing any instance name in the Search field and it will be selected.

View instances

  • You can preview the instance details in the web interface by clicking Browse the cluster details. You can also click Manage
                  visibility of instance parameters to show or hide a particular parameter of instances.

  • Click Open an SFTP connection to establish an SFTP connection to the target server, then specify the path to the config file in your file system.

  • For JSON representation of the selected cluster configuration, click View JSON representation.

Cluster applications

This tab shows applications running on the selected cluster. Click Browse the application details to preview the cluster details in your default web browser.

Open Amazon EMR applications

DataGrip lets you open applications installed on your Amazon EMR cluster. You can open it in your default browser right from the AWS EMR tool window. Additionally, if a tool is supported by the Big Data Tools plugin (such as Hadoop, HDFS, Hive, Spark, or Zeppelin), you can create a connection to it in DataGrip so that a dedicated tool window or tab appears in your IDE. For example, if you connect to a Zeppelin server, you can open and edit a Zeppelin note in the DataGrip editor. Connections to applications are based on SSH tunneling, so you'll have to provide SSH keys configured in the cluster.

  1. In the AWS EMR tool window, select your Amazon EMR cluster.

  2. Open the Applications tab and, in the Name column, click the link to an application.

  3. For applications that are supported by the Big Data Tools plugin, select where to open it:

    • Open in Browser to open it in your default browser.

    • Create Connection to create a connection to the application within your IDE. A new connection will be displayed in the Big Data Tools tool window.

  4. If this is the first time you try to connect to an application, you will be prompted to create a connection. Click Create and in the dialog that opens select your SSH key file, for example mykey.pem.

    Once your SSH keys are loaded, you can connect to applications of this cluster just by clicking its name in the Applications tab.

  5. In the Create Connection window that opens, select one of the following:

    • Use Defaults if you want to initiate a connection right away using the default settings.

    • Customize if you want to change some settings before connecting, for example, provide your Zeppelin user name and password.

Last modified: 21 June 2023