Recent Articles

  • Snowflake: Creative Create Table Tactics

    Snowflake: Creative Create Table Tactics

    During a recent build of a Snowflake data environment, I encountered a challenge while translating my SQL Server code to Snowflake. As any seasoned database developer knows, dealing with staging tables and SCD (Type-2 slowly changing dimension) tables is par for the course in data warehousing. In the realm of table creation, there’s the classic Read more

  • Python Byte: Loading Data to Snowflake from SQL Server

    Python Byte: Loading Data to Snowflake from SQL Server

    For a recent proof of concept, I needed to transfer data from five or six relatively small tables from SQL Server to Snowflake. Normally, I would go through all the steps to set up an ingestion pipeline in Snowflake; however, for a POC, that all seemed like overkill. I simply needed to copy the data Read more

  • Streamlit in Snowflake: Navigating Role-Based Row Access Complexity

    Streamlit in Snowflake: Navigating Role-Based Row Access Complexity

    In a recent article, I showed a local Streamlit app that enforces role-based row access policies based on the Snowflake role used in the session variable. The selectbox in the app simulated how the app would act as users in different roles executed the app. Are native Streamlit apps capable of using RBAC for Row Read more

  • Snowflake: Table-Driven Row Access Policies

    Snowflake: Table-Driven Row Access Policies

    In a previous article, I showed how to set a row access policy on a view to limit the rows returned by a query dependent upon the user’s role in Snowflake. The row access policy had the roles I cared about hard coded into the policy code; however, in a real-world scenario, that isn’t manageable Read more

  • Streamlit: Application of Snowflake Row Access Policies

    Streamlit: Application of Snowflake Row Access Policies

    In my last post, I showed how to set up hierarchical roles in Snowflake and then apply a row access policy based on those roles. In this article, I’ll show an application of those policies using a Streamlit app. An important note is that this is not a native Streamlit app in Snowflake. As of the writing of Read more

  • Snowflake: Row Access Policy with Hierarchical Roles

    Snowflake: Row Access Policy with Hierarchical Roles

    “Row Access Policy with Hierarchical Roles” is a mouthful! What in the world am I talking about? I’ll start with hierarchical roles since most organizations have some hierarchical people reporting structure. Next, I’ll discuss Snowflake’s row access policy and how it applies to hierarchical roles. Hierarchical Roles Snowflake uses role-based access control (RBAC) for object Read more