mirror of
https://github.com/open-metadata/OpenMetadata
synced 2026-05-24 09:39:11 +00:00
20 lines
761 B
MySQL
20 lines
761 B
MySQL
|
-- 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
|
||
|
|
);
|