Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

DB-LINK equivalent for cross-cluster queries?

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

Answers

  • ChuckBChuckB Employee

    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.

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.