Hi all,
In an effort to improve our metadata (for documentation purposes and AI integration), I want to add descriptions to our columns. Since we’re on Azure SQL database commenting when creating tables is not an option (AFAIK). So I’m using the dbo._metabase_metadata table.
However, I haven’t found a solution for specifying the schema in this metadata table. It only seems to work with ‘table.field.description’. I’m managing different labels, each with the same layout in tables. So I have ‘label1.accounts.name.description’ , ‘label2.accounts.name.description’ , etc.
Can I specify the schema in the metadata table?
Thanks in advance.
EDIT: The reason I want to store this data in a table in my database as opposed to just using the data studio and fill in descriptions manually, is because I’m on the OSS version that doesn’t support granular permissions on native queries to the database. So I’m making multiple connections and managing SELECT permissions in my database. That means I would need to define every column X times for every connection I have. If a description changes, I’d need to change it X times as well. I’m hoping that every connection will pull the changed description automatically from dbo._metabase_metadata.
EDIT2: I looked in the source code and there’s an open TODO describing exactly this issue. So for now it’s not possible yet.