Details
Jumpstart Snowflake
A Step-by-Step Guide to Modern Cloud Analytics|
56,99 € |
|
| Verlag: | Apress |
| Format: | |
| Veröffentl.: | 20.12.2019 |
| ISBN/EAN: | 9781484253281 |
| Sprache: | englisch |
Dieses eBook enthält ein Wasserzeichen.
Beschreibungen
<p>Explore the modern market of data analytics platforms and the benefits of using Snowflake computing, the data warehouse built for the cloud.</p>
<p>With the rise of cloud technologies, organizations prefer to deploy their analytics using cloud providers such as Amazon Web Services (AWS), Microsoft Azure, or Google Cloud Platform. Cloud vendors are offering modern data platforms for building cloud analytics solutions to collect data and consolidate into single storage solutions that provide insights for business users. The core of any analytics framework is the data warehouse, and previously customers did not have many choices of platform to use. </p>
<p>Snowflake was built specifically for the cloud and it is a true game changer for the analytics market. This book will help onboard you to Snowflake, present best practices to deploy, and use the Snowflake data warehouse. In addition, it covers modern analytics architecture and use cases. It provides use cases of integration with leading analytics software such as Matillion ETL, Tableau, and Databricks. Finally, it covers migration scenarios for on-premise legacy data warehouses.<br></p>
<p><b><br></b></p><p><b>What You Will Learn</b></p>
<p></p><ul><li>Know the key functionalities of Snowflake<br></li><li>Set up security and access with cluster<br></li><li>Bulk load data into Snowflake using the COPY command<br></li><li>Migrate from a legacy data warehouse to Snowflake<br></li><li>integrate the Snowflake data platform with modern business intelligence (BI) and data integration tools</li></ul><p></p>
<p><b><br></b></p><p><b>Who This Book Is For</b></p>
<p>Those working with data warehouse and business intelligence (BI) technologies, and existing and potential Snowflake users</p>
<p>With the rise of cloud technologies, organizations prefer to deploy their analytics using cloud providers such as Amazon Web Services (AWS), Microsoft Azure, or Google Cloud Platform. Cloud vendors are offering modern data platforms for building cloud analytics solutions to collect data and consolidate into single storage solutions that provide insights for business users. The core of any analytics framework is the data warehouse, and previously customers did not have many choices of platform to use. </p>
<p>Snowflake was built specifically for the cloud and it is a true game changer for the analytics market. This book will help onboard you to Snowflake, present best practices to deploy, and use the Snowflake data warehouse. In addition, it covers modern analytics architecture and use cases. It provides use cases of integration with leading analytics software such as Matillion ETL, Tableau, and Databricks. Finally, it covers migration scenarios for on-premise legacy data warehouses.<br></p>
<p><b><br></b></p><p><b>What You Will Learn</b></p>
<p></p><ul><li>Know the key functionalities of Snowflake<br></li><li>Set up security and access with cluster<br></li><li>Bulk load data into Snowflake using the COPY command<br></li><li>Migrate from a legacy data warehouse to Snowflake<br></li><li>integrate the Snowflake data platform with modern business intelligence (BI) and data integration tools</li></ul><p></p>
<p><b><br></b></p><p><b>Who This Book Is For</b></p>
<p>Those working with data warehouse and business intelligence (BI) technologies, and existing and potential Snowflake users</p>
<p><b>Chapter 1: Cloud Analytics Market Overview</b></p>
<p>This chapter will help reader learn about the cloud analytics market and learn about key players as well as see the advantages of Snowflake.</p>
<p><b>Chapter 2: Getting Started with Snowflake</b></p>
<p>This will help to start with Snowflake. It will guide you to launch Snowflake and explain the web interface and functionality. In addition, it will provide guidance for the snowflake pricing model and available options for Virtual Warehouse.</p>
<p><b>Chapter 3: Working with Virtual Data Warehouse</b></p>
<p>This chapter will introduce the key component on snowflake – the Virtual Warehouse. The reader will learn how to work and monitor Virtual Warehouse.</p>
<p><b>Chapter 4: Loading Data into Snowflake</b></p>
<p>This chapter will show how you can bulk load data into Snowflake using COPY command.</p>
<p><b>Chapter 5: Getting started with SnowSQL</b></p>
<p>Chapter Goal: This chapter will introduce snowflake CLI tool. The reader will learn how to work with CLI tool and what he can accomplish with it.</p>
<p><b>Chapter 6: Loading Continuously Using Snowpipe</b></p>
<p>This chapter will introduce another Snowflake utility – Snowpipe. The reader will learn how to use Snowpipe and will create datapipeline in order to loading data into Snowflake.</p>
<p><b>Chapter 7: Snowflake Administration</b></p>
<p>This will guide reader who to manage Snowflake Account.</p>
<p><b>Chapter 8: Snowflake Security</b></p>
<p>This chapter will cover fundamental principles of the Snowflake security model and will guide reader in how to setup security and access with cluster.</p>
<p><b>Chapter 9:</b><b> Working with Semi Structure and Binary Data</b><b></b></p>
<p>Snowflake allows you to work with semi-structure data. This chapter will demonstrate you how to work with popular semi-structure formats like JSON, XML and AVRO. In addition, the user will learn about Binary data and to work with it at Snowflake.</p>
<p><b>Chapter 10: Working Snowflake Time Travel</b> <b>and</b> <b>Data Sharing</b></p>
<p>This chapter will introduce unique functionality of Snowflake – Time Travel. The reader will learn how and when they may need to use this functionality. In addition, the reader will learn about another unique functionality – Data Sharing.</p>
<p><b>Chapter 11: Building Modern Analytics Solution with Matillion ETL, Tableau, and Snowflake</b></p>
<p>This chapter will help users to learn about integration of Snowflake data platform with modern Business Intelligence and Data Integration tools (they are both key partners of Snowflake and leaders at the market).</p>
<p><b>Chapter 12: Snowflake for Big Data Use Cases</b></p>
<p>This chapter will show you common bigdata use cases and demonstrate how Snowflake can handle Big Data.</p>
<p><b>Chapter 13: Legacy DW migration to the Snowflake</b></p>
<p>This chapter will demonstrate migration process of legacy DW into Snowflake</p>
<p>This chapter will help reader learn about the cloud analytics market and learn about key players as well as see the advantages of Snowflake.</p>
<p><b>Chapter 2: Getting Started with Snowflake</b></p>
<p>This will help to start with Snowflake. It will guide you to launch Snowflake and explain the web interface and functionality. In addition, it will provide guidance for the snowflake pricing model and available options for Virtual Warehouse.</p>
<p><b>Chapter 3: Working with Virtual Data Warehouse</b></p>
<p>This chapter will introduce the key component on snowflake – the Virtual Warehouse. The reader will learn how to work and monitor Virtual Warehouse.</p>
<p><b>Chapter 4: Loading Data into Snowflake</b></p>
<p>This chapter will show how you can bulk load data into Snowflake using COPY command.</p>
<p><b>Chapter 5: Getting started with SnowSQL</b></p>
<p>Chapter Goal: This chapter will introduce snowflake CLI tool. The reader will learn how to work with CLI tool and what he can accomplish with it.</p>
<p><b>Chapter 6: Loading Continuously Using Snowpipe</b></p>
<p>This chapter will introduce another Snowflake utility – Snowpipe. The reader will learn how to use Snowpipe and will create datapipeline in order to loading data into Snowflake.</p>
<p><b>Chapter 7: Snowflake Administration</b></p>
<p>This will guide reader who to manage Snowflake Account.</p>
<p><b>Chapter 8: Snowflake Security</b></p>
<p>This chapter will cover fundamental principles of the Snowflake security model and will guide reader in how to setup security and access with cluster.</p>
<p><b>Chapter 9:</b><b> Working with Semi Structure and Binary Data</b><b></b></p>
<p>Snowflake allows you to work with semi-structure data. This chapter will demonstrate you how to work with popular semi-structure formats like JSON, XML and AVRO. In addition, the user will learn about Binary data and to work with it at Snowflake.</p>
<p><b>Chapter 10: Working Snowflake Time Travel</b> <b>and</b> <b>Data Sharing</b></p>
<p>This chapter will introduce unique functionality of Snowflake – Time Travel. The reader will learn how and when they may need to use this functionality. In addition, the reader will learn about another unique functionality – Data Sharing.</p>
<p><b>Chapter 11: Building Modern Analytics Solution with Matillion ETL, Tableau, and Snowflake</b></p>
<p>This chapter will help users to learn about integration of Snowflake data platform with modern Business Intelligence and Data Integration tools (they are both key partners of Snowflake and leaders at the market).</p>
<p><b>Chapter 12: Snowflake for Big Data Use Cases</b></p>
<p>This chapter will show you common bigdata use cases and demonstrate how Snowflake can handle Big Data.</p>
<p><b>Chapter 13: Legacy DW migration to the Snowflake</b></p>
<p>This chapter will demonstrate migration process of legacy DW into Snowflake</p>
<p><b>Dmitry Anoshin</b> is a data-centric technologist and recognized expert in building and implementing business/digital intelligence solutions. He has a successful track record of implementing analytics projects in numerous industries: retail, finance, marketing, and eCommerce. He possesses an in-depth knowledge of BI, ETL, DWH, and big data technologies and is experienced in data integration processes and proficient use of various data warehousing methodologies. He completed and met deadlines for a number of multinational full BI solution life cycle implementation projects.</p>
<p><b>Dmitry Shirokov</b> is a Data Architect & Cloud Analytics Consultant at Rock Your Data, focused on digital transformation, design analytics solutions, data integration and migration, data governance, and cloud/in-house infrastructure. With over 10 years of experience in data analytics and big data, he has the breadth and depth of experience needed to build mature analytical solutions. Before joining Rock Your Data in early 2018, he worked in different companies in tech consulting and banking sectors. Previously, he held various data-engineering positions focusing on data-driven business transformation.</p><p></p><p>Donna Strok loves all things data and for over 10 years has worked in the field with companies such as Expedia Group, JPMorgan Chase and most recently Amazon. She earned her Bachelors degree in Computer Science and her Masters in Computer Information Systems.</p>
<p>She resides in beautiful Seattle, WA with her cat Dwayne Johnson and in her free time enjoys the wanderlust of world travel. She’s always on the on the hunt for exploring unique grocery stores and amazing hole-in the-wall restaurants, where some of her most memorable meals have been had.</p><br><p></p>
<p><b>Dmitry Shirokov</b> is a Data Architect & Cloud Analytics Consultant at Rock Your Data, focused on digital transformation, design analytics solutions, data integration and migration, data governance, and cloud/in-house infrastructure. With over 10 years of experience in data analytics and big data, he has the breadth and depth of experience needed to build mature analytical solutions. Before joining Rock Your Data in early 2018, he worked in different companies in tech consulting and banking sectors. Previously, he held various data-engineering positions focusing on data-driven business transformation.</p><p></p><p>Donna Strok loves all things data and for over 10 years has worked in the field with companies such as Expedia Group, JPMorgan Chase and most recently Amazon. She earned her Bachelors degree in Computer Science and her Masters in Computer Information Systems.</p>
<p>She resides in beautiful Seattle, WA with her cat Dwayne Johnson and in her free time enjoys the wanderlust of world travel. She’s always on the on the hunt for exploring unique grocery stores and amazing hole-in the-wall restaurants, where some of her most memorable meals have been had.</p><br><p></p>
<p>Explore the modern market of data analytics platforms and the benefits of using Snowflake computing, the data warehouse built for the cloud.</p><p>With the rise of cloud technologies, organizations prefer to deploy their analytics using cloud providers such as Amazon Web Services (AWS), Microsoft Azure, or Google Cloud Platform. Cloud vendors are offering modern data platforms for building cloud analytics solutions to collect data and consolidate into single storage solutions that provide insights for business users. The core of any analytics framework is the data warehouse, and previously customers did not have many choices of platform to use.</p><p>Snowflake was built specifically for the cloud and it is a true game changer for the analytics market. This book will help onboard you to Snowflake, present best practices to deploy, and use the Snowflake data warehouse. In addition, it covers modern analytics architecture and use cases. It provides use cases of integration with leading analytics software such as Matillion ETL, Tableau, and Databricks. Finally, it covers migration scenarios for on-premise legacy data warehouses.<br></p><p>You will:<br></p><p></p><ul><li>Know the key functionalities of Snowflake<br></li><li>Set up security and access with cluster<br></li><li>Bulk load data into Snowflake using the COPY command<br></li><li>Migrate from a legacy data warehouse to Snowflake<br></li><li>integrate the Snowflake data platform with modern business intelligence (BI) and data integration tools</li></ul><p></p><p><br></p>
<p>The first complete guide to Snowflake Computing, the data warehouse built for the cloud</p><p>Provides step-by-step instructions to innovate, scale, and grow your business using Snowflake</p><p>Teaches you how to work with Snowflake and Snowflake’s partner ecosystem to build a modern end-to-end solution</p>
Diese Produkte könnten Sie auch interessieren:
Mixed-Signal Layout Generation Concepts
von: Chieh Lin, Arthur H.M. van Roermund, Domine Leenaerts
96,29 €
System-Level Design Techniques for Energy-Efficient Embedded Systems
von: Marcus T. Schmitz, Bashir M. Al-Hashimi, Petru Eles
96,29 €
