Are you an aspiring data professional? This course discusses how data professionals like data engineers and analysts use Snowflake for analysis and engineering tasks. You'll get an introduction to why Snowflake is a popular data warehousing solution for companies and learn how to access Snowflake tables and track query activities with its UI tool, Snowsight.


What is Snowflake?

Navigating to a database and schema

Navigate to a table

Executing a query and viewing the results

Analyzing the sales amount

Investigating product categories

Monitoring Query and Copy History

Viewing query Details

Exploring Python Worksheets

Introduction to Snowflake UI

We will explore some of the many features that Snowsight offers that will make you more versatile as a data professional. We will cover Snowflake Marketplace, loading data from popular cloud providers like AWS, GCP, and Azure, and managing role access.

Loading Data from Snowflake Marketplace

Exploring the Snowflake marketplace

Uploading CSV Data

Loading Data from a cloud provider

Process of creating a new stage and table

Creating a table from an external stage

Creating new roles, users, and warehouses

Exploring user roles

Creating your first notebook

Course Wrap-Up

Snowsight in Action: Managing Data & Access

In Introduction to Snowflake, you will learn to navigate Snowflake, execute SQL queries in Snowsight, and manage data ingestion and integration. The course covers role-based access control, query monitoring, and performance optimization. It is ideal for data engineers, analysts, and BI professionals looking to enhance their data warehousing skills. By the end, you will gain proficiency in Snowflake SQL, data ingestion, management, security, and optimization techniques.

<h2>Introduction to Snowflake</h2>

<p>In Introduction to Snowflake, you will learn how to navigate and use Snowflake, a leading cloud-based data warehousing platform. This course will guide you through Snowflake’s architecture, Snowsight for SQL-based queries, and methods for ingesting, integrating, and managing data from various sources. You will also explore role-based access control, query monitoring, and performance optimization.</p>

<h2>Who is this course for?</h2>

<p>This course is perfect for data engineers, analysts, and BI professionals looking to enhance their data warehousing skills, as well as anyone interested in modern cloud data management.</p>

<h2>What you will gain</h2>

<p>Proficiency in Snowflake SQL and Snowsight<br>  
Skills in data ingestion and management<br>  
Understanding of role-based security and optimization techniques</p>

<h2>Conclusion</h2>

<p>As Snowflake continues to transform data storage and analytics, mastering it will help you unlock new opportunities in data analytics and engineering. Start learning today!</p>


Intermediate SQL

Snowflake is a top data warehousing platform. Learn how they use Snowsight, a user-friendly SQL interface for accessing and exploring data.

Introduction to Snowflake

Ingeniero de datos asociado in Snowflake

Fundaciones de Snowflake

Senior Data Engineer

Let's practice!

https://s3.amazonaws.com/assets.datacamp.com/production/course_39090/subtitles/course_39090_de18fd70fb29f30ecd06e60cba388bd7.vtt

Snowsight in Action: Managing Data & Access - Loading Data from Snowflake Marketplace

Loading Data from Snowflake Marketplace

Create Your Free Account