Tag Archives: Data Warehouse

Real time data ingestion using Snowpipe

Today’s world is full of data, more appropriately ‘Big Data, with is varied dimensions of Volume, Velocity, and Variety. Of course, there are other dimensions to it as well, such as Value and Veracity, but for the sake of this blog, we can put them aside. There are numerous tools and applications that are hosted […]

AWS REDSHIFT PARTIQL- A ONE STOP QUERY LANGUAGE

In this blog, we will focus on understanding the process of using AWS Redshift PartiQL and how it can be used to analyze data in its native format. But before we move on to that, let us first define the problem statement. Data is typically spread across a combination of relational databases, non-relational data stores, […]

Why should you move to Cloud for Data Warehousing?

So far technology has been taking us for a spin, we have been drowning under that mass called data, if that is not enough Big Data keeps pulling us 5 ways (volume, velocity, variety, veracity, and value). Not painting a great picture am I, but then a host of Data engineers, Data Scientists, and infrastructure […]