That is a great point!I did some testing and I was able to re-create your issue in my own environment by doing the following:Create a notebook with a `CREATE MATERIALIZED VIEW IF NOT EXISTS` statement that queries a Lakehouse Federated database.Manua...
Hi @pesky_chris!Are you otherwise able to access your federated Postgresql data via the Serverless SQL Warehouse (e.g. using a SELECT statement)?If not, your issue may be due to networking/firewall between the Serverless SQL Warehouse and your Postgr...
Hi @Mario_D!While primary & foreign key constraints are generally available in Databricks Runtime 15.2 and above, they are strictly informational only.This means that a primary key will not prevent duplicates from being added to a table and a foreign...
Hi @EmmaP!I have encountered this. Even though the UI says that they are complete, they actually are not. While the query itself completed, the client is still fetching the data from the SQL Warehouse.To check if this is your issue, from the monitori...