Taking into consideration an example of hive tables / databricks:
If I need column level statistics what i do is:
ANALYZE TABLE <db.table> COMPUTE STATISTICS FOR COLUMNS <column>
DESCRIBE EXTENDED <db.table> <column>
Similarly I've seen there's no command called DESCRIBE in Redshift.
Now i'm expecting the same workaround in Redshift.
What is the output I am expecting:
Statistics like:
- Min
- Max
- Avg Length
- Max Length
- Distinct
- Null
What internal tables do i need to look into? Also if I need to join multiple internal tables to get the aforementioned stats.