As Snowflake's capabilities expand, staying updated with its latest features and functionalities can be overwhelming. The platform's rapid development gave rise to advanced tools like Snowpark and the Native App Framework, which are crucial for optimizing data operations but may seem complex to navigate.

In this essential book, author Muhammad Fasih Ullah offers a detailed guide to understanding these sophisticated tools, ensuring you can leverage the full potential of Snowflake for data processing, application development, and deploying machine learning models at scale. You'll gain actionable insights and structured examples to transform your understanding and skills in handling advanced data scenarios within Snowflake. By the end of this book, you will:

• Grasp advanced features such as Snowpark, Snowflake Native App Framework, and Iceberg tables
• Enhance your projects with geospatial functions for comprehensive geospatial analytics
• Interact with Snowflake using a variety of programming languages through Snowpark
• Implement and manage machine learning models effectively using Snowpark ML
• Develop and deploy applications within the Snowflake environment

Osoby które kupowały "Advanced Snowflake", wybierały także:

• Jak zhakowa 125,00 zł, (10,00 zł -92%)
• Windows Media Center. Domowe centrum rozrywki 66,67 zł, (8,00 zł -88%)
• PLC i TIA Portal. Kurs video. Techniki programowania SIMATIC S7-1200 230,00 zł, (29,90 zł -87%)
• PLC i TIA Portal. Kurs video. Logika sterowania w automatyce przemys 230,00 zł, (29,90 zł -87%)
• Matematyka a programowanie. Kurs video. Od pojęcia liczby po płaszczyznę zespoloną w Pythonie 142,14 zł, (19,90 zł -86%)

Spis treści

Advanced Snowflake eBook -- spis treści

• Preface
  • Who Should Read This Book
  • Navigating This Book
  • Conventions Used in This Book
  • Using Code Examples
  • OReilly Online Learning
  • How to Contact Us
  • Acknowledgments
• 1. Getting Started and Setting Up the Environment
  • Introduction to Snowflakes New UI (Snowsight)
    • Search
    • Projects
    • Data
    • Data Products
    • AI & ML
    • Monitoring
    • Admin
  • Introduction to Snowflake Worksheets
    • SQL Worksheets
    • Python Worksheets
  • Setting Up the SQL Environment
  • Setting Up the Snowpark/Python Environment
  • Summary
• 2. Snowflake Overview
  • Snowflake Architecture
    • Storage Layer
    • Compute Layer
    • Cloud Services Layer
    • Cloud-Agnostic Layer
  • Optimized Storage Layer Features
    • Compression and Micro-Partitions
    • Semi-Structured and Unstructured Data
    • Time Travel
    • Zero-Copy Clone
  • Compute Layer Features
    • Standard Virtual Warehouses
    • Snowpark-Optimized Warehouses
  • Cloud Services Layer Features
    • Metadata
    • Optimization
    • Infrastructure Management
    • Security and Governance
    • Sharing and Collaboration
    • Serverless Features
  • Snowflake Objects
    • Databases
    • Schemas
    • Tables
      • Dynamic tables
      • Hybrid tables/Unistore
      • Iceberg tables
    • Views
      • Secure views
      • Materialized views
    • User-Defined Functions
      • Scalar functions
      • Table functions
      • User-defined aggregate functions
      • External functions
    • Stored Procedures
    • Shares and Secure Data Sharing
    • Streams
    • Tasks
    • Stages
    • Pipe
    • Application
  • Summary
• 3. Snowflake SQL
  • Order of Execution
  • Advanced Snowflake Functions
    • Aggregate Functions
      • ANY_VALUE
      • MIN_BY
      • MAX_BY
      • BOOLAND_AGG
      • BOOLOR_AGG
      • BOOLXOR_AGG
    • Window Functions
      • ROW_NUMBER()
      • RANK() / DENSE_RANK()
      • FIRST_VALUE() / LAST_VALUE()
      • LAG()/LEAD()
  • Snowflake Geospatial
    • Geospatial Data Types
    • Snowflake Geospatial Functions
    • Constructor Functions
      • ST_MAKEGEOMPOINT/ST_GEOMPOINT
      • ST_MAKEPOINT/ST_POINT
      • ST_MAKELINE
      • ST_MAKEPOLYGON/ST_POLYGON
    • Transformer Functions
      • ST_CENTROID
      • ST_COLLECT (Scalar and Aggregate)
      • ST_INTERSECTION
      • ST_UNION
    • Measurement and Relationship Functions
      • ST_AREA
      • ST_CONTAINS
      • ST_DISTANCE
      • ST_DWITHIN
      • ST_INTERSECTS
    • Snowflake and H3
      • H3_POINT_TO_CELL/H3_POINT_TO_CELL_STRING
      • H3_CELL_TO_BOUNDARY
  • Summary
• 4. Snowpark
  • Why Snowpark?
  • Snowpark Key Features
    • DataFrame API
    • Reduced Data Transfer
    • Inline UDFs
  • Snowflake ML
    • Snowflake + Anaconda
    • Snowflake Feature Store
    • Snowflake Datasets
    • Snowflake Model Registry
  • Hands-on Example 1: Connecting to a Snowpark Session
  • Hands-on Example 2: Creating UDFs Using Snowpark
    • Anonymous UDFs
    • Named Temporary UDFs
    • Named Permanent UDFs
    • Anonymous UDF Solution
  • Summary
• 5. Snowflake Developer Ecosystem and Native Application Framework
  • Core Components of the Developer Ecosystem
    • Snowpark
    • User-Defined Functions
    • Stored Procedures
    • External Functions
    • Native Application Framework
    • Developer Tools
      • Snowflake CLI
      • VS Code extension
      • Snowflake web interface (Snowsight)
      • Snowflake Marketplace
  • Snowflake Native Application Framework
  • Snowpark Container Services
    • Fundamentals of Snowpark Container Services
    • Executing Containers on Snowpark Container Services
  • Streamlit in Snowflake
  • Hands-on Example: Build and Deploy a Snowflake Native App with Streamlit to Snowflake
  • Summary
• 6. Snowflake for AI and ML
  • Snowflake Notebooks
  • Snowflake Cortex
    • Snowflake Cortex LLM Functions
    • Snowflake Cortex Analyst
    • Snowflake Cortex Fine-Tuning
    • Snowflake Cortex Search
    • Document AI
    • Snowflake Copilot
  • Hands-on Example: End-to-End Machine Learning with Snowflake
  • Summary
• 7. Whats Next?
  • Snowflake Generation 2 Warehouses
  • Snowflake Adaptive Compute
  • Snowflake Openflow
  • Snowsight Workspaces
  • dbt Projects on Snowflake
  • Snowflake Cortex AISQL
  • Closing Remarks
• Index