Snowflake

Getting Up To Speed On Cloud Data Warehousing

Data warehousing: past to present

Understanding the benefits of a cloud data warehouse

Recognizing where cloud data warehousing fits in today’s economy

Why The Modern Data Warehouse Emerged

Adapting to increasing demands for data access and analytics

Adjusting to how data is created and used today

Tackling the challenges with new and improved technologies

The Criteria For Selecting A Modern Data Warehouse

Choosing the right data warehouse solution

Getting a high performance-to-price ratio

Making data security and protection a priority

Comparing Cloud Data Warehouse Solutions

Evaluating differences between cloud data warehouse options

Considering factors that affect performance

Choosing a solution that ensures data protection and security

Gauging your savings in administrative costs

Six Steps To Getting Started With Cloud Data Warehousing

Listing your data warehouse needs and success criteria

Considering all factors in the total cost of ownership

Taking your data warehouse for a test drive before you buy

Introduction To Snowflake

Key Concepts & Architecture

Cloud Platforms

Snowflake Editions

Overview of Key Features

Overview of the Data Lifecycle

Continuous Data Protection

Connecting To Snowflake

Overview of the Ecosystem

SnowSQL (CLI Client)

Installing SnowSQL

Configuring SnowSQL

Connecting Through SnowSQL

Using SnowSQL

JDBC Driver

Downloading / Integrating the JDBC Driver

Configuring and Using the JDBC Driver

JDBC Driver Diagnostic Service

ODBC Driver

Downloading the ODBC Driver

Installing and Configuring the ODBC Driver for Windows

ODBC Configuration and Connection Parameters

ODBC Driver API Support

ODBC Driver Diagnostic Service

Client Considerations

Diagnosing Common Connectivity Issues

Loading / Unloading Data Into/From Snowflake

Overview of Data Loading/Unloading

Data Loading/Unloading Considerations

Preparing to Load/Unload Data

Bulk Loading/Unloading from a Local File System

Bulk Loading/Unloading from Amazon S3

Bulk Loading /Unloading from Microsoft Azure

Loading Continuously Using Snowpipe

Loading Using the Web Interface (Limited)

Querying Data in Staged Files

Querying Metadata for Staged Files

Transforming Data During a Load

Using Snowflake

Using the Web Interface

Virtual Warehouses

Databases, Tables & Views

Queries

Date & Time Data

Semi-structured Data

Binary Data

Snowflake Time Travel & Fail-safe

Sharing Data In Snowflake

Introduction to Data Sharing

Data Providers

Getting Started with Data Sharing

Working with Shares

Using Secure Objects to Control Data Access

Managing Reader Accounts

Configuring a Reader Account

Data Consumers

Managing Your Snowflake Account

System Usage & Billing

Understanding Snowflake Credit and Storage Usage

Understanding Snowflake Data Transfer Billing

Monitoring Account-level Credit and Storage Usage

Working with Resource Monitors

Parameter Management

User Management

Customer Specific Topics

Informatica Cloud Services and Snowflake Integration

Introduction to Snowflake Connector

Snowflake Connector Task and Object Types

Informatica Cloud Hosted Agent

Snowflake Connections

Snowflake Connection Properties

Mappings and Mapping Configuration Tasks with Snowflake Connector

Snowflake Objects in Mappings

Pushdown Optimization

Snowflake Sources in Mappings

Key Range Partitioning

Snowflake Targets in Mappings

Snowflake Lookups in Mappings

Rules and Guidelines for Snowflake objects