Some time ago I wrote a blog post on why use WHERE 1=1 in SQL. This time it’s why use WHERE 1=2, but really this can be WHERE 1=9 or anything that isn’t a 1, we just want the false statement.
A handy post to note down the JDBC client driver download. I’m frequently in need of this myself.You can download the JDBC driver from the AWS Docs and then gain your cluster endpoint address from the main Redshift dashboard windowInstead of doing the above, you navigate to the Configure tab in the Redshift console and download the JDBC driver &
This post contains a SQL script that will return all schemas, tables and columns in Redshift or Postgres.I’m combining the Redshift and Postgres database blog categories here.
Here’s a simple guide on creating a new AWS RedShift Cluster within a personal AWS test environment.Warning, if you’re testing this AWS Service you have to be rigorous with managing the cluster for billing reasons.