Table Size

[simonB2020]

Really confused by the table size calculation provided here.

According to docs, one takes the block size and multiplies by the columns, nodes, slices etc
I'm not seeing the same calculations in the SQL query, only a concatenated string of the components ?
Maybe I am misunderstanding your intent ?

https://aws.amazon.com/premiumsupport/knowledge-center/redshift-cluster-storage-space/
Minimum table size = block_size (1 MB) *
(number_of_user_columns + 3 system columns) * number_of_cluster_nodes *
number_of_table_segments
1MB * (3+3) * 6 *1 = 36 MB

[adedotua]

Could you clarify is your question about the knowledge center or one of the amazon-redshift-utils scripts? If it is the latter could you point us to the specific script? If it is the former, then the calculation in the knowledge center article is correct. The example table the article is referencing has 3 user generated columns (a, b and c) and there are 3 system columns which are automatically added to any local user table created in Redshift. The number of table segments is 1 because the table does not have a sortkey. When a sortkey is added to a table, it will have two segments - sorted and unsorted. Finally, all blocks in Redshift are 1MB in size.