This article helps you uncover the unique features of Snowflake Data Warehouse. You will also get a quick walk-through on the implementation of some of the important features such as schemaless loading of JSON/XML, Time Travel, Cloning, Data Clustering, etc.,…
Posts published in “Engineering”
This article helps focuses on an in-depth understanding of Snowflake architecture, how it stores and manages data, and its micro-partitioning concepts. By the end of this blog, you will also be able to understand how Snowflake architecture is different from…
Amazon Redshift is a fully managed, distributed relational database system. It is capable of performing queries efficiently over petabytes of data. Redshift has become a natural choice to many for the data warehousing needs. This makes it important to…
MongoDB To Redshift ETL MongoDB is a NoSQL database which means SQL queries cannot be directly run on MongoDB. Hence, it is necessary to bring MongoDB’s data to a relational format data warehouse like AWS Redshift to perform analytical queries.…
As your application gains traction, size of data that you have to analyze increases exponentially. After a certain point, your queries start taking a lot of time, size of data becomes unmanageable on conventional databases. Consequently, you start looking for…
Amazon Redshift is a petabyte-scale data warehouse, managing such mammoth disk space is no easy job. Unlike traditional databases which have limited disk space and performs housekeeping activity without user intervention, Redshift leaves it up to the user to…
