Redshift Join: How to use Redshift's Join Clause
Redshift’s JOIN clause is perhaps the second most important clause after SELECT clause, and it is used even more ubiquitously, considering how interconnected a typical application database’s tables are. Due to that connectivity between datasets, data developers require many joins to collect and p...
Redshift Vacuum: Optimize your Redshift tables
Because Redshift does not automatically “reclaim” the space taken up by a deleted or updated row, occasionally you’ll need to resort your tables and clear out any unused space. Doing so can optimize performance and reduce the number of nodes you need to host your data (thereby reducing costs). Th...
AWS Redshift Pricing: How much does Redshift cost?
What is Redshift’s pricing model and how much will Redshift cost me?
While Redshift is arguably the best data warehouse on the market, it can come with a hefty price tag. We’ve created this Redshift pricing guide to help you evaluate Redshift cheaply, create a budget for full implementation, and...
What is Big Data?
As we proceed through this age of massive information and great technologies, we are obtaining many more angles from which we can record data. As a result, organizations like Google, Amazon, Facebook, Netflix, and Twitter are finding more and more uses for the information gained from analyzing th...
Redshift Table Size: How to find the size of a table in Redshift
SVVTABLEINFO is a Redshift systems table that shows information about user-defined tables (not other system tables) in a Redshift database. The table is only visible to superusers.
To get the size of each table, run the following command on your Redshift cluster:
SELECT “table”, size, tblrows F...