life is too short for a diary



Posts Tagged: sql

Optimizing SQL Queries - Understanding and Refreshing Materialized Views

When to use a materialized view? And how does it perform against a normal view. Benchmarking using docker...

Continue reading → sql database python docker



Create a Lambda Function to run SQL queries in Redshift Cluster

Amazon Redshift is fully managed warehouse service provided by AWS. The Amazon Redshift engine is a SQL-compliant, massively-parallel, query processing and database management system designed to support analytics workload...

Continue reading → python sql lambda function aws redshift