Skip to main content
Question

DB-LINK equivalent for cross-cluster queries?

  • Apr 1, 2020 10:49 PM UTC
  • 1 reply
  • 9 views

DreaBrandford

Is Vertica going to develop something like DB-LINK, i.e. a possibility to run cross-cluster queries?

Asked during BDC session The Shortest Path to Vertica - Best Practices for Data Warehouse Migration & ETL
@marcothesane @Maurizio

1 reply

ChuckB
Forum|alt.badge.img
  • Participating Frequently
  • Apr 5, 2020 4:48 AM UTC

Import/export has a lot more flexibility than you'd guess, and so does object backup/restore.
I used DB links in a former life, the perfomance wasn't good.
Long way of saying, we don't support an identical feature, but we have interesting options to get similar results faster.