What are the S3 required permission to use S3 as database storage (i.e. : create database into S3 …)
Would this be enough?
“Action”: [
“s3:PutObject”,
“s3:GetObject”,
“s3:ListBucket”
]
What are the S3 required permission to use S3 as database storage (i.e. : create database into S3 …)
Would this be enough?
“Action”: [
“s3:PutObject”,
“s3:GetObject”,
“s3:ListBucket”
]
I’m not sure of the precise permissions needed on the AWS side, but when you create an unlimited storage database on S3, you use syntax like this:
CREATE DATABASE bottomless_db ON S3 "bottomless_db_bucket/bottomless_db_folder"
CONFIG '{"region":"us-east-1"}'
CREDENTIALS '{"aws_access_key_id":"your_access_key_id","aws_secret_access_key":"your_secret_access_key"}';
The AWS access key information provided must have both read and write access to the named S3 bucket/folder (similarly for Azure and GCS).
The above CREATE DATABASE command is from