Snowflake Essentials: Getting Started with Big Data in the Cloud

Table of Contents
About the Authors
About the Technical Reviewers
Foreword
Chapter 1: The Snowflake Data Cloud
	Big Data Cloud History
	Snowflake Beginnings
	Why the Snowflake Data Cloud Is Different
	Snowflake’s Unique Architecture
	Snowflake’s Unique Platform Features
		The Separation of Compute from Storage
			Cloud-Backed Availability
			Cloud-Enabled Scale
			Snowflake Compression
		Automated Data Maintenance and Scaling
		Ease of Use
			SQL Is Well Known
			Joining Enterprise Data Is Easy
			Viewing Past Versions Is Built In
		Speed. Speed. More Speed Please
		Data Sharing
	Timeline of the Snowflake Data Cloud Creation
	Summary
Chapter 2: Snowflake Quick Start
	Creating a Snowflake Account
	Choosing a Snowflake Edition
	Snowflake Editions Overview
	Selecting a Cloud Provider and Region
		Choosing a Cloud Provider
		Choosing a Region
		Understanding Snowflake Edition Pricing
	Immediately Connecting to Snowflake
		Initial Web View
		Initial Snowflake Account URL
		The Snowflake Web Interface
	Summary
Chapter 3: Snowflake Data Cloud Architecture
	The Snowflake Data Platform as a Cloud Service
	Big Data Architecture History
		Snowflake’s Hybrid Architecture
		The Data Warehouse Evolution
	Snowflake’s Layered Architecture
	Cloud Services Layer
	Compute Layer
	Storage Layer
	The Separation of Storage from Compute
	Micropartitions and Their Use in Snowflake
	How Pruning Works
	Cluster Keys
		Cluster Keys and Automated Clustering in Snowflake
		Reclustering for Optimization
	Snowflake’s Caching Architecture
	The Benefits of Cloning
	Performance Optimization Features
		Materialized Views
		Automated Clustering on Cluster Keys
		Search Optimization Service
	Summary
Chapter 4: Snowflake Web Interface: Classic Console
	Web Interface: Classic Console Main Overview
		Databases
			Tables
			Views
			Schemas
			Stages
			File Formats
			Sequences
			Pipes
		Shares
		Data Marketplace
		Warehouses (Named “Compute Warehouses” on the Preview App)
		Worksheets
		History
		Partner Connect
		Help
		Notifications
		Account
			Usage
			Billing
			Roles
			Policies
			Sessions
			Resource Monitors
			Reader Accounts
	Summary
Chapter 5: Snowflake Web Interface: Preview App (Snowsight)
	Web Interface: Preview App (Snowsight) Main Overview
		Initial Preview App (Snowsight) Login
		Enabling the Preview App (Snowsight)
		Worksheets
		Initial Preview App (Snowsight) Role Selection
		Overall Navigation Pane
		Dashboards
		Data
			Databases
			Shared Data
			Data Marketplace
		Compute
			Query History
			Warehouses
			Resource Monitors
		Account
			Usage
			Roles
			Users
			Security
		Snowsight Additional Navigation
	Summary
Chapter 6: Account Management
	Traditional Database Administration
	The Snowflake Paradigm
	Risk Mitigation
	Knobs, Levers, and Switches
	Security Administration
		Network Protection
		Single Sign-On
		Data Protection
		User Login Management
	Monitoring Your Usage
		Storage Costs
		Compute Cluster Costs
			Parameters
			Resource Monitors
		Replication and Cloud Compute Costs
		Ad Hoc Query Monitoring
	Summary
Chapter 7: Security
	Security Basics
		Firewalls
		Keeping Up-to-Date
		Antivirus
		Phishing
		Passwords
		Emails with URLs
		Unlocked Devices
		Using PINs
		Protect Data
		Backups with Snowflake
		Encrypted Communications
		Social Media
		Social Engineering
		Monitor Accounts
	Creating Users
		Basic Login Administration
			Username and Login Name
			Identifying Information
			Authentication Method
			User Default Settings
		Snowflake User Creation
		User Ownership
	User Login Authentication
		Password Resets
		Authentication Alternatives
	User Roles
	Object Permissions
	Securing Network Access
	Encryption
		Data in Motion
		Data at Rest
	Data Protection
		Encrypted Stages
			Securing the Storage Area
			Encrypting Storage Locations
		Cloning
		Data Masking and Row-Level Security
			Dynamic Data Masking
			Row Access Policies
	Summary
Chapter 8: Database Objects
	Warehouses
	Roles
	Databases
	Schemas
	Tables
		Data Types
	Constraints
	Clustered Keys
	Views
	Stored Procedures and User-Defined Functions
	Sequences
	Stages
	File Formats
	Pipes
	External Tables
	Tasks
	Summary
Chapter 9: Querying and Cloning Data in Snowflake
	SQL Basics
		Joins
		Subquery
		Common Table Expression (CTE)
		GROUP BY and HAVING
		Time Travel
		ORDER BY
		MATCH_RECOGNIZE
	Using SQL in Snowflake Worksheets
		Setting the Context of Your SQL Queries
		Executing SQL Queries
	How to Use Standard SQL Window Functions
	Nonstandard SQL
	Advanced Worksheet Sharing and Collaboration with Snowsight
		Worksheet and Dashboard Sharing
		Advanced Query Features
	Exporting SQL Data Result Sets
	Query Profile Overview
	Query History
	Cloning
		Cloning Syntax
		Cloning with Time Travel
		Cloning Considerations
	Summary
Chapter 10: How Snowflake Compute Works
	Snowflake Compute Warehouses
		How Snowflake Warehouses Really Work
			Snowflake Warehouse in the Snowflake UI
			Snowflake UI for the Creation and Management of a Warehouse
			Sample Code for the Creation and Management of a Warehouse
	Snowflake Warehouse Sizes
	Snowflake Multi-clustering
		Multi-clustering Settings
	Snowflake Compute Strategies
		Scaling Out
		Scaling Up: Spilling
		Scaling Up vs. Scaling Out
	Monitoring Snowflake Compute (Warehouses)
		Resource Monitors
			How to Set Up a Single Resource Monitor: UI and Code
		Options Available to Monitor and Control Snowflake Compute Costs
			Manually Create Resource Monitors with Suspend Enabled
			Automate Resource Monitor Creation with Suspend Enabled
			Custom Code – Internal or External to Snowflake
			Automated Cost Optimization Services such as Snoptimizer
		Cost Optimization Best Practice Queries
			Analyze Credits Used by Warehouse Overall
			Analyze Credits Used by Warehouse – Last 7 Days
			Analyze Credits Used by Warehouse
	Summary
Chapter 11: Semi-structured Data in Snowflake
	Semi-structured Data Type in Snowflake
	How the Variant Data Type Works
	How to Load JSON Data
	How to Query JSON Data
	How to Create a View on JSON Data
	How to Perform a Join Operation on a View
	How to Use the Flatten Command
	Summary
Chapter 12: Loading Data
	Snowflake Object Hierarchy
		Stage
		File Format
	Public Dataset
		Download the Dataset
	Loading Data into Snowflake via Web UI
		Log In to Your Snowflake Account
		Create a Database
		Create a Schema
		Create a Table
		Load Table
			Select a Warehouse
			Select Source File(s)
			Create a File Format
			Error Handling
			Verify the Results
	Drop and Recreate Objects
		Drop Objects
		Recreate Objects
	PUT and COPY Commands
		PUT Command
		COPY into  Command
	Loading Data via SnowSQL
		Download SnowSQL
		Install SnowSQL
		Log In and Set Context
		List Files from Internal Stage
		Stage Files with the PUT Command
		Load Data with the COPY Command
		Verify the Results
	Summary
Chapter 13: Unloading Data
	Sample Dataset
	Setting Up the Context
		Log In to Your Snowflake Account
		Create a Stage
	COPY INTO  and GET Commands
		COPY INTO  Command
			Splitting into Multiple Files
		GET Command
	Unloading Data
		From a Table
		From a SQL Statement
			Verify the Results
	Download Data via SnowSQL
		Log In and Set Context
		List Files from Internal Stage
		Download Files with the GET Command
	Summary
Chapter 14: Data Sharing, Data Exchanges, and the Snowflake Data Marketplace
	Data Sharing History
		What Is Data Sharing?
		Data Copies Everywhere
		The BI Tool Extract Effect and Data Governance and Integrity Impacts
	Data Sharing on the Snowflake Data Cloud
		Snowflake Data Sharing History
		The Business Value and Power of Instantaneous Data Sharing
		Data Sharing Market Adoption
	How Data Sharing Works on Snowflake
	How to Create Data Shares and Access Data Shares on Snowflake
		How to List Snowflake Data Shares – Shared Data
		How to Create a Snowflake Data Share
			Setting Up a Data Share on the Snowflake Web Interface [Snowsight Example]
			Consumer Account: Getting Access to the New Data Share
		How to Create Reader Accounts
		Setting Up a Data Share with Code
			Data Provider Account: Data Share Setup Code
			Data Consumer Account: Data Share Access Code
			Data Provider Account: Creating Reader Accounts
			Reader Account [Also, Data Consumer] Initial Setup: Creating Limits on Reader Compute (Warehouses)
			Reader Account [Also, Data Consumer] Initial Setup: Creating Users with Only Query Access to CITIBIKE Database
	Data Exchanges
		Creating Your Own Private Data Exchange Steps
			Prerequisites for Creating a Private Data Exchange
			Private Data Exchange Setup: Snowsight
	The Snowflake Data Marketplace
		The Growth of the Snowflake Data Marketplace from June 2020 to June 2021
		How to Use the Snowflake Data Marketplace as a Consumer
			Snowflake Data Consumer Access and Navigation
			Data Share Listings: By Request Type
			Data Share Listings: Open or Free and Instant Access Type
			Data Share Access
	Summary
Index







نظرات کاربران


                        


			




    
 کتاب های تصادفی 

            

			

			

			

			            
                

				                    
                
                

                    
دانلود کتاب Knowing Our Place: Children Talking About Power, Identity and Citizenship
                                        																																																		
						 
                
            
			                        
                

				                    
                
                

                    
دانلود کتاب Нутрициология: Учебное пособие
                                        																																																		
						 
                
            
			                        
                

				                    
                
                

                    
دانلود کتاب Tennyson's Camelot: The Idylls of the King and its Medieval Sources
                                        																																																		
						 
                
            
			                        
                

				                    
                
                

                    
دانلود کتاب Complex Analysis
                                        																																				
						 
                
            
			                        
                

				                    
                
                

                    
دانلود کتاب Navigating the Intersection of Business, Sustainability and Technology (Contributions to Environmental Sciences & Innovative Business Technology)
                                        																																																		
						 
                
            
			            		
		
	
     








    
	    
        
        
	
    

    
تمامی حقوق معنوی و مادی وبسایت متعلق به اینترنشنال لایبرری می باشد