S3 Bucket

Sprinkle requires a Cloud Storage Bucket to store intermediate data and report caches.

Follow the below steps to create and configure an S3 Bucket.

STEP-1: Create an S3 bucket

Create an S3 bucket, and provide any name like “sprinkle” in the same location/region as the Redshift cluster.

STEP-2: Create an IAM user for S3 access

Create a new IAM user, provide any name like “sprinkle-s3-user”. Select credential type as the Access key. Create an inline policy as below. Make sure to use the actual bucket name in place of BUCKET_NAME:

{
    "Version": "2012-10-17",
    "Statement": [
        {
            "Sid": "VisualEditor0",
            "Effect": "Allow",
            "Action": [
                "s3:*"
            ],
            "Resource": [
                "arn:aws:s3:::<BUCKETNAME>/*",
                "arn:aws:s3:::<BUCKETNAME>"
            ]
        }
    ]
}

From the credentials tab, get the Access Key Id and Secret Key of the IAM user.

STEP-3: Configure the S3 connection in Sprinkle

• Provide all the mandatory details
  • Distinct Name: Name to identify this connection
  • Access Key: Created in STEP-2
  • Secret Key: Created in STEP-2
  • Region: Region of the bucket, example: ap-south-1
  • Bucket Name: Name of the bucket created above
• Test Connection
• Create