Snowflake Platform Training
Duration
4 Hours
Level
Basic Level
Design and Tailor this course
Official Course
Overview
Snowflake Platform Training is a live, step-by-step training seminar on the AI Data Cloud led by Snowflake’s expert instructors. They will explain the Snowflake AI Data Cloud architecture, while interactive labs provide guided experience in unifying, integrating, and sharing previously siloed data with virtually unlimited scalability and concurrency. You will follow the training with access to a curated Snowflake account and have the opportunity to get your questions answered by the instructors.
ACQUIRED SKILLS
- Set up and navigate the Snowflake user interface, emphasizing Snowflake Notebooks.
- Create database and compute resources.
- Create stages.
- Load and leverage shared data securely.
- Call Snowflake Cortex LLM functions to provide generative AI capabilities on your data in Snowflake.
Audience
Snowflake Platform Training has been designed for individuals with limited experience using Snowflake who want to get started and accelerate their knowledge of the AI Data Cloud – including IT managers, Data Architects, Engineers, Scientists, Administrators, and Developers.
Prerequisites
- Basic database knowledge.
Curriculum
- Snowsight User Interfaces
- Snowflake Notebook Capabilities
- Running SQL Cells
- Running Python Cells
- Python Variable Substitution
- Create a New Database
- Explore your Database
- Databases and Schemas
- Transfer Ownership
- Object Access by Role
- Snowsight Object Browsers
- How to Run Your Code
- SHOW Commands
- Query Data in Snowflake
- Create a Table
- Locate Tables
- View Table Definitions
- Insert Data
- SELECT and LIMIT
- What is a Virtual Warehouse in Snowflake?
- Virtual Warehouse Sizing Recommendations
- Resizing Virtual Warehouses
- Context Settings
- Alternatives to the INSERT Statement
- Load Data From a File
- View Table Data
- Clone a Table
- Snowflake Marketplace
- Private Sharing with Data Exchange
- Use INFORMATION_SCHEMA to Query Metadata
- Check Your Lab Work
- Access Query History in Snowsight
- Use Time Travel
- Use the LIST Command
- Use the COPY INTO Command to Load Data
- Data Loading Tips and Tricks
- Work With Semi-structured Data
- Unstructured Data
- Directory Tables
- Introducing Snowflake Cortex AI
- PARSE_DOCUMENT Function
- Text Extraction Workflow
- CLASSIFY_TEXT Function
- Streamlit in Snowflake
- COMPLETE Function
Duration
4 Hours
Level
Basic Level
Design and Tailor this course
Official Course
