snowflake.md

Snowflake Policy

S3 Snowflake Storage Integration

{
    "Version": "2012-10-17",
    "Statement": [
        {
            "Effect": "Allow",
            "Action": [
                "s3:PutObject",
                "s3:GetObject",
                "s3:GetObjectVersion",
                "s3:DeleteObject",
                "s3:DeleteObjectVersion"
            ],
            "Resource": [
                "arn:aws:s3:::raw-<>/*",
                "arn:aws:s3:::cur-<>/*",
                "arn:aws:s3:::hist-<>/*"
            ]
        },
        {
            "Effect": "Allow",
            "Action": [
                "s3:ListBucket",
                "s3:GetBucketLocation"
            ],
            "Resource": [
                "arn:aws:s3:::raw-<>",
                "arn:aws:s3:::cur-<>",
                "arn:aws:s3:::hist-<>"
            ]
        }
    ]
}

Use this to check if connections is successful. LIST @SPORTS_DB.RAW_LAYER.GAMES_STAGE;