learning about Snowflake




What is Snowflake?

Snowflake is a cloud-based data warehouse that offers a variety of features for data storage, processing, and analysis. It is a multi-tenant platform, which means that it is shared by multiple users, but each user's data is isolated from the data of other users. Snowflake is known for its performance, scalability, and security.

Key concepts and terminology

Here are some key concepts and terminology that you will need to understand when using Snowflake:

Virtual warehouses: Snowflake uses virtual warehouses to process queries and perform other data operations. Virtual warehouses are essentially temporary compute resources that are allocated to users on demand.
Stages: Stages are temporary locations where data is stored before it is loaded into a table. Data can be loaded into Snowflake from a variety of sources, including files, databases, and cloud storage.
Views: Views are virtual tables that are based on one or more tables. Views can be used to simplify queries and provide users with a limited view of the data.
Roles: Roles are used to control access to Snowflake resources. Each role has a set of privileges that determine what actions a user can perform.

Is Snowflake a SQL DB?

How is It Supported in Snowflake? Snowflake is a data platform and data warehouse (relational database), supporting the most common standardised SQL version, thus enabling all common operations. Snowflake also supports all of the operations that enable data warehousing operations, like create, update, insert, etc.

What type of SQL does Snowflake use?

Snowflake supports standard SQL, including a subset of ANSI SQL:1999 and the SQL:2003 analytic extensions



Comments

Post a Comment

Popular posts from this blog

AWS S3 MRAP

Image
  Amazon S3 Multi-Region Access Points In Simple terms, what is S3 MRAP? Imagine you have a giant box of toys (like S3 buckets) in different rooms (like different AWS regions) of your house (like the cloud). Normally, you'd have to remember which room each toy was in to find it. But with S3 MRAP, it's like having a magic label on the box that says "Toy Room" no matter which room it's actually in. You just say "Toy Room" and magically the label tells you the right room to go to! S3 MRAP is like a special label for your toy boxes (S3 buckets) that are spread out in different places (regions). You ask for a toy (data) using the label (MRAP endpoint), and the label tells you the best place (regional S3 bucket) to find it, no matter where it's stored! ~~Rakesh
Read more

SLO Compliance

SLO compliance refers to the extent to which a service meets or adheres to its defined Service Level Objectives (SLOs). An SLO is a specific, measurable target for a service's performance or reliability, such as uptime, response time, or error rate, agreed upon to ensure a certain level of quality for users. Compliance, in this context, means that the service is performing within the acceptable range or threshold set by the SLO over a specified period of time. For example, if an SLO states that a website should be available 99.9% of the time in a month, SLO compliance would be achieved if the actual availability meets or exceeds that 99.9% target. If it falls below, the service is considered non-compliant, which might trigger actions like alerts, investigations, or even penalties if tied to a Service Level Agreement (SLA) with customers. In practice, SLO compliance is tracked using Service Level Indicators (SLIs)—quantitative metrics like latency or success rate—that are monitored ...
Read more