Skip to content

Files

Latest commit

 

History

History

Folders and files

NameName
Last commit message
Last commit date

parent directory

..
 
 
 
 
 
 
 
 

${{values.name | dump}}

Overview

Use this component to create a database, a schema and tables within a Snowflake instance.

We will need to create all tables that will be used for the Data Product, specially the final table the Output Port will use to build the view exposed to the public.

What's a Storage Area?

A Storage Area is what the components of a Data Product use to persist data that is created or used by the various Workloads or served by Output Ports.

Snowflake

Snowflake is a cloud based data warehousing platform that simplifies the management and analysis of massive amounts of data. Its architecture separates computation and storage resources, allowing them to scale independently according to demand. The key features include:

  • Storage and Compute Separation: Unlike many traditional databases, Snowflake separates compute and storage resources, allowing each to scale independently. This ensures you pay only for the resources you use.
  • Multi-Cloud Capability: Snowflake is a platform-agnostic service that can be run on major cloud providers such as AWS, GCP and Microsoft Azure.
  • Zero Management: Snowflake is offered as a fully-managed service, which means you don't have to worry about infrastructure, indexes, partitions, or tuning to maintain peak performance.
  • Security: It provides robust security features such as end-to-end encryption, multi-factor authentication, and role-based access control to ensure data privacy and protection.
  • Concurrency and Performance: Snowflake can handle large numbers of simultaneous users and queries without degrading performance.
  • Time Travel: Snowflake allows you to access historical data at any point within a specified period, which can be up to 90 days. This can be used for data recovery or analytical purposes.
  • Cloning: the clone capability allows us to quickly duplicate anything, including databases, schemas, tables, and other Snowflake objects, in almost real time.

Learn more about it on the official website.

Usage

To get information about this component and how to use it, refer to this document.