How To Query Against Multiple Postgres Instances As If They're One Server Using Starburst Presto
When the data you need is located in multiple servers you're faced with time-consuming and difficult choices to query it. The easy button for solving this is to use open-source abstraction layers such as Starburst Presto which just needs the connection string for each of the servers to create a single federated point of access for you. The Presto abstraction layer:
- Connects your Postgres servers together so you can query them as one unit.
- Creates a scalable architecture where you can have multiple users access it at once.
- Allows you to add diverse data store types together including Hive-style object stores, Oracle, MS SQL, MySQL, and many others. This makes it easy to do cross-DBMS queries and unlocks your Postgres data for use in the broader data world for your users.
By the end of the session, you will know how the architecture of this system works for Postgres servers to solve this problem, and know where to download and install it in your own environment.
- 2020 September 16 10:00 UTC
- 1 h
- Postgres Webinar Series