Skip to main content

DataGrip

You can run SQL from DataGrip to explore your data through morse brain

Supported Versions​

Morse brain connectivity is supported from DataGrip running on Windows, macOS, or Linux. It is recommended that you use the latest available version of DataGrip

Supported Authentication Methods​

You can authenticate your connection to morse brain using your morse brain username and password.

Prerequisites​

Download the JDBC Driver for Apache Arrow Flight SQL.

Connecting to Morse Brain​

Follow the steps below to connect to morse brain:

  1. Create a project in DataGrip (see Quick start with DataGrip for more information).

  2. Open the Database Explorer, click the + icon, then click Driver and Data Source. Add Driver and Data Source

  3. Select the Drivers tab, then click + to add a new driver.

  4. Fill in the following details for the new driver:

  • Name: Provide a name to identify the driver in DataGrip (e.g., Arrow Flight SQL 10).

  • Driver Files: Click +, click Custom JARs…, then select the Arrow Flight SQL driver (flight-sql-jdbc-driver-10.0.0.jar) from the location where you downloaded it.

  • Class: org.apache.arrow.driver.jdbc.ArrowFlightJdbcDriver

  1. At the bottom of the Data Sources and Drivers panel, click Create Data Source.

  2. Ensure that the driver you just created is selected under Project Data Sources.

  3. For Authentication, select User & Password, and provide the Dremio username and password to send for authentication.

  4. For URL, follow the guidance under Connecting to Databases.

The following is an example URL for a local Dremio installation that does not use an encrypted flight port:

Example Flight SQL URL jdbc:arrow-flight-sql://localhost:32010?useEncryption=false

  1. Click Test Connection to confirm a valid connection to Dremio.

  2. Click OK to save driver and data source.

  3. Run a simple query to see how results are displayed in DataGrip. Run a Query

tip

NOTE When querying tables and views in Dremio, ensure you are using the fully qualified path. For example, SELECT * FROM Samples."samples.dremio.com"."NYC-taxi-trips".

Previous IBM Cognos Analytics