Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

The descriptions of the database and schemes from the mssql are not pulled up #19553

Open
feride-sh opened this issue Jan 28, 2025 · 0 comments
Assignees
Labels
enhancement New feature or request Ingestion

Comments

@feride-sh
Copy link

Affected module
backend

Describe the bug
The database and schemas are not pulled up, since they are not in the table 'sys.objects' and the descriptions from the 'sys.extended_propertiesare' not pulled up

MSSQL_GET_TABLE_COMMENTS = textwrap.dedent(
    """
SELECT obj.name AS table_name,
        ep.value AS table_comment,
        s.name AS "schema"
FROM sys.objects AS obj
LEFT JOIN sys.extended_properties AS ep
    ON obj.object_id = ep.major_id AND ep.minor_id = 0 AND ep.name = 'MS_Description'
JOIN sys.schemas AS s
    ON obj.schema_id = s.schema_id
WHERE
    obj.type IN ('U', 'V') /* User tables and views */ -- HERE. Only this code use 'sys.extended_properties'. Procedures is type 'P'
"""
)

Expected behavior
The description of the databases and schemas is transferred and updated from mssql to omd

Version:
OpenMetadata version: 1.6.2

@ulixius9 ulixius9 added Ingestion enhancement New feature or request labels Jan 28, 2025
@ulixius9 ulixius9 self-assigned this Jan 28, 2025
@ulixius9 ulixius9 moved this to Integration in Release 1.7.0 Jan 28, 2025
@ulixius9 ulixius9 added this to the Feb 25 - Sprint 1 milestone Jan 28, 2025
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
enhancement New feature or request Ingestion
Projects
Status: Integration
Development

No branches or pull requests

2 participants