1.

Record Nr.

UNINA9910808907703321

Autore

Coffing Tom

Titolo

Snowflake Architecture and SQL

Pubbl/distr/stampa

Middletown : , : Coffing Publishing, , 2022

©2022

ISBN

9781940540566

Edizione

[1st ed.]

Descrizione fisica

1 online resource (176 pages)

Soggetti

Data warehousing

Cloud computing

Lingua di pubblicazione

Inglese

Formato

Materiale a stampa

Livello bibliografico

Monografia

Nota di contenuto

Cover -- Title Page -- The Tera-Tom Video Series -- The Tera-Tom Genius Series -- Tera-Tom- Author of over 85 Books -- The Best Query Tool Works on all Systems -- Trademarks and Copyrights -- About Tom Coffing -- About David Cook -- Contents -- Chapter 1 - Getting Started with a Snowflake Trial Account --   How to Create a Starter Account on Snowflake --   Click on the START FOR FREE Menu Item --   Start Your 30-Day Free Trial --   Choose Your Edition of Snowflake and Cloud Provider --   You’re Now Signed Up – An Email Will Arrive Soon --   Take the Snowflake Email and CLICK TO ACTIVATE --   Click the Snowflake Link to Enter a Username and Password --   Welcome to Snowflake Message Comes Up --   Snowflake Browser and Query Tool --   Snowflake Worksheet to Create and Run Queries --   Script to Create the Database, Schema, Tables, and Views --   Choose the COURSE OUTLINE Button for Snowflake --   Press on Download Snowflake Class Database Script Button --   Copy All of the Text From Your SnowflakeClass.Txt Script --   Run Your Script on the Snowflake Website – First Way --   Copy Your Script to the Snowflake Website – Alternative Way --   Run Your Script on the Snowflake Website – Alternative Way --   Your Systems Tree will Contain the Nexus Database --   The SQL_CLASS Schema Contains Your Tables

Sommario/riassunto

The book provides a comprehensive guide on utilizing Snowflake, a cloud-based data warehouse solution. It covers the creation and



management of Snowflake accounts, configuring virtual warehouses, and understanding its unique architecture including compute and storage scaling. The book also explores advanced features like data sharing, caching, and performance tuning using cluster keys. It offers practical steps for data ingestion and migration, leveraging Snowflake’s capabilities for efficient data management. The author, an experienced professional in data warehousing, aims to equip users—ranging from beginners to advanced IT professionals—with the skills needed to effectively implement and manage Snowflake solutions in various cloud environments.