دسترسی نامحدود
برای کاربرانی که ثبت نام کرده اند
دانلود کتاب Snowflake Essentials: Getting Started with Big Data in the Cloud
دانلود کتاب ملزومات Snowflake: شروع به کار با داده های بزرگ در فضای ابری
مشخصات کتاب
Snowflake Essentials: Getting Started with Big Data in the Cloud
ویرایش: نویسندگان: Frank Bell, Raj Chirumamilla, Bhaskar B. Joshi, Bjorn Lindstrom, Ruchi Soni, Sameer Videkar سری: ISBN (شابک) : 148427315X, 9781484273159 ناشر: Apress سال نشر: 2021 تعداد صفحات: 347 زبان: English فرمت فایل : PDF (درصورت درخواست کاربر به PDF، EPUB یا AZW3 تبدیل می شود) حجم فایل: 15 مگابایت
قیمت کتاب (تومان) : 87,000
در صورت ایرانی بودن نویسنده امکان دانلود وجود ندارد و مبلغ عودت داده خواهد شد
در صورت تبدیل فایل کتاب Snowflake Essentials: Getting Started with Big Data in the Cloud به فرمت های PDF، EPUB، AZW3، MOBI و یا DJVU می توانید به پشتیبان اطلاع دهید تا فایل مورد نظر را تبدیل نمایند.
توجه داشته باشید کتاب ملزومات Snowflake: شروع به کار با داده های بزرگ در فضای ابری نسخه زبان اصلی می باشد و کتاب ترجمه شده به فارسی نمی باشد. وبسایت اینترنشنال لایبرری ارائه دهنده کتاب های زبان اصلی می باشد و هیچ گونه کتاب ترجمه شده یا نوشته شده به فارسی را ارائه نمی دهد.
توضیحاتی درمورد کتاب به خارجی
فهرست مطالب
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
