Tag: snowflake

Methodology for Snowflake Role-Based Access Control

Justification Snowflake offers role-based access control (RBAC) as the mechanism to handle authorization of security principals (users, services, etc.) and grant or deny them access to different database objects and operations. A key piece of a successful Snowflake implementation is…

Read More >

DataOps – Liquibase to Manage Changes in Snowflake

What is this about? Well, as the title implies, I will show how to set up Liquibase to manage changes in Snowflake as part of a DataOps practice. Why? Because I am going deep-dive into DataOps around Snowflake and I’ve…

Read More >

Snowflake System Function Error: Argument 0 to Function SYSTEM$PIPE_STATUS Needs to Be Constant

I recently encountered the above issue which prompted me to write this blog post so I can easily reference the solution whenever I need it. However, I also hope it might help anyone out there who hits a similar issue….

Read More >

Replicating MySQL to Snowflake with Kafka and Debezium—Part Two: Data Ingestion

Here we go again Hello, and welcome to this second part of my “Replicating MySQL to Snowflake” series. If you landed here from a web search and missed part one, you can take a look here: part one. What’s up?…

Read More >

Replicating MySQL to Snowflake with Kafka and Debezium—Part One: Data Extraction

What, Snowflake? Yes, Snowflake. While my core skills are based on the Oracle database, lately I’ve been working more on platforms like BigQuery and Snowflake—”lately” being the last one-and-a-half years or so. While this is my very first post related…

Read More >

Top Five Recommendations to Accelerate Your Snowflake Adoption

After eight years in business, Snowflake filed its prospectus with the USA’s Securities and Exchange Commission to become a publicly traded company this week (August 24, 2020). Details are here. This is the next step in the history of the…

Read More >

Datascape Podcast Episode 44: Snowflake with Kent Graziano

Episode 44: Show Notes Snowflake is the only data platform built for the cloud for all your data and all your users. Today we have Kent Graziano, Chief Technology Evangelist at Snowflake, here on the show to discuss how this…

Read More >