would like to expose ddl comments or add my own to help other users with understanding the curated data.
Hey @hson, you should be able to add/save comments in the SQL definition of a virtual dataset. Unfortunately, support for this for physical datasets (i.e. tables in sources) is not available right now.
That said, improving our data catalog experience is a priority. We have roadmap items to allow for better collaboration – exploring things like comments, annotations, popularity/usage metrics. Would be great to get more details on your use case/needs.
This is probably not what you’re looking for, but in case it is useful in some way…
The following types of comments will work:
/*
This is a multi-line comment.
Cheers!
*/
SELECT *
–This is a comment
FROM sys.version --WHERE version = so.wow
If you save this SQL as a virtual dataset, Dremio will save your comments. When you open the virtual dataset and open the SQL editor, you’ll see:
If you then click “Edit Original SQL” you’ll see your comments.
@can - What is the correct syntax? Is it like postgres style:
COMMENT ON COLUMN insight_ods_semantic_layer.dim_ms_user.terminal_name IS ‘The name of the terminal that generated this record.’;
Or are referring to regular code comments like Kelly mentioned.
Thanks!
@elliotbenjamin we currently support regular code comments. Our plan is to improve this experience to support dataset, space/source and column annotations.
I everybody,
Re opening the topics because it’s totaly what I’m wanted to discuss.
I’m currently in internship and I’m studying the possibility to use Dremio for my company in the future.
But I don’t find any possibility to add any comments to datasets (virtual or physical).
Am I missing something or is it still yet not available ?
1 Like