Skip to main content

HOW TO INSTALL VERTICA S3EXPORT -- Data movement from vertica to S3

  • June 19, 2018
  • 1 reply
  • 5 views
ishangaur

Hi ,

We have a Use case where in i want to move the data from Vertica cluster to AWS S3 . I did come across below from Vertica forum -

https://my.vertica.com/docs/8.0.x/HTML/index.htm#Authoring/AdministratorsGuide/BulkLoadCOPY/AWSLibrary/exportAWSlibrary.htm

But my very 1st question is how do i install the S3Export on vertica cluster ? What kind of configurations needs to be done in order to move the data from Vertica table to AWS s3 ?

Kindly suggest the approach to do configuration ?

Thanks
Ishan

    1 reply

    Jim_Knicely
    Forum|alt.badge.img+2
    • Jim_Knicely
    • Participating Frequently
    • June 20, 2018

    The S3EXPORT function should already be installed.

    dbadmin=> \df s3export
                         List of functions
 procedure_name | procedure_return_type | procedure_argument_types
----------------+-----------------------+--------------------------
 s3export       | Integer, Varchar      | Any
(1 row)

    To use it you first have to configure he AWS Library.

    See:
    https://my.vertica.com/docs/8.0.x/HTML/index.htm#Authoring/AdministratorsGuide/BulkLoadCOPY/AWSLibrary/configuringVerticaAWSLibrary.htm

    Note: Vertica 8.0.x is no longer supported. I'd consider upgrading ASAP!

    Still scrolling?
    Ask a question
    Terms & ConditionsAccessibility statement