Jumpstart Snowflake : a step-by-step guide to modern cloud analytics /: a step-by-step guide to modern cloud analytics. (2020)
- Record Type:
- Book
- Title:
- Jumpstart Snowflake : a step-by-step guide to modern cloud analytics /: a step-by-step guide to modern cloud analytics. (2020)
- Main Title:
- Jumpstart Snowflake : a step-by-step guide to modern cloud analytics
- Further Information:
- Note: Dmitry Anoshin, Dmitry Shirokov, Donna Strok.
- Other Names:
- Anoshin, Dmitry
Shirokov, Dmitry
Strok, Donna - Contents:
- Intro -- Table of Contents -- About the Authors -- Acknowledgments -- Chapter 1: Getting Started with Cloud Analytics -- Time to Innovate -- Key Cloud Computing Concepts -- Meet Snowflake -- Summary -- Chapter 2: Getting Started with Snowflake -- Planning -- Deciding on a Snowflake Edition -- Choosing a Cloud Provider and Region -- Examining Snowflake's Pricing Model -- Other Pricing Considerations -- Examining Types of Snowflake Tools -- Snowflake Web Interface -- SnowSQL -- JDBC and ODBC OS Platform Requirements -- Third-Party Partners -- Creating a Snowflake Account Connecting to Snowflake -- Logging Into the Snowflake Web Interface -- Touring the Web Interface -- Databases Page -- Warehouses Page -- Shares Page -- Worksheets Page -- History Page -- Partner Connect Page -- Help Menu -- User Preferences Menu -- Summary -- Chapter 3: Building a Virtual Warehouse -- Overview of Snowflake Virtual Warehouses -- Warehouse Sizes and Features -- Choosing the Right Size -- Concurrency -- Default Virtual Warehouses in Sessions -- Multicluster Virtual Warehouses -- Overview of Multicluster Virtual Warehouses -- Multicluster Credits and Usage Virtual Warehouse Considerations -- Query Design -- Caching Impacts -- Scaling -- Building a Snowflake Virtual Warehouse -- Creating a Virtual Warehouse -- Starting, Resuming, Suspending, and Resizing -- Using a Warehouse -- Setting Up Load Monitoring -- Understanding Load Monitoring -- Best Practices for Load Monitoring -- Summary -- Chapter 4:Intro -- Table of Contents -- About the Authors -- Acknowledgments -- Chapter 1: Getting Started with Cloud Analytics -- Time to Innovate -- Key Cloud Computing Concepts -- Meet Snowflake -- Summary -- Chapter 2: Getting Started with Snowflake -- Planning -- Deciding on a Snowflake Edition -- Choosing a Cloud Provider and Region -- Examining Snowflake's Pricing Model -- Other Pricing Considerations -- Examining Types of Snowflake Tools -- Snowflake Web Interface -- SnowSQL -- JDBC and ODBC OS Platform Requirements -- Third-Party Partners -- Creating a Snowflake Account Connecting to Snowflake -- Logging Into the Snowflake Web Interface -- Touring the Web Interface -- Databases Page -- Warehouses Page -- Shares Page -- Worksheets Page -- History Page -- Partner Connect Page -- Help Menu -- User Preferences Menu -- Summary -- Chapter 3: Building a Virtual Warehouse -- Overview of Snowflake Virtual Warehouses -- Warehouse Sizes and Features -- Choosing the Right Size -- Concurrency -- Default Virtual Warehouses in Sessions -- Multicluster Virtual Warehouses -- Overview of Multicluster Virtual Warehouses -- Multicluster Credits and Usage Virtual Warehouse Considerations -- Query Design -- Caching Impacts -- Scaling -- Building a Snowflake Virtual Warehouse -- Creating a Virtual Warehouse -- Starting, Resuming, Suspending, and Resizing -- Using a Warehouse -- Setting Up Load Monitoring -- Understanding Load Monitoring -- Best Practices for Load Monitoring -- Summary -- Chapter 4: Loading Bulk Data into Snowflake -- Overview of Bulk Data Loading -- What Is Bulk Data Loading? -- Bulk Load Locations -- Supported File Formats and Encoding -- Compression Handling -- Encryption Options -- Bulk Data Loading Recommendations File Preparation -- File Sizing -- File Splitting -- CSV File Preparation -- Semistructured Data File Preparation -- File Staging -- Loading -- Querying Staged Files -- Bulk Loading with the Snowflake Web Interface -- Summary -- Chapter 5: Getting Started with SnowSQL -- Installing SnowSQL -- Configuring SnowSQL -- Connection Settings -- Configuration Variables -- Configuration File Example -- Command-Line Example -- Executing Variables in an Active Session -- SnowSQL Commands -- Multiple Connection Names -- Data Loading with SnowSQL -- Summary -- Chapter 6: Continuous Data Loading with Snowpipe Loading Data Continuously -- Snowpipe Auto-Ingest -- Building a Data Pipeline Using the Snowpipe Auto-Ingest Option -- Snowpipe REST API Using AWS Lambda -- Summary -- Chapter 7: Snowflake Administration -- Administering Roles and Users -- Enforcement Model -- Working with Roles and Users -- Administering Resource Consumption -- Virtual Warehouse Usage -- Data Storage Usage -- Data Transfer Usage -- Administering Databases and Warehouses -- Managing Warehouses -- Managing Databases -- Zero-Copy Cloning -- Administering Account Parameters -- Administering Database Objects … (more)
- Publisher Details:
- Berkeley, CA : Apress L.P
- Publication Date:
- 2020
- Extent:
- 1 online resource (270 pages)
- Subjects:
- 005.74/5
Data warehousing
Cloud computing
Cloud computing
Data warehousing
Electronic books - Languages:
- English
- ISBNs:
- 9781484253281
1484253280 - Related ISBNs:
- 9781484253274
- Notes:
- Note: Print version record.
- Access Rights:
- Legal Deposit; Only available on premises controlled by the deposit library and to one user at any one time; The Legal Deposit Libraries (Non-Print Works) Regulations (UK).
- Access Usage:
- Restricted: Printing from this resource is governed by The Legal Deposit Libraries (Non-Print Works) Regulations (UK) and UK copyright law currently in force.
- View Content:
- Available online (eLD content is only available in our Reading Rooms) ↗
- Physical Locations:
- British Library HMNTS - ELD.DS.480479
- Ingest File:
- 03_031.xml