Skip to content
  • Home
  • Posts
  • BigID
    • BigID Website
    • BigID Blog
    • BigID Workshops
    • Big Ideas
  • Linux
    • Linux Foundation
    • Grep Commands
    • Red Hat Family
      • Rocky Linux Home
      • What is Rocky Linux and Why Use It
      • How to set a static IP in Rocky Linux
    • SUSE Family
    • Debian Family
  • K8S & Docker
    • Kubernetes
      • Kind QuickStart
      • Installing KUBECTL on Linux
    • Docker
      • DockerDocs
      • Docker Hub
      • Docker CLI Cheat Sheet
      • Install Docker on Ubuntu
      • Docker Crash Course
      • Docker Complete Course
    • Helm
      • HELM QuickStart
    • Kind
      • KIND Home
      • KIND 101
      • K8s KIND & HELM
  • Mongo DB
    • Install Mongo Community on Ubuntu
  • Privacy Regulation
    • Privacy Babel: Making Sense of Global Privacy Regulations
    • IAPP.Org
    • Convention 108
    • Data Protection and GDPR update (2024)
    • GDPR
      • GDPR.EU
      • Complete Guide for GDPR
      • Articles of GDPR
      • 10 Steps to GDPR Compliance
      • 7 Principles of GDPR
      • GDPR – 6 Legal Basis
    • PIPEDA Video
    • LGPD (Brazil)
    • EU AI Act
  • Interesting Tech Videos
    • Hadoop in 5 Minutes
  • Tools
    • YAML Checker
    • KubeTools
  • Linux Cheat Sheet

Scotty's Tech Hangout!

Cool stuff that I want to learn and remember!

Snowflake Logical

 iwannabeasnowflake  November 24, 2023

Categories

  • Architecture
  • Marketplace
  • Nuggets
  • Query
  • SQL 101
  • Warehouse

Tags

Add Column Age Calculation Architecture Array BBQ Cloud Services Copy Into Create a Clone Create Views Creating Warehouse Database Storage Data Loading Dogs Rock! Drop Family First Flatten Functions Hobbies Home Computer Install SnowSQL k8s install Lake Life! Lateral Join Life is Fun! Long Running Query Marketplace Order By Query Example Query Processing Rename Column Resource Monitor Scaling Warehouse Semi-Structured Data Show Databases Show Schemas Show Tables within Schema SnowPark Optimized SQL Joins Suspending Warehouse Swap Dev with Prod Time Travel Undrop Update Column Update Values in Column VPC

Snowflake Resources

  • Snowflake Case Studies
  • Snowflake Guides
  • TastyBytes GitHub

Snowflake Learning

  • Introduction to Snowflake
  • What is Snowflake? 8 Minute Demo
  • Snowflake Data Cloud: 7 Pillars Of Innovation
  • Should you switch to Snowflake?
  • Snowflake – Whiteboard Session
  • SnowPark Customer Results
  • Data Loading Basics
  • Snowflake 101 Community Page
  • Snowflake Data Warehouse 101
  • Virtual Warehouses Documentation
  • Snowflake 101: How To Setup Snowflake For Efficient Data Warehousing

Courses I’m Taking

  • LinkedIn – Introduction to Snowflake 1.5 hours
  • Snowflake Masterclass[stored proc+demos+Best practices+Labs] 14 hours
  • Ultimate SnowPro Core Certification Course & Exam – 7 Hours
  • Snowflake Snowpro Core: Certification Exam Questions COF-C02
  • Cloud Academy – Intro to Snowflake and Snowflake Architecture
  • aCloudGuru – “All Things Python”
  • aCloudGuru – AWS Architect Series

Snowflake Competitive

  • Gartner – Snowflake Data Cloud Alternatives
  • Redshift Versus Snowflake – 6 Key Differences
  • DB Engines – Databricks vs. Google BigQuery vs. Snowflake
  • Video – Snowflake Vs Databricks
  • Video – Snowflake vs BigQuery | What’s Different?

Back to Basics

  • SQL 101-SQLBolt
  • SQL Intro
  • SQL Tutorial for Beginners
  • SQL Tutorial – Geeks 4 Geeks
  • SQL database functions
  • Python Intro
  • Extract, Load, Transform (ELT) ELT and ETL
  • Column-Oriented DBMS or Columnar DBMS

Recent Posts

  • Install Kubernetes on Ubuntu 24.4
  • Install SnowSQL
  • When I’m Not Working
  • Snowpark-optimized Warehouses
  • Impact on Data Loading – Increasing Warehouse Size?

Copyright © 2025 Scotty's Tech Hangout!

Design by ThemesDNA.com