How to create DB link between two vertica databases

iadarsh

Hi, I want to perform QA on Stage and DWH databases.
Problem is that my staging database is present on different Vertica server and DWH database on different.

I want to create a DB Link between these two vertica database servers.

How can I do that?

skeswani

you can either pull data or push data

see
https://www.vertica.com/docs/9.2.x/HTML/Content/Authoring/AdministratorsGuide/CopyExportData/CopyingAndExportingData.htm

Push
https://www.vertica.com/docs/9.2.x/HTML/Content/Authoring/SQLReferenceManual/Statements/EXPORTTOVERTICA.htm

Pull
https://www.vertica.com/docs/9.2.x/HTML/Content/Authoring/AdministratorsGuide/CopyExportData/CopyingData.htm