Redshift Observatory

System Table Tracker

System view pg_catalog.svv_copy_job_integrations version 1.0.77272 / 2024-11-01

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