In March 2022 I got a chance to participate on beta program for totally new Snowflake advanced certification for Administrators. In that time I have been already working as Snowflake admin for 3 years so I thought it might be good prerequisite to go and try the exam together with…

In one of the older posts related to increasing Snowflake security I briefly mentioned Snowflake external functions. They are available in public preview since June 2020. We use this feature for integration with AWS KMS. Key management store generates the encryption keys for our custom data encryption which is the…

Everyone hates it — password rotation. That message which you get every XX days saying that your password is too old and needs to be changed. But suddenly it does not look as bad idea at all when you are behind the wall and maintaining data warehouse or data app…

This is the second part of the series related to saving Snowflake credits and cost in general. You can find the first part dedicated to compute cost saving here. Storage cost optimization Even though the biggest part of your bill will be for compute it is worth to think also about your storage…

Snowflake Data Cloud has a pay-as-you go pricing model. There are no upfront costs for licenses or any hardware purchase. There are no costs for infrastructure management and maintenance. You just pay for storage and compute as you go. But it does not mean you can’t be effective in terms…

What? Managing Snowflake infrastructure? There is supposed to be no infrastructure to manage. That is one of the Snowflake selling points and benefits — almost zero maintenance and no infrastructure to manage. True, but as an „infrastructure“ you can consider also things like users, roles, and privileges or warehouses which…

Data Quality — one of the crucial parts of the DWH development lifecycle but still I believe part which usually lies on the bottom of the backlog with the lowest priority. Simply because it does not bring immediate business value — no new dashboard or KPI is coming on stage…

Today I would like to share my experience with successful migration from Cloudera to Snowflake which we managed quite quickly, only during 3 months. I am speaking about enterprise DWH migration which has 30+ TB in size and more than 2000 ETL / data preparation jobs. Let’s have a closer…

DevOps or better to say DataOps for data-related projects is one of the latest trends in the software development lifecycle and as such it is a very wide term covering many areas including release management, version control, project management, and much more. Compared to an application or microservices the database…