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…
Connecting to Snowflake Using the JDBC Driver: Easy Steps 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: 3 Critical Parameters 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…
Modifying Tables with Snowflake’s ALTER TABLE: Step-by-Step Instructions 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…
ROW_NUMBER function in snowflake: 4 Critical Aspects 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…
Using Snowflake Create Table Made Easy: 2 Critical Aspects July 17th, 2020 By Shruti Garg in Data Warehousing, Snowflake Are you just getting started with Snowflake? Looking to learn more about creating tables in Snowflake? You are in the right place, we have just the information you need. Get…
Snowflake Data Types: A Deep Dive into 6 Essential Varieties July 10th, 2020 By Shruti Garg in Data Warehousing, Snowflake Snowflake provides support for the standard SQL data types (with a few restrictions) for use in columns, local variables, expressions, and parameters. Every column in a table will have a name…