mirror of
https://github.com/open-metadata/OpenMetadata
synced 2026-05-24 09:39:11 +00:00
11 lines
439 B
MySQL
11 lines
439 B
MySQL
|
-- Migrate Redshift connection: move password into authType.password (basicAuth)
|
||
|
|
UPDATE dbservice_entity
|
||
|
|
SET json = jsonb_set(
|
||
|
|
json #- '{connection,config,password}',
|
||
|
|
'{connection,config,authType}',
|
||
|
|
jsonb_build_object('password', json #> '{connection,config,password}')
|
||
|
|
)
|
||
|
|
WHERE serviceType = 'Redshift'
|
||
|
|
AND json #> '{connection,config,password}' IS NOT NULL
|
||
|
|
AND NOT jsonb_exists(json #> '{connection,config}', 'authType');
|