Federated query from multiple backend instances

[satish4]

I have Looker dashboard, which needs to marshal data across two Snowflake instances - one in AWS and the second is on Azure. Is there any way, I can combine this in Look ML queries (Federated approach)?

[Eric_Lyons]

Hi Satish,

We would generally recommend a merged result which combines the results of two explore queries. This is subject to the row limit of the underlying explores though. This is done in essence in memory, so is not subject to the limitations to a traditional SQL join. 

For a federated join, the two databases must use the same SQL dialect, reside on the same physical machine, and are accessible from the same connection in Looker.

Under those conditions, you can create a federated join by specifying the database name of each table in the sql_table_name parameter for that view.

More information on this can be found here. 

Another potential option may be a foreign data wrapper or a secure view. 

Thanks,

Eric

[satish4]

Thanks, will look into the secure view option, as my data resides in different clouds.