Motivation
A customer inquired whether data federation is possible natively in CockroachDB. Unfortunately, CockroachDB does not support features like foreign data wrappers and such. A quick search returned a slew of possibilities and Presto being a prominent choice, sparked my interest.
High-Level Steps
- Install Presto
- Configure Postgresql catalog
- Configure TPCH catalog
- Verify
- Wrap up
Step by Step Instructions
Install Presto
I'm using a Mac and luckily there's a homebrew package available.