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

How to give user access to external table of parquet data on S3

As dbadmin I have performed EXPORT TO PARQUET to place parquet data in S3. I then successfully created an external table so that I can query using:

CREATE EXTERNAL TABLE tracking(...) AS COPY FROM 's3://my_bucket/tracking//.parquet' PARQUET(hive_partition_cols='startDate');

dbadmin can query the external table, but any other vertica user gets the following error:
ERROR 4368: Permission denied for storage location [s3://my_bucket/tracking//.parquet]

How do I allow other vertica users query access to the parquet data stored in S3?

Comments

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.