Jumpstart Snowflake : a step-by-step guide to modern cloud analytics /: a step-by-step guide to modern cloud analytics. (2020)

• Record Type: Book
• 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: 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
• 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.