One of the many things that the business team asks me to do is to create random-ish data. Thankfully, in Snowflake, there are many ways to make this happen. Today, I want to go thru just a few of them. Perhaps the one that most people are familiar with is making Snowflake create a random…… Continue reading Creating Random Data in Snowflake
Month: June 2023
Cleaning Up Your Data the Easy Way in Snowflake
I don’t know about y’all but I have to work with dirty data. A lot. When you’re working with dirty data, one of the many things you can run into is that when you try to divide two numbers – you can cause a huge error because you tried to perform a mathematical no-no -…… Continue reading Cleaning Up Your Data the Easy Way in Snowflake
Computing New Columns in Snowflake for fun and profit
Sometimes to make our lives easier, we, as database engineers, can create a table that automatically tells us the answer as we need it – or at least how we tell it we want it. In SQL Server, we create what is called “Computed Columns.” DROP TABLE IF EXISTS dbo.Payroll; GO CREATE TABLE dbo.Payroll (…… Continue reading Computing New Columns in Snowflake for fun and profit
Where We’re Going, We Don’t Need Limits
There is always a lot of fun things you can learn to do with Snowflake. Sometimes they’re even in the places you least expect to find anything even slightly different. Take for example LIMIT. SELECT * FROM public.employees LIMIT 20; Most of us have written the statement above – or something like it – a…… Continue reading Where We’re Going, We Don’t Need Limits