Step-by-Step Guide to Setting Up Amazon Redshift JDBC Driver Connection October 15th, 2020 By Nicholas Samuel in Data Warehousing, Redshift Are you looking to set up an Amazon Redshift JDBC (Java Database Connectivity) Driver connection? Amazon Redshift is a fully managed, scalable, and fast Data Warehouse that allows companies to…
Google BigQuery Create Table Command: 4 Easy Methods October 15th, 2020 By Talha in BigQuery, Data Warehousing Since data acts as the new oil of businesses, it becomes crucial to collect, maintain, and analyze the data. Nowadays, data is growing exponentially, and it's becoming a challenge to…
BigQuery Tutorial for Beginners: A Comprehensive Guide 101 October 14th, 2020 By Lahu Bhawar in BigQuery, Data Warehousing This article is basically focused on providing a comprehensive BigQuery Tutorial. You will also gain a holistic understanding of Batch Processing, its key features, Spring framework, Spring Batch, and a…
Load Data into BigQuery: Easy Step-by-Step Guide September 1st, 2020 By Muhammad Faraz in BigQuery, Data Warehousing Are you struggling to load data into BigQuery? Are you confused, which is the best method to load data into BigQuery? If yes, then this blog will answer all your…
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…
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…
Amazon Redshift DATEDIFF and DATEADD Functions Simplified 101 May 26th, 2020 By Sarad Mohanan in Data Warehousing, Redshift Redshift has various types of built-in functions to perform operations on data for example: String functions to perform operations on strings Numeric functions to perform operations on numeric data Date…