2 different connections 1 model multiple views

[ev_looker]

I tried checking in other posts and I couldn’t accomplish joining data from 2 different connection.

I have a connection from snowflake and another from BigQuery. I built calendar table in big query and brought it in the model. I am able to query calendar data without error from that view separately. There are no errors when I joined calendar view with Order, Product & Customer views, however when I tried to bring year from Calendar view and order items from Order views, it throws error “SQL compilation error: XXXXXXbigquery does not exist”

Can someone help?