Can Jetbrains Datagrip connect to Fabric lakehouse?

[anhngv]

First, I don't know where should this topic be put and I hope anyone here knows the answer.

As stated in the subject, I have a Lakehouse in a Fabric Workspace. The lakehouse has its own SQL connection string (xxx.datawarehouse.pbidedicated.windows.net). I am using Datagrip to manage all my project data sources.

And my question is, is there any way that I can connect the Fabric Lakehouse to the Datagrip?

What I have tried:

- I have put the SQL connection string to Host, Port is default 1433

- For authentication, I have selected User & Password which I have filled my Fabric User/password

- And then I got this error. I have checked my login and I still can log my account into Fabric service

Hope to hear from you soon.

[DürsinKurt]

whe have the same 'database_principal_id' is not supported Message. It seems to be allready reported for about an year to DataGrip.

Actually it is marked as resolved since 11 Days and will be released with Build 2024.02:

https://youtrack.jetbrains.com/issue/DBE-17970/FUNCTION-databaseprincipalid-is-not-supported-in-Azur...

[jragan]

Note here - in the Advanced settings area for the azure sql connection in DataGrip, the hostNameInCertificate is hardcoded to the default for azure sql which is INCORRECT for fabric - the value needs to be changed to *.datawarehouse.fabric.microsoft.com

[anhngv]

It turned out that we still be able to connect the database but no schemas or tables shown.

We still may do SQL queries but just not any support from IDE. It's just like free text.

[JPuris]

I'm facing the same exact issue 😞

It is able to connect via Azure SQL Server connection type as described above, but you will get the error

FUNCTION 'database_principal_id' is not supported.

This issue also causes the interspection to fail, which consequently eliminates any intelliSense 😞

It is not able to connect to the Lakehouse SQL endpoint at all, if choosing the Azure Synapse Analytics database type.

[TomMartens]

Hey @anhngv ,

I just installed Datagrip on my Macbook Pro (Apple Silicon - M2)

I used the connection string from the SQL Analytics Endpoint of an existing lakehouse:

Then, in Datagrip I configure a data source like this, please be aware that I use the driver of an Azure SQL Database type:

With these settings I'm able to connect to the SQL Analytics Endpoint of a lakehouse and query the data.

Please be aware that I'm not a DataGrip expert, but from my perspective I looks like as DataGrip is able to to connect to the SQL Analytics Endpoint of a Microsoft Fabric's lakehouse.

Hopefully, this helps to tackle your challenge.

Regards,

Tom

[anhngv]

I'm using Datagrip in Windows 10. I followed your steps, it did something but still did not get connected.

1, This is my setting, it popped up a log-in screen of Microsoft, then I completed the Authentication. When I clicked on Test Connection, it showed Succeeded 

2, But when I clicked OK to load the database, it showed Error below

It gets closer 😄

[TomMartens]

Hey @anhngv ,

try to use the interactive authentication mode.

Regards,

Tom

[anhngv]

I tried Interactive then I received the new error