The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.

Vertica EON S3 access without IAM role

I've been trying to evaluate Vertica EON on AWS but could not find any way to pass IAM credentials to admintools when creating the database. I know setting up an EC2 role works, but is there any way to create a Vertica EON database with specific Access-Key/Secret-Access-Key ?

I appreciate any insight someone may have on this :smile:


  • skeswaniskeswani Employee Employee

    yes there is a way. (applies to vertica 9.2+)
    Add the following parameters to


    Then issue the create_db command. These get baked into the database.

    awsregion = us-east-1
    awsenablehttps = 1

    offcourse, ensure that this key has access to the bucket, else create_db will fail

  • vctrstrmvctrstrm

    Awesome! Thanks a bunch @skeswani !

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
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.