Connect to Spark Warehouse through DataGrip
- In DataGrip click on
Add Datasourceand choose
Apache Sparkfrom dropdown. It should be under the Others section
- If you will see the
Download missing driversbutton below, install them first.
- After downloading the required drivers, insert your JDBC connection URL to
You can find the warehouse's JDBC URL on the warehouse's detail page under the JDBC tab
Copy JDBC URL from Connection details
- Then type in your iomete user and password into corresponding fields
- Optionally you can specify the schema (database)
Please take into consideration that Test Connection could take couple of minutes if your lakehouse driver is suspended. It takes usually 1-2 minutes to scale up. After that you should be able to Connect to your Lakehouse through JDBC.
Updated 2 months ago