We have Databricks set up and running on Azure. Now we want to connect it with Redshift (AWS) to perform further downstream analysis for our redshift users.

I could find the documentation on how to do it within the same cloud (Either AWS or Azure) but not cross cloud.

So was wondering what would be the best approach to allow redshift to read the delta lake hosted in azure. I was hoping some sort of glue catalog could be set-up and that could allow reading from redshift as an external table

Highly appreciate the help.