mirror of
https://github.com/open-metadata/OpenMetadata.git
synced 2025-07-05 08:05:28 +00:00
43 lines
1.2 KiB
SQL
43 lines
1.2 KiB
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';
|
|
|
|
|
|
-- update the timestamps to millis for dbt test results
|
|
UPDATE data_quality_data_time_series dqdts
|
|
SET json = jsonb_set(
|
|
dqdts.json::jsonb,
|
|
'{timestamp}',
|
|
to_jsonb(((dqdts.json ->> 'timestamp')::bigint)*1000)
|
|
)
|
|
WHERE dqdts.extension = 'testCase.testCaseResult'
|
|
AND (json->>'timestamp') ~ '^[0-9]{10}$';
|
|
|
|
|
|
|
|
UPDATE search_service_entity
|
|
SET json = JSONB_SET(
|
|
json::jsonb,
|
|
'{connection,config}',
|
|
json::jsonb #> '{connection,config}' #- '{caCert}' ||
|
|
jsonb_build_object(
|
|
'sslConfig',
|
|
jsonb_build_object(
|
|
'certificates',
|
|
jsonb_build_object('caCertPath', json #> '{connection,config,caCert}')
|
|
)
|
|
),
|
|
true
|
|
)
|
|
WHERE
|
|
serviceType = 'ElasticSearch'
|
|
AND json #> '{connection,config,caCert}' IS NOT NULL;
|