"Unknown Error" when running simple select query in Lakebase SQL Editor

[Sbolo]

Hello! I am experiencing a confusing issue with LakeBase. I created a new project and I tried to run the example query provided in the SQL Editor to create a first table. Unfortunately, the query failed with "Unknown Error" and not further explanation. I then tried to simplify the query further to `SELECT  1`, obtaining the same result (see screenshot). My user has `Can Manage` permissions. I also noticed in the SQL editor that it says "Ready to Connect" in the bottom left corner, but the database claims to be active. I tried waiting around 30 minutes before different attempts at querying the database, and nothing changed.

Potentially related, I can see that, when I try to visualize the tables from the UI, I get the following error:

Server error (HTTP status 403): {"X-Databricks-Reason-Phrase":"Public access is not allowed for workspace: <id here>"}

Please let me know if you can pinpoint what can be going wrong here!

[szymon_dybczak]

Hi @Sbolo ,

Which Lakebase are you using? Provisioned or Autoscaling? 
And since you also got following error:
"Public access is not allowed for workspace: <id here>"

I think it can be a networking issue. Try to create private endpoints and check if this resolve your issue:

Private Link for Lakebase Autoscaling - Azure Databricks | Microsoft Learn