ARA-C01 Snowflake Architecture — All Questions With Answers

{
  "Version": "1",
  "Statement": [
    {
      "Effect": "Allow",
      "Action": ["snowflake:core:connect"],
      "Resource": ["*"],
      "Condition": {
        "StringLike": {
          "snowflake:core:client_type": ["SNOWSQL", "JDBC"]
        }
      }
    }
  ]
}

{
  "query_id": "01b2c3d4-0000-1111-0000-000012345678",
  "status": "FAILED",
  "error_code": "390100",
  "error_message": "SQL access control error: Insufficient privileges to operate on warehouse 'WH_PROD'"
}

SELECT "partitions_scanned", "partitions_total"
FROM TABLE(INFORMATION_SCHEMA.QUERY_PROFILE('01af34...'))
WHERE "operator_type" = 'TableScan';

{
  "query": "SELECT * FROM large_table WHERE date = '2023-01-01'",
  "partitions_total": 50000,
  "partitions_scanned": 150,
  "bytes_scanned": "120MB"
}

{
  "Version": "2012-10-17",
  "Statement": [
    {
      "Effect": "Allow",
      "Action": [
        "s3:GetObject",
        "s3:GetObjectVersion"
      ],
      "Resource": "arn:aws:s3:::production-data/*"
    },
    {
      "Effect": "Allow",
      "Action": [
        "s3:ListBucket"
      ],
      "Resource": "arn:aws:s3:::production-data",
      "Condition": {
        "StringLike": { "s3:prefix": [ "logs/*" ] }
      }
    }
  ]
}

ALTER WAREHOUSE analytics_wh SET 
  WAREHOUSE_SIZE = 'LARGE'
  MAX_CLUSTER_COUNT = 5
  MIN_CLUSTER_COUNT = 2
  SCALING_POLICY = 'ECONOMY'
  AUTO_SUSPEND = 300;

SELECT * FROM sales_data WHERE sale_date = '2023-01-01';
-- Query executed in 0.2 seconds
-- Query Profile: Result Cache used