Snowflake COPY Command: 5 Critical Aspects December 28th, 2021 By Vishal Agrawal in Data Warehousing, Snowflake The Snowflake COPY command is used to load data from staged files on internal or external locations to an existing table or vice versa. In this article, you will understand…
Building Snowflake ELT Pipeline [+8 Best Tools] December 22nd, 2021 By Ofem Eteng in Data Warehousing, Snowflake There is a growing need among businesses to capture relevant information from the data they produce because businesses that fail to capture data and transform it into timely and valuable…
Best Snowflake BI and Reporting Tools for 2024 December 20th, 2021 By Muhammad Faraz in Data Warehousing, Snowflake Are you confused, between the best Snowflake BI and Reporting Tools available? If yes, then you have landed at the right place. This blog will introduce you to Snowflake and…
Snowflake Create Database Simplified 101: Usage and Examples Explained December 20th, 2021 By Vishal Agrawal in Data Warehousing, Snowflake Have you just started with Snowflake? Are you confused about how to create a database in Snowflake? If yes, then you are in the right place. In this blog post,…
What is Snowflake SQL? – Explained(with examples) December 7th, 2021 By Shruti Garg in Data Warehousing, Snowflake Snowflake provides support for standard SQL, including a subset of ANSI SQL:1999 and the SQL:2003 Analytic extensions. It also supports common variations for numerous commands where those variations do not…
Snowflake Pricing Explained: A Comprehensive Guide for 2024 November 17th, 2021 By Avinash Mohanakrishnan in Data Warehousing, Snowflake Snowflake is a popular Cloud Data Warehousing solution that has been implemented by scores of well-known firms, including Fortune 500 companies, as their Data Warehouse provider and manager. However, the…
Databricks vs Snowflake: 9 Critical Differences November 10th, 2021 By Amit Phaujdar in Data Warehousing, Snowflake, Versus Databricks is an Enterprise Software company that was founded by the creators of Apache Spark. It is known for combining the best of Data Lakes and Data Warehouses in a…
Azure Synapse vs Snowflake: 6 Critical Differences November 9th, 2021 By Nicholas Samuel in Data Warehousing, Snowflake, Versus Many organizations are moving their data to the cloud. The reason is that companies have realized the benefits of storing their data in the cloud including reduced data storage costs,…
MongoDB vs Snowflake: 7 Critical Differences November 8th, 2021 By Vishal Agrawal in Data Warehousing, Snowflake, Versus Competition between companies is one such factor that will remain constant, as long as they offer similar products and services. This is pretty common in emerging and competitive fields such…
Teradata vs Snowflake: Comparing the Top 10 Differences October 8th, 2021 By Ofem Eteng in Data Warehousing, Snowflake, Versus There are various Data Warehouses available in the market today, knowing their attributes and strengths will go a long way in helping you to decide which one best fits the…
Snowpark Snowflake: A Comprehensive 101 Guide September 28th, 2021 By Ofem Eteng in Data Warehousing, Snowflake Snowflake, an industry-leading Data Warehousing Platform has been at the forefront of transforming the way we see and use data and as such, has become a favourite solution for Data…
How to Simplify Snowflake on GCP Setup? September 28th, 2021 By Orina Mark in Data Warehousing, Snowflake Why is the cloud becoming so popular? It all boils down to the intricate features that come with the platform. For instance, companies no longer have to bear the costs…
How to set up CrunchBase Snowflake Integration? 3 Easy Steps September 22nd, 2021 By Teniola Fatunmbi in Data Warehousing, Snowflake CrunchBase provides data about mergers and acquisitions of companies/firms in the data and analytics space. CrunchBase data can be very useful when building a list of Leads for Business to…
Snowflake JDBC: How to Connect to Snowflake Using the JDBC Driver September 17th, 2021 By Nicholas Samuel in Data Warehousing, Snowflake A few years back, building a Data Warehouse was an expensive process that required the use of specially designed hardware appliances in your Data Center. However, the invention of Snowflake…
Snowflake vs Redshift vs BigQuery: 16 Critical Differences May 31st, 2021 By Ofem Eteng in BigQuery, Data Warehousing, Redshift, Snowflake Venturing into Data Science and deciding on a tool to use to solve a given problem can be challenging at times especially when you have a wide array of choices.…
Snowflake vs Postgres: 5 Critical Differences May 21st, 2021 By Amit Phaujdar in Data Warehousing, Snowflake, Versus PostgreSQL is a reliable database management system with a keen focus on SQL compliance and extensibility. PostgreSQL is well suited for various industries and use cases such as web apps,…
Snowflake vs Oracle: Key Differences 2025 May 12th, 2021 By Pratik Dwivedi in Data Warehousing, Snowflake, Versus With data requirements growing at the speed of light, the ability to not only manipulate data in real-time but also scale along with it is a must-have for most organizations…
Snowflake Merge: Examples and Performance August 4th, 2020 By Vishal Agrawal in Data Warehousing, Snowflake The Snowflake Merge command is used to perform Insert, Update and Delete on the target table with the changes made onto source tables. In this article, we aim to discuss…
Snowflake ALTER TABLE for Table Modifications Explained(with code) July 28th, 2020 By Rashid Y in Data Warehousing, Snowflake Does your organization use Snowflake to store its data for analytics and reporting purposes? If so, then the Snowflake alter table add column feature is one of many useful features…
How to Use Snowflake ROW_NUMBER Function for Data Ranking July 23rd, 2020 By Talha in Data Warehousing, Snowflake In this article, we are going to work through some examples of using the Snowflake ROW_NUMBER() analytic function to solve some business questions. We will see how to use this…