mirror of
https://github.com/open-metadata/OpenMetadata.git
synced 2025-07-26 10:50:44 +00:00
54 lines
1.4 KiB
Markdown
54 lines
1.4 KiB
Markdown
|
## Reverse Metadata
|
||
|
|
|
||
|
|
### Description Management
|
||
|
|
|
||
|
|
MSSQL supports description updates at the following levels:
|
||
|
|
- Schema level
|
||
|
|
- Table level
|
||
|
|
- Column level
|
||
|
|
|
||
|
|
### Owner Management
|
||
|
|
|
||
|
|
MSSQL supports owner management at the following levels:
|
||
|
|
- Database level
|
||
|
|
- Schema level
|
||
|
|
|
||
|
|
### Tag Management
|
||
|
|
|
||
|
|
❌ Tag management is not supported for MSSQL.
|
||
|
|
|
||
|
|
### Custom SQL Template
|
||
|
|
|
||
|
|
MSSQL supports custom SQL templates for metadata changes. The template is interpreted using python f-strings.
|
||
|
|
|
||
|
|
Here are examples of custom SQL queries for metadata changes:
|
||
|
|
|
||
|
|
```sql
|
||
|
|
-- Update schema description
|
||
|
|
IF NOT EXISTS (SELECT 1
|
||
|
|
FROM {database}.sys.extended_properties
|
||
|
|
WHERE name = N'MS_Description' And
|
||
|
|
major_id = SCHEMA_ID('{schema}') AND
|
||
|
|
minor_id = 0
|
||
|
|
)
|
||
|
|
BEGIN
|
||
|
|
EXEC {database}.{schema}.sp_addextendedproperty
|
||
|
|
@name = N'MS_Description',
|
||
|
|
@value = N{description},
|
||
|
|
@level0type = N'SCHEMA',
|
||
|
|
@level0name = N'{schema}'
|
||
|
|
END
|
||
|
|
ELSE
|
||
|
|
BEGIN
|
||
|
|
EXEC {database}.{schema}.sp_updateextendedproperty
|
||
|
|
@name = N'MS_Description',
|
||
|
|
@value = N{description},
|
||
|
|
@level0type = N'SCHEMA',
|
||
|
|
@level0name = N'{schema}'
|
||
|
|
END;
|
||
|
|
```
|
||
|
|
|
||
|
|
The list of variables for custom SQL can be found [here](/connectors/ingestion/workflows/reverse-metadata#custom-sql-template).
|
||
|
|
|
||
|
|
For more details about reverse metadata ingestion, visit our [Reverse Metadata Documentation](/connectors/ingestion/workflows/reverse-metadata).
|