Snowflake

Simplifying JSON Data: How to Use Snowflake Flatten and Lateral Joins

February 1st, 2022 By Harsh Varshney in Data Warehousing, Snowflake

Snowflake is a more Cost-Effective and Instantly Scalable data warehouse with industry-leading Query Performance. In this article, you will learn everything about Snowflake Flatten, along with the process that you…

Airflow Snowflake ETL Setup: 2 Easy Steps

January 31st, 2022 By Vishal Agrawal in Data Warehousing, Snowflake

Snowflake is a fully managed SaaS (software as a service) that offers a single platform for data warehousing, data lakes, data engineering, data science, data application development, and secure sharing…

Building Snowflake Apps Made Easy 101

January 27th, 2022 By Manisha Jena in Data Warehousing, Snowflake

The world is becoming increasingly computerized. Soon, every part of our lives will be connected to the Internet, providing consumers with more conveniences such as instant access to information. While…

Building a Snowflake CI CD Pipeline: What You Need to Know?

January 27th, 2022 By Rakesh Tiwari in Data Warehousing, Snowflake

The acronyms CI and CD are frequently used in modern development practices and DevOps. Continuous integration (CI) refers to a fundamental DevOps best practice in which developers frequently merge code…

What is Snowflake Data Science? (Easy Explanation)

January 25th, 2022 By Davor DSouza in Data Warehousing, Snowflake

Snowflake Data Science is designed to support data preparation, model building, and collaboration. Its cloud-based architecture integrates with Machine Learning and Data Science tools, making it ideal for large-scale analysis.…

Snowflake Data Catalog: Key Functions, Benefits, and 6 Best Tools

January 21st, 2022 By Nicholas Samuel in Data Warehousing, Snowflake

Snowflake is a Cloud Data Warehouse solution used for the storage of data. It provides its users with many benefits including Security and Scalability. Due to this, organizations are moving…

Querying Snowflake Metadata for Staged File: 2 Easy Examples

January 20th, 2022 By Jeremiah in Data Warehousing, Snowflake

As a business grows, firms find it difficult to keep up with rising Data Storage and Real-Time Analytics demands. Traditional On-Premise Solutions fail to provide On-demand Scaling and often require…

Snowflake PIVOT & UNPIVOT Command: Syntax, Usage & Practical Examples 101

January 18th, 2022 By Harsh Varshney in Data Warehousing, Snowflake

Imagine you’re staring at a massive table of data—rows and rows of information—and all you want is to flip it around to get a clearer view. Maybe you need to…

How to Simulate Snowflake Triggers for Better Automation

January 17th, 2022 By Yash Arora in Data Warehousing, Snowflake

Snowflake, a cloud-based data storage and analytics service provider, is a warehouse-as-a-solution designed to cater to today's enterprises' needs and use cases. And one such use case — process automation…

How to Easily Create and Manage Snowflake Temporary Tables

January 17th, 2022 By Davor DSouza in Data Warehousing, Snowflake

The ever-increasing demand for Efficient Data Handling & Processing has reached a new peak. Owing to the limitations of On-premise Data Storage and Analytics tools, businesses are increasingly turning to…

Understanding Snowflake Time Travel [+with Examples and Code]

January 13th, 2022 By Harsh Varshney in Data Warehousing, Snowflake

To empower your business decisions with data, you need Real-Time High-Quality data from all of your data sources in a central repository. Traditional On-Premise Data Warehouse solutions have limited Scalability…

Snowflake CREATE USERS: Syntax, Usage & Practical Examples

January 11th, 2022 By Harsh Varshney in Data Warehousing, Snowflake

You need Real-Time High-Quality data from all your data sources in a central repository to empower your business decisions with data. Traditional On-premise Data Warehouse solutions are limited in terms…

Snowflake Show Tables Command Simplified: A Comprehensive Guide 101

January 11th, 2022 By Rakesh Tiwari in Data Warehousing, Snowflake

At times, you may need to get a list of tables from your database. This could be to help with Testing, to see what tables exist before you create a…

Understanding Snowflake Union, Except, and Intersect for Data Operations

January 6th, 2022 By Sanchit Agarwal in Data Warehousing, Snowflake

To empower your business decisions with data, you need Real-Time High-Quality data from all your data sources at a central repository. Traditional On-Premise Data Warehousing Solutions lack in terms of…

Snowflake Convert Timezone Command 101: Syntax, Usage and Examples Simplified

January 6th, 2022 By Rakesh Tiwari in Data Warehousing, Snowflake

Time is one of the most important aspects for any kind of data. Whether you are working with data in real-time or not, it is important to know when a…

Snowflake Tasks: How to Create & Manage TASK command?

January 5th, 2022 By Harsh Varshney in Data Warehousing, Snowflake

To manage and perform data tasks efficiently nowadays organizations are shifting to Cloud Data Warehouse. Snowflake is one such Data Warehouse solution that can be built on AWS, Azure, or…

Snowflake CAST & TRY_CAST Commands 101: Syntax & Usage Simplified

January 4th, 2022 By Sanchit Agarwal in Data Warehousing, Snowflake

When working with an On-premise Data Storage solution, it is not always feasible to scale your Storage and Computation resources instantly without incurring hefty costs. An economical and faster alternative…

Snowflake Data Lake: A Comprehensive Guide 101

January 3rd, 2022 By Ofem Eteng in Data Warehousing, Snowflake

Over the years, there has been a great desire to quickly and cost-effectively gather insights from a variety of Data Sources in a single location, and as such, there have…

Snowflake Dashboards and Other Key Features of Snowsight

December 30th, 2021 By Ofem Eteng in Data Warehousing, Snowflake

As technology advances, people seek innovative ways to simplify complex tasks. Data visualization is a key part of this, turning raw data into insights that are easy to understand. Snowflake…

Working With Snowflake JSON Data And Arrays: Syntax, Examples

December 29th, 2021 By Vivek Sinha in Data Warehousing, Snowflake

One of Snowflake’s greatest strengths is how fast it can ingest structured and unstructured data. But, understanding different aspects of handling Snowflake requires effort. You need a guide to figure…