mirror of
https://github.com/open-metadata/OpenMetadata.git
synced 2025-07-07 09:09:30 +00:00
14 lines
486 B
SQL
14 lines
486 B
SQL
|
|
-- fixed Query for updating viewParsingTimeoutLimit
|
|
UPDATE ingestion_pipeline_entity
|
|
SET json = jsonb_set(
|
|
json::jsonb #- '{sourceConfig,config,viewParsingTimeoutLimit}',
|
|
'{sourceConfig,config,queryParsingTimeoutLimit}',
|
|
(json #> '{sourceConfig,config,viewParsingTimeoutLimit}')::jsonb,
|
|
true
|
|
)
|
|
WHERE json #>> '{pipelineType}' = 'metadata'
|
|
AND json #>> '{sourceConfig,config,type}' = 'DatabaseMetadata'
|
|
AND json #>> '{sourceConfig,config,viewParsingTimeoutLimit}' is not null;
|
|
|