Show column data type in schema browser


#1

It would be really useful if the schema browser displayed the data type of columns.

For example if there’s a column called start_time, it’s not clear if this is actually a datetime, time or string. This matters if the user wants to know how to structure a WHERE clause or add a parameter to the query.

Similarly with numeric data types, for example it can be very important to know if data is being stored as a numeric or floating point data type as floating point arithmetic can lead to inaccuracies and it’s not always possible to discover this just by looking at the data.

You might also want to consider an extensible way to show custom properties e.g. indicate which is the distribution column in systems like Teradata and Redshift.