Google BigQuery – a fully managed cloud data warehouse for analytics from Google Cloud Platform(GCP), is one of the most popular cloud-based analytics solutions. Due to its unique architecture and seamless integration with other services from GCP, there are certain…
Posts published in “Engineering”
DynamoDB is Amazon’s document-oriented, high performance, NoSQL database. Given it is a NoSQL database, it is hard to run SQL queries to analyze the data. It is essential to move data from DynamoDB to Redshift, convert it into a relational…
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.,…
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.…
