cancel
Showing results for 
Search instead for 
Did you mean: 
Warehousing & Analytics
Engage in discussions on data warehousing, analytics, and BI solutions within the Databricks Community. Share insights, tips, and best practices for leveraging data for informed decision-making.
cancel
Showing results for 
Search instead for 
Did you mean: 

Foreign Catalog - AWS Redshift

Dnirmania
New Contributor III

Hello Everyone

Recently, my team integrated an AWS Redshift database as a foreign catalog in Azure Databricks. We can successfully run SELECT queries and create regular views on top of the foreign catalog table. However, when attempting to create a materialized view, we encounter a "connection timeout" error. We're using a SQL Warehouse Pro with 24 DBU/hr per cluster, and the foreign catalog table contains only 26 rows and 5 columns.

Any assistance with this issue would be greatly appreciated.

Thanks,
Dinesh

1 REPLY 1

Alberto_Umana
Databricks Employee
Databricks Employee

Hi @Dnirmania,

Materialized views in SQL often use serverless Delta Live Tables pipelines, which might be causing the connection timeout due to IP whitelisting restrictions. Serverless compute might not be able to connect to the federated source if the IPs are not whitelisted, can you query your federated table using serverless?

Connect with Databricks Users in Your Area

Join a Regional User Group to connect with local Databricks users. Events will be happening in your city, and you won’t want to miss the chance to attend and share knowledge.

If there isn’t a group near you, start one and help create a community that brings people together.

Request a New Group