Category Archives: etl
How do I unlock blocking queries in Amazon Redshift?
I noticed my dimension table was stuck when I query it for etl job and the truncate statement fails to return. “Locking is a protection mechanism that controls how many sessions can access a table at the same time and … Continue reading
Posted in etl Leave a comment
mysql tricks: do instant table swap to mitigate mysql deadlock error.
mysql tricks: do instant table swap to mitigate mysql deadlock error. Continue reading
Posted in etl, relational databases, Uncategorized Tagged database, dba, etl, sql, tips Leave a comment
Best Practices for Micro-Batch Loading on Amazon Redshift
Best Practices for Micro-Batch Loading on Amazon Redshift Article by AWS blog I work with Redshift everyday now at Amazon. It’s very useful big data warehouse tool. Here’s a blog post about loading data into it. It’s very s3 dependent … Continue reading
Posted in big data, data wrangling, etl Tagged database, etl, postgresql, redshift Leave a comment