Search
  • Tim Burns

Know Your Snowflake Admin

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


https://www.gnu.org/fun/jokes/know.your.sysadmin.en.html


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. https://docs.snowflake.com/en/user-guide/data-load-s3-config.html


* Maniac: Uses Terraform.


* Idiot: Uses Stackoverflow.



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

16 views0 comments

Recent Posts

See All

Here is the ticket master public API. https://developer.ticketmaster.com/ Could be a very interesting edition to cross-reference with Playlist info to get hot concerts that may be under the radar.

Elon Musk embodies the worst aspects of the tech bro spirit. He has no moral compass. He lacks compassion. He elevates the vilest voices in our world. He is not the kind of person I would want to