Redshift Observatory

System Table Tracker

System view pg_catalog.svv_copy_job_integrations version 1.0.76913 / 2024-10-24

schema	name	column	data type
pg_catalog	svv_copy_job_integrations	bucket	text
pg_catalog	svv_copy_job_integrations	channel_arn	name
pg_catalog	svv_copy_job_integrations	channel_state	name
pg_catalog	svv_copy_job_integrations	db_name	name
pg_catalog	svv_copy_job_integrations	job_name	text
pg_catalog	svv_copy_job_integrations	job_owner	int4
pg_catalog	svv_copy_job_integrations	job_state	int4

View Text

SELECT pg_auto_copy_job.job_owner,
       pg_integration_filter.channel_arn,
       pg_integration_filter.filter AS bucket,
       pg_integration.state AS channel_state,
       current_database() AS db_name,
       pg_auto_copy_job.job_name,
       pg_auto_copy_job.job_state
FROM pg_auto_copy_job
     LEFT JOIN pg_integration_filter ON pg_auto_copy_job.oid = pg_integration_filter.dependency_id
     LEFT JOIN pg_integration ON pg_integration_filter.channel_arn = pg_integration.full_channel_arn
WHERE pg_integration_filter.dbid = (SELECT pg_database.oid
                                    FROM pg_database
                                    WHERE pg_database.datname = current_database())
  AND has_copy_job_privilege(CAST("current_user"() AS name),
                             pg_auto_copy_job.oid)

Home 3D Друк Blog Bring-Up Times Consultancy Cross-Region Benchmarks Email Forums IRC Mailing Lists Reddit Redshift Price Tracker Redshift Version Tracker Redshift Workbench System Table Tracker The Known Universe Twitter White Papers