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 published in “Tutorial”
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…
AWS Data Migration Service (DMS) is a database migration service provided by Amazon. Using DMS, you can migrate your data from one database to another database. It supports both, homogeneous and heterogeneous database migration. DMS also supports migrating data from…
You have been running your transaction workload on MySQL for years. Occasional simple analytical queries and reporting using materialized views or ad hoc SQL in MySQL was sufficient. However, things are changing as we are becoming more digital. The volume…
Salesforce is an important CRM system and it acts as one of the basic source systems to integrate while building a data warehouse or a system for analytics. Snowflake is a Software as a Service (SaaS) which provides data warehouse…