top of page
  • Writer's pictureTim Burns

Know Your Snowflake Admin

Before DevOps and the associated glamor, DevOps was done by a Systems Administrator.

FYI: MOTAS means Members of the Attractive Sex

SITUATION: Set Up a Role for a Snowflake Stage Account

* Technical Thug: Uses CloudFormation. Throws it away and uses Terraform.

* Administrative Fascist: Uses AWS Console, because she's the only one with access. Creates a read-only access point to a database where only she can access. Follows the best practices and sets up a storage integration with no password. Denies access to all users.

* Maniac: Uses Terraform.

* Idiot: Uses Stackoverflow.

    "Id": "...",
    "Statement": [ {
        "Sid": "...",
        "Action": [
        "Effect": "Allow",
        "Resource": "arn:aws:s3:::bucket/*",
        "Principal": {
            "AWS": [ "*" ]
    } ]

19 views0 comments

Recent Posts

See All

Carto, Snowflake, and Data Management

A basic principle of data management: Don't move data unless you have to. Moving data is expensive and error-prone. Data Egress Cost: How To Take Back Control And Reduce Egress Charges Archiving to S


bottom of page