Popular Articles

Getting Started with AWS RDS CDC

September 12th, 2024 By Sarang Ravate in Change Data Capture CDC

If you have decided to start your journey with cloud databases, you probably have encountered AWS RDS – Amazon Web Services Relational Database Service, and CDC – Change Data Capture.…

Simplifying Business Data: The Power of Data Centralization 

December 15th, 2024 By Sarang Ravate in Data Engineering, Data Strategy

There is no denying the fact that in the modern business world, information reigns supreme because that is what is crucial in making decisions. The problem comes when this information…

Types of Data Integration: A Comprehensive Guide

June 20th, 2024 By Skand Agrawal in Data Integration

In today's dynamic business landscape, mastering the art of data integration is not just a choice but a necessity. The wealth of valuable information resides in various sources, from corporate…

Comprehensive Guide to Modern Data Warehouse in 2025

September 5th, 2024 By Sakshi Kulshreshtha in Data Warehousing

A data warehouse is a centralized system that stores, integrates, and analyzes large volumes of structured data from various sources. It is predicted that more than 200 zettabytes of data…

Utilize DATE_TRUNC Snowflake Function to Manipulate & Analyze Data

May 31st, 2024 By Veeresh Biradar in Data Warehousing, Snowflake

Date and time play crucial roles in time-series analysis, as they are the key components that decide the trends and patterns that the data follows. Truncating them to a specific…

Snowflake Terraform Integration Made Easy

July 8th, 2024 By Roopa Madhuri G in Data Warehousing, Snowflake

Managing infrastructure manually across multiple cloud providers leads to consistency, deployment delays, and difficulty in scaling. You need a solution that automates infrastructure provisioning, ensures consistency, and supports rapid deployment…

MySQL Query Optimization: Techniques for Speeding Up Your Database Explained

December 20th, 2024 By Maria Asghar in Best Practice, Data Strategy, Database Management System, MySQL

MySQL is one of the most popular open-source relational database management systems (RDBMS)  used for various applications. As databases grow in size and complexity, it impacts overall performance of application…

How to Create, Interact, & Manage Snowflake Secure Views?

June 14th, 2024 By Yash Arora in Data Warehousing, Snowflake

Securing sensitive information is essential for businesses today. And, in the category of sensitive information, comes the underlying tables and internal structural details that might get exposed in the user…

Redshift Dynamic SQL: Explained Step-by-Step

May 10th, 2024 By Skand Agrawal in Data Warehousing, Redshift

Companies use Data Warehouses to store and analyze their business data to make data-driven business decisions. Querying through huge volumes of data and reach to a specific piece of data…

Building Data Lake in Apache Iceberg with MySQL CDC

July 12th, 2024 By Dipal Prajapati in Change Data Capture CDC

Building a data lake for reporting, analytics, and machine learning needs has become general practice. Data lakes allow us to ingest data from multiple sources in their raw formats in…

Top 10 PostgreSQL Extensions [With Code + Example]

November 6th, 2024 By Kamlesh in Database Management System, PostgreSQL

PostgreSQL is very powerful and flexible, making it adaptable to significant functionality. PostgreSQL extensions help extend the core capabilities, and we can use databases to scale and customize it for…

What is Databricks Medallion Architecture? A Deep Dive into Its Why and How

November 15th, 2024 By Sarang Ravate in Data Warehousing

This is an essential inflection point thanks to Medallion Architecture in enterprise data management, which was introduced by Databricks and adopted by Microsoft in their Fabric platform release. This architecture…

Snowflake Data Lakehouse: What is it & How to Build One?

June 26th, 2024 By Sarad Mohanan in Data Warehousing, Snowflake

You can use data warehouses or data lakes as a repository for data management and analytics tasks. Both of these solutions have their advantages and disadvantages. A data warehouse is…

ETL vs Data Pipeline : What Are the Key Differences?

April 26th, 2024 By Abhinav Chola in Data Integration, Data Pipeline, ETL

The term "ETL" describes a group of processes used to extract data from one system, transform it, and load it into a target system. A more general phrase is "data…

Snowflake Cluster: A Complete Overview

June 14th, 2024 By Talha in Data Warehousing, Snowflake

Are you looking to learn about the various table clustering capabilities provided by Snowflake? We have you covered. In this blog post we will show you how to leverage the…

How to Perform Airflow Oracle Connection?

September 1st, 2024 By Khawaja Abdul Ahad in Data Engineering

Imagine putting hours into manually handling data tasks only to discover that one small mistake has caused the entire process to fail. Yes, it is frustrating. This is why automation…

PostgreSQL on Google Cloud SQL to Snowflake: 2 Easy Methods to Load Data

September 22nd, 2023 By Suchitra Shenoy in Data Integration, PostgreSQL, Snowflake

Unlock the full potential of your PostgreSQL on Google Cloud SQL data by integrating it seamlessly with Snowflake. With Hevo’s automated pipeline, get data flowing effortlessly—watch our 1-minute demo below…

Redshift First_Value and Last_Value Functions Made Easy

May 31st, 2024 By Dimple M K in Data Warehousing, Redshift

With the huge volumes of data being generated by enterprises today, businesses are looking for modernized means of data storage. On-premise storage options are associated with many limitations including lack…

How to Connect BigQuery to MySQL Within Minutes?

March 22nd, 2024 By Suchitra Shenoy in BigQuery, Data Integration, MySQL

Key Takeaways Connecting BigQuery to MySQL can be done in two ways: Method 1: Using Hevo DataStep 1: Configure BigQuery as the source and MySQL as a destination in Hevo’s…

How to Use Google BigQuery Subquery: Steps Explained

May 31st, 2024 By Dimple M K in BigQuery, Data Warehousing

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.…