PostgreSQL, although is primarily used as an OLTP Database, is one of the popular tools for analyzing data at scale. Its novel architecture, reliability at scale, robust feature set, and extensibility give an advantage over other databases. However, as the…
Posts tagged as “Data Integration”
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…
AWS Data Pipeline is a data movement and data processing service provided by Amazon. Using Data Pipeline you can perform data movement and processing as per your requirement. Data pipeline also supports scheduling of pipeline processing. You can also perform…
AWS Glue is a serverless ETL service provided by Amazon. Using Glue, you pay only for the time you run your query. In Glue, you create a metadata repository (data catalog) for all RDS engines including Aurora, Redshift, and S3…
