Skip to content

Create a Primary Storage Bucket

When you deploy Yellowbrick software, you can create and use your own S3 bucket for database storage. When data is loaded into Yellowbrick tables, your bucket will be used, instead of a bucket that Yellowbrick creates for each data warehouse instance. Creating your own bucket is optional.

Important: If you plan to use your own bucket, you must create external storage and location objects before creating any virtual compute clusters for an instance. These objects specify the bucket location and credentials for accessing it. You can run CREATE EXTERNAL STORAGE and CREATE EXTERNAL LOCATION commands in the Yellowbrick Manager Query Editor (or via ybsql) after creating instances. (You do not need to create a cluster or a database first.)

The bucket you create must be readable and writable to the user defined during the installation process. Below is a sample bucket policy, as defined in the Permissions tab for the bucket. When creating objects to be used in a Yellowbrick installation, make note of the name (ARN) of each object to be used (see the Resource entries below).

{
   "Version": "2012-10-17",
   "Id": "EnableBucketEncryption",
   "Statement": [
       {
           "Sid": "Deny non-TLS",
           "Effect": "Deny",
           "Principal": "*",
           "Action": "s3:*",
           "Resource": [
               "arn:aws:s3:::ybownbucket",
               "arn:aws:s3:::ybownbucket/*"
           ],
           "Condition": {
               "Bool": {
                   "aws:SecureTransport": "false"
               }
           }
       }
   ]
}

See also Initial Login and Password Reset.

Parent topic:Preparing for a New Installation