top of page

THE OWL MOUNTAIN BLOG
Tim Burns
The Owl Mountain Blog is the authors views on the Fascianting World of Data
Search
A Sad Loss
I am mourning my friend Bob Lee. http://blog.crazybob.org/2006/12/five-things-you-may-not-know-about-me.html https://en.wikipedia.org/wik...
Tim Burns
Apr 9, 20231 min read
13 views
0 comments


Thoughts on Surrogate Keys in Spark, Snowflake, and Databricks
As a database developer, I take surrogate keys for granted. The surrogate key is the backbone of a data architecture. In the Kimball...
Tim Burns
Mar 30, 20232 min read
370 views
0 comments


Pitching a Book - Public Speaking Samples
I'm pitching a book on Big Data Analytics and Data Engineering, and the proposal worksheet has a field that says, "Author public speaking...
Tim Burns
Mar 29, 20232 min read
10 views
0 comments


Technical Blogging and the Gospel of Thomas
Today at the First Unitarian Church of Providence, where I am a member, the sermon was on the Gospel of Thomas, one of the Gnostic...
Tim Burns
Mar 19, 20231 min read
17 views
0 comments

Data Warehousing, the Three-Tier Data Pattern, and Normal Forms (2NF, 3NF)
The Data Warehouse (Lakehouse) So we want to store all our data in a data warehouse to make business decisions based on data. Every data...
Tim Burns
Mar 18, 20232 min read
28 views
0 comments

Who to Review for Data Warehousing and Lean
I received an email from a company asking me to write training manuals for them, and it got me thinking. If I were to create materials,...
Tim Burns
Mar 12, 20232 min read
18 views
0 comments
DW Design Planning - Provide the Analysts with Access to Answer Business Questions
I am gradually working through the Kimball Model through various blog postings. Reading the postings in order would make more sense, and...
Tim Burns
Mar 11, 20233 min read
16 views
0 comments


My Mom Teaching Galapagos Volcanoes
I am so heart-warmed this morning to get this video of my mother who was an amazing person and teacher.
Tim Burns
Mar 10, 20231 min read
9 views
0 comments
Automate Snowflake Data Pipelines with Terraform
References Snowflake (2021) SNS subscription remains in the Pending state while configuring Snowpipe using SNS AWS (2023) Walkthrough:...
Tim Burns
Mar 4, 20231 min read
80 views
0 comments
The Kimball Model Revisted - Data Quality
Once we've gathered the data we need into a data lake, we need to assess the quality and build pipelines to get all data to a consistent...
Tim Burns
Feb 26, 20233 min read
42 views
0 comments
An Updated Take on The Kimball Model
You have a mountain of data and the unlimited potential of a cloud data architecture to load it, but where should you start? Maybe you...
Tim Burns
Feb 21, 20234 min read
46 views
0 comments
Using ChatGPT for Data Modelling
ChatGPT is a great data modeling tool. I wanted to generalize my data model for my radio station data warehouse, and I asked ChatGPT to...
Tim Burns
Feb 19, 20231 min read
11 views
0 comments
Sequences in Snowflake - Unsung Data Integrity Heroes
Sequence Basics Sequences are the unsung heroes of a data application. I like to think about sequences in two forms: Surrogate keys - the...
Tim Burns
Feb 18, 20232 min read
81 views
0 comments


This is my Happy Face
From the Pirate Missy - Pretty much sums up how I feel today.
Tim Burns
Feb 13, 20231 min read
12 views
0 comments


Studying Snowflake - Using Stages for Data Discovery
The Author Chopping Wood on a Winters Day Set up a Secure Storage Integration and Create Stages The foundation of data discovery is a...
Tim Burns
Feb 12, 20232 min read
18 views
0 comments


Studying Snowflake - Data Analyst Study Guide
Photo by Aaron Burden on Unsplash Snowflake is an Enterprise-Level Data Platform for the major cloud providers: AWS, Azure, and GCP. ...
Tim Burns
Feb 11, 20231 min read
15 views
0 comments


Thomas Merton in a Year of War
Photo by Ethan Sykes on Unsplash The writings of Thomas Merton spoke to me when I was in college. I borrowed the Seven Story Mountain...
Tim Burns
Feb 5, 20232 min read
14 views
0 comments
The Lean Startup - Reading Notes
It is Martin Luther King day, and I am fortunate to have a holiday. However, I haven't lost sight of my goal of becoming an entrepreneur...
Tim Burns
Jan 16, 20234 min read
16 views
0 comments
A Charge for any Leadership Vocation
We swore in new deacons today at church, and the charge to the deacons resonated as a charge we can take for any leadership vocation....
Tim Burns
Jan 15, 20231 min read
5 views
0 comments


Thoughts on the Past - My Time at Retail Solutions
Photo by Author of the Never Summer Mountain Range Many years ago, I had a colleague who had a similar role I now have: Build and...
Tim Burns
Jan 14, 20233 min read
52 views
0 comments

bottom of page