Looker -multiple data connections and querying our it

Hi all,

I have a use case where I need to connect to different data bases say Mysql, snowflake and I should put a query over it like if 1st db contains student 1 table with with column-  Id -1-10 and db2- student table 2 - id -10-20. So we should put some lookml code such a way that it pics db1 when Id is between 1-10 else db2. If possible please share some example code

 

TIA

0 0 98