Hello All,
After ingesting metadata from redshift,...
# ingestione
echoing-evening-57052
05/24/2023, 12:01 PMHello All,
After ingesting metadata from redshift, I am unable to see information for constraints like primary key and foreign key in schema part of dataset. Is there anything specific while ingesting data from redshift?
Can anyone suggest anything in this?
d
dazzling-judge-80093
05/24/2023, 12:02 PMDoes it show dist/sort keys?
e
echoing-evening-57052
05/24/2023, 12:03 PMNo.I am not able to see any keys or constraint related information.
echoing-evening-57052
05/24/2023, 12:04 PMConstraints are viewable in mariadb ingestion but not in redshift ingestion
d
dazzling-judge-80093
05/24/2023, 12:04 PMNormally you should see dist/sort keys like this ->
e
echoing-evening-57052
05/24/2023, 12:05 PMThis is also missing for me!
d
dazzling-judge-80093
05/24/2023, 12:06 PMwhich version of datahub client do you use?
Do you have dist/sort key defined for your tables?
e
echoing-evening-57052
05/24/2023, 12:08 PMAm using 0.10.2-3 version.
not dist/sort key but I do have primary and foreign keys
d
dazzling-judge-80093
05/24/2023, 12:10 PMI’m not sure if we capture the primary/foreign key for Redshift now,
Please, can you create a GitHub issue?
Unfortunately on Redshift primary and foreign keys are not enforced.
e
echoing-evening-57052
05/24/2023, 12:11 PMOkay.Sure! Thank you for the help!
echoing-evening-57052
05/24/2023, 12:11 PMOne more question , can you help me with openAPI to get all the datasets from datahub?
echoing-evening-57052
05/24/2023, 12:12 PMI have tried with one exposed get api but that works as search
echoing-evening-57052
05/24/2023, 12:13 PMmeans there we need to pass one dataset URN as param to fetch metadata for that particular dataset