Redshift performance investigation
Trying to make an attempt to build better performing redshift tables… Queries that has lot of wait, DDL recommendations, etc.
Knowledge is Power
Trying to make an attempt to build better performing redshift tables… Queries that has lot of wait, DDL recommendations, etc.
I am not able to connect to Redshift and getting error [Amazon](500310) Invalid operation: no pg_hba.conf entry for host user SSL off;
🙁 🙁
So lately I got stumped by not having the ability to extract DDL/ table definition for a table in Redshift. Quick searches on the internet resulted in… below query, SELECT * FROM pg_table_def WHERE tablename = ‘table_name’ AND schemaname =...
More