Creating a view that reads across catalogs/schemas

[mstowe-digi]

Hello,

I am looking to connect Trino to our BI Platform (Domo).

I have two catalogs setup, one from snowflake, and another from a mysql database.

I want to create a view via Trino that captures a SQL join from these two catalogs and exposes to Domo as a dataset.

If you were to take the following query:

select 
     foo.my_id,
     bar.my_foo,
     bar.my_bar
from mysql.example_schema.example_table foo
     LEFT JOIN snowflake.example_schema.bar bar
         on foo.my_id = bar.my_id;

How can I create a view using this type of query in Trino? Is there a recommended metastore that can support this?

Thanks!

[ebyhr]

Those connectors don't support creating views. You need to add another catalog that supports creating Trino views. e.g. Iceberg connector

[mstowe-digi]

Will the iceberg connector allow me to create a view using other catalogs as specified in my example query? e.g. not even querying iceberg?

[ebyhr]

Yes.