mirror of
https://github.com/open-metadata/OpenMetadata
synced 2026-05-24 09:39:11 +00:00
31e2e59a00
* Fix #26178: Add support for IAM auth for redshift * Missing files for the implementation * Update generated TypeScript types * adderess guitar comments * address comments * fix python tests * fix redshift playright * fix checkstyle --------- Co-authored-by: github-actions[bot] <github-actions[bot]@users.noreply.github.com>
10 lines
439 B
SQL
10 lines
439 B
SQL
-- 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');
|