Home Page Icon
Home Page
Table of Contents for
Snowflake: The Definitive Guide
Close
Snowflake: The Definitive Guide
by
Snowflake: The Definitive Guide
1. Creating and Managing Snowflake Architecture
Snowflake Architecture
Shared-Disk (Scalable) Data Warehouse Architecture
Shared-Nothing (Scalable) Data Warehouse Architecture
NoSQL Alternatives
Snowflake’s Hybrid Columnar Architecutre
Managing the Cloud Services Layer
Billing for the Cloud Services Layer
Query Processing (Virtual Warehouse) Compute Layer
Warehouse Size
Scaling Up a Virtual Warehouse to Process Large Data Volumes and Complex Queries
Scaling Out with Multi-Cluster Warehouses to Maximize Concurrency
Creating and Using Virtual Warehouses
Separation of Workloads and Workload Management
Billing for Virtual Warehouse Layer
Centralized (Hybrid-Columnar) Database Storage Layer
Introduction to Zero Copy Cloning
Introduction to Time Travel
Billing for Storage Layer
Snowflake Caching
Query Results Cache
Metadata Cache
Virtual Warehouse Local Disk Cache
Get Ready for Hands-On Learning
Exercises to Test Your Knowledge
2. Creating and Managing Snowflake Architecture Objects
Creating and Managing Snowflake Databases
Creating and Managing Snowflake Schemas
INFORMATION_SCHEMA and Account Usage
Introduction to Snowflake Tables
Creating and Managing Views
Introduction to Snowflake Stages – File Format Included
Extending SQL with Stored Procedures and UDFs
User Defined Function (UDF) – Task Included
Secure SQL UDF That Returns Tabular Value (Market Basket Analysis Example)
Stored Procedures
Other
Code Cleanup
Exercises to Test Your Knowledge
Search in book...
Toggle Font Controls
Playlists
Add To
Create new playlist
Name your new playlist
Playlist description (optional)
Cancel
Create playlist
Sign In
Email address
Password
Forgot Password?
Create account
Login
or
Continue with Facebook
Continue with Google
Sign Up
Full Name
Email address
Confirm Email Address
Password
Login
Create account
or
Continue with Facebook
Continue with Google
Next
Next Chapter
Snowflake: The Definitive Guide
Add Highlight
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click
here
login for view all page.
Day Mode
Cloud Mode
Night Mode
Reset