mirror of
https://github.com/open-metadata/OpenMetadata
synced 2026-05-24 09:39:11 +00:00
483461a003
This is especially needed for instances that had already upgraded to 1.12.0 onwards, those instaces skipped the migration cherry-picked in 1.12.6
19 lines
761 B
SQL
19 lines
761 B
SQL
-- Fix PII classification autoClassificationConfig (issue #27910)
|
|
UPDATE classification
|
|
SET json = jsonb_set(
|
|
json::jsonb,
|
|
'{autoClassificationConfig}',
|
|
'{"enabled": true, "conflictResolution": "highest_priority", "minimumConfidence": 0.6, "requireExplicitMatch": true}'::jsonb
|
|
)::json
|
|
WHERE json->>'name' = 'PII'
|
|
AND json->'autoClassificationConfig'->>'enabled' IS NULL;
|
|
|
|
-- Fix PII tags autoClassificationEnabled (issue #27910)
|
|
UPDATE tag
|
|
SET json = jsonb_set(json::jsonb, '{autoClassificationEnabled}', 'true'::jsonb)::json
|
|
WHERE json->'classification'->>'name' = 'PII'
|
|
AND json->>'name' IN ('NonSensitive', 'Sensitive')
|
|
AND (
|
|
json->>'autoClassificationEnabled' IS NULL
|
|
OR (json->>'autoClassificationEnabled')::boolean = false
|
|
);
|