Documentation Tab
A
Amin Khorrami
besides being able to comment, is there anything this section does not solve for you on schema/type discovery?
And would you be open to store comments on the schema on datakit cloud?
F
Fred Guth
Amin Khorrami, I was not very clear. I don't want to comment. What I need is a place that shows the comment column of the table which is the column where normally there is the description of what that column is.
In information_schema you will find in comment columns information on what a column, table or view is. This is important to understand what is the data you are seeing.
In datalakes like Databricks there is a Tab (actually it is a menu on the left) which is called catalog which you can use to navigate on all schemas, tables and views of a base and when you are looking at a specific table or view.
You will use table comment and view comment to describe the table and view. When in a specific table or view, you will see column_name, type, is_nullable and comment where comment is the place describing the column.
l
luke
Fred Guth: Thanks for the feedback, Fred! This helps a lot.
I've created a feature request to add metadata/schema discovery to DataKit - specifically showing column comments and table descriptions when they're embedded in the data source (information_schema tables will be great too as we move more into multi-tab views and querying).
For datasets without existing metadata, we're exploring auto-suggestions (clearly labelled as such) based on column patterns and data types. Do you feel like this would be helpful?
A few follow-up questions to help us prioritise:
-Would you want to add and save your own column descriptions directly in DataKit or prefer us to indicate this should be done at source?
-Do you typically work with databases that have information_schema, or more with files (CSV/Excel) that lack this metadata?
Appreciate the Databricks reference!