OAuth token generation using Snowflake custom OAuth

Based on support article from Snowflake

Solution

The objective of the article is to provide a means of generating an access token and refresh token using Snowflake Custom OAuth. Once complete, end-users should be able automate the flow to get the new access tokens via refresh token(until expiry).

For testing purposes, this article will also show a successful connection using access token when making a connection through SnowSQL.

5 Morning Habits Of Highly Successful People

by Caroline Castrillon, Forbes

Many of us start the day with a ringing alarm clock, a big cup of coffee and a quick check of our email. But if you analyze the morning habits of very successful people, that's exactly what they don't do. As Arianna Huffington says, "A big part of my morning ritual is about what I don't do: when I wake up, I don't start the day by looking at my smartphone. Instead, once I'm awake, I take a minute to breathe deeply, be grateful, and set my intention for the day."

These five morning habits of highly successful people will help you kick-start your day so you can achieve greater focus, clarity and productivity.

Summary - Personal Disruption Framework

Disrupt Yourself by Whitney JohnsonGadge

From the Magazine (July–August 2012) Buy Copies

Summary.   Disruptive innovation has been a pioneering concept in business since 1995. Johnson, a founding partner at Clay Christensen’s investment firm, explains how you can apply disruptive thinking

My career path has been an unusual one. I started as a secretary on Wall Street, worked my way up in my firm’s investment banking group, and then stepped back to become an equity research analyst. Eight years later, I quit that job to produce a TV show and write a children’s book, but I ended up blogging about work/life issues and cofounding a hedge fund backed by a man I’d met at church. It’s not what you’d call a traditional corporate trajectory. But perhaps that’s the new normal.

Using python to connect to Snowflake

Based on this documentation.

This topic provides instructions for installing the Snowflake Connector for Python. The connector can currently be installed in Linux, macOS, and Windows environments.

Install the connector:

$ pip3 install --upgrade snowflake-connector-python

Create a file (e.g. validate.py) containing the following Python sample code, which connects to Snowflake and displays the Snowflake version:

#!/usr/bin/env python
import snowflake.connector

# Gets the version
ctx = snowflake.connector.connect(
    user='<your_user_name>',
    password='<your_password>',
    account='<your_account_name>'
    )
cs = ctx.cursor()
try:
    cs.execute("SELECT current_version()")
    one_row = cs.fetchone()
    print(one_row[0])
finally:
    cs.close()
ctx.close()

Make sure to replace <your_user_name><your_password>, and <your_account_name> with the appropriate values for your Snowflake account.

Airflow Docker Container - How to get started guide

Deploying Airflow with Docker and Running your First DAG

Based on content from: Getting Started with Airflow Using Docker, Mark Nagelberg

This rest of this post focuses on deploying Airflow with docker and it assumes you are somewhat familiar with Docker or you have read my previous article on getting started with Docker.

As a first step, you obviously need to have Docker installed and have a Docker Hub account. Once you do that, go to Docker Hub and search “Airflow” in the list of repositories, which produces a bunch of results. We’ll be using the second one: puckel/docker-airflow which has over 10 million pulls and almost 100 stars. You can find the documentation for this repo here. You can find the github repo associated with this container here.

How to be happy

Neil ParsrichaNeil

www.neil.blog

We have all been taught wrong!

Wrong

But really

Correct

Three Tools for Positivity

Two minute morning routine

When you first wake up spend two minutes on this

Two minute morning routine

  1. Today I will let go of ...
  2. Today I am grateful for ...
  3. Today I will focus on ...

Have a weird hobby

Do something new to you, something you are not good at.

Range: Why Generalists Triumph in a Specialized World by David Epstein

How to capture Snowflake users, roles and grants into tables.

Based on post from Venkatesh Sekar, but with lots of code cleanup.

You may be asked to participate in a security and audit review and have to answer some questions like these:

  • How are our users connected to Snowflake?
  • What are the custom roles that we implemented?
  • Which users are assigned to which hierarchy?
  • What are the privileges assigned to a particular role, and which privileges are granted via inheritance?
  • Given a database object such as a table, how is that table accessed by a specific user and through which roles?
  • Are there any ghost or zombie roles?
  • Are the roles getting inherited by SYSADMIN or SECURITYADMIN?
  • Which users are assigned to ACCOUNTADMIN?
  • Are there any tables getting created and assigned to SYSADMIN and not following best practices?
  • Can you provide a visual representation of users, roles, and grants in Snowflake?

And so on and so forth.