Scanning an entire table to return output for a single query is computationally intensive, so many technologies rely on partitioning tables to improve query performance for big data. Snowflake implements a form of partitioning known as micro-partitioning where all tables are automatically divided into micro-partitions that users don't need to manage. In this course, explore and execute queries using Snowflake's web interface, Snowsight. Next, learn how to create dashboards in Snowsight and add various charts. Finally, discover how permanent, temporary, and transient tables in Snowflake differ and how such tables can be created, used, and cloned. Upon completion, you'll be able to view database objects in Snowsight, run queries and build dashboards, and differentiate the types of Snowflake tables.

Snowflake is a cloud-native, managed data platform for big data storage and processing that does not require any hardware or software installation, maintenance, or upgrades and can be connected to in a variety of ways. In this course, learn how to set up a Snowflake free trial account, log into it, and navigate the classic Snowflake UI. Next, practice creating and monitoring virtual warehouses and executing DDL operations. Finally, discover how to create databases and tables, load data into tables, instantiate file format objects, and query tables. Upon completion, you'll be able to list features and use cases of Snowflake, differentiate Snowflake editions, and utilize virtual warehouses and databases to separate data and compute.

Data in Snowflake goes through a three-phase lifecycle: current data storage, where the data is stored in regular database tables; Time Travel, where you can access data from a specific time; and Fail-safe, which preserves historical data for a configurable retention period. In this course, learn how to use Time Travel to access historical data using query ID filters, relative time offsets, and absolute timestamp values. Next, practice cloning historical copies of tables into current tables and restoring dropped tables with the UNDROP command. Finally, discover how to install SnowSQL, define and use variables, and spool query results to files. Upon completion, you'll be able to utilize Time Travel and Fail-safe in Snowflake, configure SnowSQL, define and use variables, and utilize SnowSQL features.