Redshift Research Project

System Table Tracker

System Table Version 1.0.41465 / 2022-09-10

schema name column data type
pg_catalog svv_identity_providers enabled bool
pg_catalog svv_identity_providers instanceid varchar(256)
pg_catalog svv_identity_providers name varchar(128)
pg_catalog svv_identity_providers namespc varchar(128)
pg_catalog svv_identity_providers params varchar(2048)
pg_catalog svv_identity_providers type varchar(128)
pg_catalog svv_identity_providers uid int4

View Text

SELECT (pg_identity_provider.uid)::integer AS uid, ( varying(128) AS name, (pg_identity_provider."type")::character varying(128) AS "type", (pg_identity_provider.instanceid)::character varying(256) AS instanceid, (pg_identity_provider.namespc)::character varying(128) AS namespc, (regexp_replace(pg_identity_provider.params, '(client_secret|client_x5t|client_pk_base64|client_pk_password)"[\\s]*:[\\s]*\\K"(.*?)"'::text, '\'\''::text, 1, 'p'::text))::character varying(2048) AS params, pg_identity_provider.enabled FROM pg_identity_provider;
AWS in their views sometimes use SQL which is not compatible with Postgres syntax (typically, using an unnamed subquery) and this breaks the Postgres pretty printer I use. AWS do not publish a BNF for Redshift SQL, so there are no Redshift pretty printers; you now get one long line of text, which is still better than the text actually being censored, which is what seems to be happening now with the new SYS views.

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