Managing an Enterprise Snowflake Data Platform from Pluralsight

Snowflake offers a rich set of security, resource management, and data sharing features. This course covers advanced features that will help you meet your requirements and make your life easier when adopting Snowflake across your enterprise.

With a multi-cloud compatible (AWS, GCP, Azure) and cloud-first development approach, the Snowflake cloud data platform is a great choice to become an enterprise’s single source of truth. Managing a Snowflake account is a big responsibility and requires familiarity with features like multi-factor authentication, single sign-on, multi-cloud disaster recovery, and more. In this course, Managing an Enterprise Snowflake Data Platform, you will see how all of these come together to provide a true enterprise-scale quality data platform service. First, you will learn the security features like single sign-on and network policies. Next, you will explore your data platform’s usage and availability with cross-cloud replication, multi-cluster warehouses and resource monitors. Finally, you will discover secure data sharing with data shares and exchanges. When you’re finished with this course, you will have the skills and knowledge necessary to administer your enterprise Snowflake account.

The snowflake cloud data platform is warehouse for data that also allows its users to build data-intensive applications without having to deal with operational hastle.

In this course, you will learn about identity management integration, account security, disaster recovery, how to create a private data exchange, and other advice, tips and tricks. By the end of this course you will be ready to configure and manage your enterprise's snowflake data platform.

Snowflake cloud data platforms are used to simplify in-house software and hardware. Snowflake does not require any installation of software or hardware making it easy to implement for organizations who don't want to dedicate resources for setup, maintenance, and support of in-house servers.

A multi-cloud strategy allows for an organization to avoid being locked into one cloud service. This enables the organization to select the best cloud service to meet the requirements of a specific application or workload.

Some benefits of a customer data platform are: having one place to store all data, an in-depth understanding of customers, identifying and targeting new customer segments, optimizing campaigns, and cost savings.

What's inside

Syllabus

Course Overview

Managing Snowflake Authentication

Securing the Snowflake Account

Managing Warehouse Service Levels

Enabling Enterprise Data Sharing

Good to know

Know what's good

, what to watch for

, and possible dealbreakers

The course is designed for individuals responsible for administering Snowflake accounts within an enterprise environment

Teaches advanced features and capabilities of the Snowflake platform, such as security, resource management, and data sharing

Instructors, Warner Chaves, are experienced professionals in the field of data management and analytics

Covers essential topics for managing an enterprise Snowflake account, including security, performance, and data sharing

May require prior experience with Snowflake or related data management platforms

Activities

Be better prepared before your course. Deepen your understanding during and after it. Supplement your coursework and achieve mastery of the topics covered in Managing an Enterprise Snowflake Data Platform with these activities:

Review SQL Basics

Show steps

Reviewing SQL basics will help you refresh your knowledge of the language and make it easier to learn Snowflake.

Show steps

Read a tutorial on SQL basics.
Take a practice quiz on SQL basics.

Review Cloud Computing Concepts

Show steps

Reviewing cloud computing concepts will help you understand the basics of the cloud and how Snowflake fits into the cloud ecosystem.

Browse courses on Cloud Computing Concepts

Show steps

Read a tutorial on cloud computing concepts.
Take a practice quiz on cloud computing concepts.

Organize Your Course Materials

Show steps

Organizing your course materials will help you stay organized and make it easier to find the information you need.

Show steps

Create a folder for your course materials.
Download all of your course materials.
Organize your course materials into folders.

Nine other activities

Expand to see all activities and additional details

Show all 12 activities

Review SQL

Show steps

Refresh your understanding of SQL basics to prepare for advanced Snowflake concepts.

Browse courses on SQL

Show steps

Review SQL syntax and commands.
Practice writing SQL queries on sample data.

Practice Creating and Managing Snowflake Accounts

Show steps

Practicing creating and managing Snowflake accounts will help you become familiar with the Snowflake platform and its features.

Browse courses on Snowflake

Show steps

Create a new Snowflake account.
Add users to the account.
Grant permissions to users.
Manage the account's resources.

Follow a Tutorial on Snowflake Security Features

Show steps

Following a tutorial on Snowflake security features will help you understand how to protect your data in the Snowflake platform.

Browse courses on Snowflake

Show steps

Find a tutorial on Snowflake security features.
Follow the tutorial.

Participate in a Peer Study Group on Snowflake

Show steps

Participating in a peer study group on Snowflake will help you learn from others and reinforce your understanding of the platform.

Browse courses on Snowflake

Show steps

Find a peer study group on Snowflake.
Participate in the study group.

Follow Snowflake tutorials

Show steps

Enhance your Snowflake skills by following guided tutorials provided by Snowflake.

Browse courses on Snowflake

Show steps

Choose a tutorial relevant to your learning objectives.
Follow the tutorial steps carefully, practicing the concepts.
Complete the exercises and quizzes to reinforce your understanding.

Build a Snowflake Data Warehouse and Data Application

Show steps

Building a data warehouse and data application will help you solidify your understanding of Snowflake’s features and capabilities.

Browse courses on Data Warehousing

Show steps

Create a Snowflake account.
Create a data warehouse.
Load data into the data warehouse.
Create a data application that uses the data warehouse.
Test the data application.

Solve Snowflake practice problems

Show steps

Sharpen your Snowflake skills by solving practice problems and quizzes.

Browse courses on Snowflake

Show steps

Find practice problems online or through Snowflake resources.
Attempt to solve the problems, focusing on applying the concepts learned.
Review your solutions and identify areas for improvement.

Create a Data Sharing Strategy

Show steps

Creating a data sharing strategy will help you understand how to securely and efficiently share data with other users and organizations.

Browse courses on Data Sharing

Show steps

Identify the data that you want to share.
Determine the level of access that you want to grant to other users and organizations.
Create a data sharing agreement.
Implement the data sharing agreement.

Design a Snowflake data security plan

Show steps

Apply your knowledge of Snowflake security features to create a comprehensive plan for your enterprise.

Browse courses on Data Security

Show steps

Analyze the security requirements and regulations applicable to your organization.
Map Snowflake security features to address these requirements.
Document your plan, outlining the implementation and management of Snowflake security.

Career center

Learners who complete Managing an Enterprise Snowflake Data Platform will develop knowledge and skills that may be useful to these careers:

Data Engineer

A Data Engineer seeks to understand the business and their data needs through modeling and translating these requirements into technological solutions. Data Engineers specialize in designing, managing, and maintaining big data management systems, which could include data pipelines, data ingestion tools, data lakes, and other enterprise data platforms. They are responsible for data analysis, transformation, and cleansing, all of which can be done from the Snowflake environment. Taking courses like Managing an Enterprise Snowflake Data Platform will teach you how to set up and maintain the infrastructure necessary for Data Engineers to succeed.

See salaries and explore the career path for Data Engineer

Data Analyst

Data Analysts generate business intelligence and insights from complex data. They communicate these insights to stakeholders in a clear and concise manner. A Data Analyst can often be found working in finance, banking, retail, or healthcare. Those who want to enter the field should take Managing an Enterprise Snowflake Data Platform because it will teach you how to manage data platforms like the Snowflake cloud data platform, which could make you a more effective Data Analyst.

See salaries and explore the career path for Data Analyst

Data Architect

Data Architects are responsible for designing and implementing data architectures. They work with other stakeholders to understand the business needs and design a data architecture that meets those needs. Because Data Architects help build the tools used by Data Engineers, Data Scientists, and other roles, learning how to manage data platforms like Snowflake is often a prerequisite. This is because understanding how to manage platforms like Snowflake is key to building a scalable, efficient, and cost-effective data architecture.

See salaries and explore the career path for Data Architect

Data Scientist

Data Scientists are highly skilled at analyzing and interpreting large amounts of data. They use their expertise to solve business problems and create data-driven solutions. Data Scientists are crucial to the success of companies, as they can help them make better decisions and gain a competitive advantage. Many Data Scientists find it is helpful to learn how to manage enterprise data platforms like Snowflake. This means that Managing an Enterprise Snowflake Data Platform can help you become a more effective Data Scientist.

See salaries and explore the career path for Data Scientist

Database Administrator

Database Administrators install and maintain databases. They also ensure that databases are running smoothly and that data is protected. Database Administrators are often responsible for managing Snowflake, which is a cloud-based data warehousing service. By taking a course like Managing an Enterprise Snowflake Data Platform, you can learn how to more effectively manage Snowflake and other cloud-based data platforms and qualify for a Database Administrator position.

See salaries and explore the career path for Database Administrator

Software Engineer

Software Engineers design, develop, and maintain software applications. They work with other stakeholders to understand the business needs and design software applications that meet those needs. Snowflake is a popular data warehousing solution for many businesses. This means that many Software Engineers will need to learn how to use Snowflake. Taking a course like Managing an Enterprise Snowflake Data Platform can help you to learn how to use Snowflake and become a more effective Software Engineer.

See salaries and explore the career path for Software Engineer

Cloud Engineer

Cloud Engineers design, build, and manage cloud computing systems. They work with other stakeholders to understand the business needs and design cloud computing systems that meet those needs. Snowflake is a cloud-based data warehousing service. This means that many Cloud Engineers will need to learn how to use Snowflake. Taking a course like Managing an Enterprise Snowflake Data Platform can help you to learn how to use Snowflake and become a more effective Cloud Engineer.

See salaries and explore the career path for Cloud Engineer

Data Security Analyst

Data Security Analysts protect data from unauthorized access, use, disclosure, disruption, modification, or destruction. They work with other stakeholders to understand the business needs and design data security solutions that meet those needs. Snowflake is a cloud-based data warehousing service. This means that many Data Security Analysts will need to learn how to use Snowflake. Taking a course like Managing an Enterprise Snowflake Data Platform can help you to learn how to use Snowflake and become a more effective Data Security Analyst.

See salaries and explore the career path for Data Security Analyst

Business Analyst

Business Analysts work with stakeholders to understand their business needs and design solutions that meet those needs. They may also be responsible for gathering and analyzing data to support decision-making. Many Business Analysts will need to learn how to use Snowflake, a cloud-based data warehousing service. Taking a course like Managing an Enterprise Snowflake Data Platform can help you to learn how to use Snowflake and become a more effective Business Analyst.

See salaries and explore the career path for Business Analyst

IT Manager

IT Managers plan, direct, and coordinate IT activities within an organization. They work with other stakeholders to understand the business needs and design IT solutions that meet those needs. Snowflake is a cloud-based data warehousing service. This means that many IT Managers will need to learn how to use Snowflake. Taking a course like Managing an Enterprise Snowflake Data Platform can help you to learn how to use Snowflake and become a more effective IT Manager.

See salaries and explore the career path for IT Manager

Project Manager

Project Managers plan, execute, and close projects. They work with other stakeholders to understand the project requirements and develop a project plan. Snowflake is a cloud-based data warehousing service. This means that many Project Managers will need to learn how to use Snowflake. Taking a course like Managing an Enterprise Snowflake Data Platform can help you to learn how to use Snowflake and become a more effective Project Manager.

See salaries and explore the career path for Project Manager

Systems Analyst

Systems Analysts study the needs of organizations to define system solutions. They work with other stakeholders to understand the business needs and design system solutions that meet those needs. Snowflake is a cloud-based data warehousing service. This means that many Systems Analysts will need to learn how to use Snowflake. Taking a course like Managing an Enterprise Snowflake Data Platform can help you to learn how to use Snowflake and become a more effective Systems Analyst.

See salaries and explore the career path for Systems Analyst

Information Security Manager

Information Security Managers plan, implement, and manage an organization's information security program. They work with other stakeholders to understand the business needs and design information security solutions that meet those needs. Snowflake is a cloud-based data warehousing service. This means that many Information Security Managers will need to learn how to use Snowflake. Taking a course like Managing an Enterprise Snowflake Data Platform can help you to learn how to use Snowflake and become a more effective Information Security Manager.

See salaries and explore the career path for Information Security Manager

Network Administrator

Network Administrators plan, implement, and maintain computer networks. They work with other stakeholders to understand the business needs and design network solutions that meet those needs. Snowflake is a cloud-based data warehousing service. This means that many Network Administrators will need to learn how to use Snowflake. Taking a course like Managing an Enterprise Snowflake Data Platform can help you to learn how to use Snowflake and become a more effective Network Administrator.

See salaries and explore the career path for Network Administrator

Database Designer

Database Designers design and implement databases. They work with other stakeholders to understand the business needs and design databases that meet those needs. Snowflake is a cloud-based data warehousing service. This means that many Database Designers will need to learn how to use Snowflake. Taking a course like Managing an Enterprise Snowflake Data Platform can help you to learn how to use Snowflake and become a more effective Database Designer.

See salaries and explore the career path for Database Designer