Snowflake is cloud based data warehouse and analytical tool. With so many SAAS based Data warehouse applications available currently that are competing against one another, Snowflake stands out among the crowd for it uniqueness in design and approach. Snowflake works on an application that is faster and easier to handle. Unlike other data warehouse systems Snowflake is not built on Big data platforms rather it works on new SQL engine that is best suited for cloud.
Snowflake is cloud based data warehouse and analytical tool. With so many SAAS based Data warehouse applications available currently that are competing against one another, Snowflake stands out among the crowd for it uniqueness in design and approach. Snowflake works on an application that is faster and easier to handle. Unlike other data warehouse systems Snowflake is not built on Big data platforms rather it works on new SQL engine that is best suited for cloud. Having one of the best ACID (atomicity, consistency, isolation, and durability) complaint solutions. One of the USPs of Snowflake’s unique capabilities is in its table structures wherein Micro–Partitions and Data–Clustering are adopted Snowflake allows user to “time travel” i.e., track data changes overtime and view changes made anytime in the past up to a 90–days Some of the other features of Snowflake are
- Cloning – the clone feature create instant copy of any snowflake object
- Undrop – any dropped object (Databases, schemas, tables etc) can be undroped
- Fail safe – In the event of any disaster like hardware or disk failures. Snowflake engineers can recover the data upto a 7 day period post failure
Analytics Solution – Snowflake architecture helps in dealing with data and analytics alongside with data warehousing capabilites
Things You Will Learn
Snowflake is an analytic data warehouse provided as Software-as-a-Service (SaaS). Snowflake provides a data warehouse that is faster, easier to use, and far more flexible than traditional data warehouse offerings.
Snowflake’s data warehouse is not built on an existing database or “big data” software platform such as Hadoop. The Snowflake data warehouse uses a new SQL database engine with a unique architecture designed for the cloud. To the user, Snowflake has many similarities to other enterprise data warehouses, but also has additional functionality and unique capabilities.
Snowflake’s data warehouse is a true SaaS offering. More specifically:
- There is no hardware (virtual or physical) for you to select, install, configure, or manage.
- There is no software for you to install, configure, or manage.
- Ongoing maintenance, management, and tuning is handled by Snowflake.
Snowflake runs completely on cloud infrastructure. All components of Snowflake’s service (other than an optional command line client), run in a public cloud infrastructure.
Snowflake uses virtual compute instances for its compute needs and a storage service for persistent storage of data. Snowflake cannot be run on private cloud infrastructures (on-premises or hosted).
Snowflake is not a packaged software offering that can be installed by a user. Snowflake manages all aspects of software installation and updates.
- Data warehousing: past to present
- Understanding the benefits of a cloud data warehouse
- Recognizing where cloud data warehousing fits in today’s economy
- 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
- Choosing the right data warehouse solution
- Getting a high performance-to-price ratio
- Making data security and protection a priority
- 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
- 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
- Key Concepts & Architecture
- Cloud Platforms
- Snowflake Editions
- Overview of Key Features
- Overview of the Data Lifecycle
- Continuous Data Protection
- 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
- 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 the Web Interface
- Virtual Warehouses
- Databases, Tables & Views
- Date & Time Data
- Semi-structured Data
- Binary Data
- Snowflake Time Travel & Fail-safe
- 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
- 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
- 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
- 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
Frequently asked questions
The trainer will give Server Access to the course seekers, and we make sure you acquire practical hands-on training by providing you with every utility that is needed for your understanding of the course.
In case you are not able to attend any lecture, you can view the recorded session of the class in Icronix . To make things better for you, we also provide the facility to attend the missed session in any other live batch.
The trainer is a certified consultant and has significant amount of experience in working with the technology.
Yes, we accept payments in two installments.
If you are enrolled in classes and/or have paid fees, but want to cancel the registration for certain reason, it can be attained within first 2 sessions of the training. Please make a note that refunds will be processed within 30 days of prior request.