Unlock the full power of your data with Peliqan’s built-in federated query engine, Trino (also known as Presto)
In this video, we dive into how to seamlessly combine data from your central data warehouse (like Pipedrive and Odoo) with external databases, such as an unreplicated SQL Server.
Learn how to:
– Write SQL queries that span across different connected databases.
– Activate the Run Query on Trino engine option to execute federated queries.
– Understand when to use fully qualified table names to prevent naming conflicts.
– Check the status and run time of your Trino queries.
Key limitation: Trino queries must only reference other Trino queries.
Stop moving data and start querying it – wherever it lives!