Skip to content

Home
Posts
Conversation Starters
- OWN Company
- Snowflake
Interesting Tech Videos
- Hadoop in 5 Minutes
Links
Wiki
Vids
Snowsight Login
BigID
Privacy Links
- IAPP.Org

Scotty's Tech Hangout!

Cool stuff that I want to learn and remember!

Search for:

Tag: Lateral Join

Flattening Semi-Structured Data

November 25, 2023

Search for:

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 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 SnowSQL
When I’m Not Working
Snowpark-optimized Warehouses
Impact on Data Loading – Increasing Warehouse Size?
Copy Into

Copyright © 2024 Scotty's Tech Hangout!

Design by ThemesDNA.com