Airbyte_Useful

Esta é uma pré-visualização de arquivo. Entre para ver o arquivo original

SELECT * FROM airbyte_configs
WHERE 
	config_type = 'STANDARD_SYNC'
;
SELECT config_blob -> 'configuration' ->> 'access_token' AS access_token 
FROM airbyte_configs
WHERE config_id = '6146957c-ea30-4eb9-b348-3b3b7d70e207';
UPDATE 
	airbyte_configs
SET 
	config_blob = jsonb_set(config_blob::jsonb, '{manual}', 'true')
WHERE
	config_type = 'STANDARD_SYNC'
;
TRUNCATE jobs;
TRUNCATE attempts;
SELECT * FROM airbyte_configs
WHERE 
	config_blob ->> 'sourceDefinitionId' = 'ef69ef6e-aa7f-4af1-a01d-ef775033524e'
;
DELETE FROM airbyte_configs
WHERE 
	config_blob ->> 'sourceDefinitionId' = 'ef69ef6e-aa7f-4af1-a01d-ef775033524e'
AND 
	config_type != 'STANDARD_SOURCE_DEFINITION'
;
DELETE FROM airbyte_configs
WHERE 
	config_type = 'STANDARD_SYNC'
AND 
	config_blob ->> 'prefix' != 'jira-'
;
SELECT * FROM jira.jira_issue_fields
WHERE 
	id = 'project'
OR
	id = 'statuscategorychangedate';
SELECT * FROM jira.jira_projects;
SELECT * FROM jira.jira_issues
LIMIT 10;
DROP SCHEMA jira CASCADE;
CREATE SCHEMA jira;
GRANT ALL PRIVILEGES ON SCHEMA jira TO airbyte;
GRANT USAGE ON SCHEMA jira TO airbyte;
DROP TABLE github._airbyte_raw_git_reviews;
DROP TABLE github._airbyte_raw_git_teams;
DROP TABLE github._airbyte_tmp_mpm_git_teams;
DROP TABLE github._airbyte_tmp_dxq_git_reviews;