Multiple connections in one model

[lisacabisa]

Hi,
I’m new to Looker and I’m trying to figure out how to have a model that uses more than one connection - as is probably the case with many people, my data does not live neatly in one database.
So, I created a model with two connections. I am getting a “relation does not exist error” so I added sql_table_name to my views for each table with the full name ...
I can’t imagine that the data other people use lives neatly in one database… How can I use multiple connections in on model?
Thank you for your help!