System catalog tables

This is a work in progress.

Description

The system catalogs store schema metadata, such as information about tables and columns. System catalog tables have a PG prefix.

The standard PostgreSQL catalog tables are accessible to Amazon Redshift users. (Redshift SQL Language reference System catalog tables).

The following table outlines how SnowConvert transforms references to SQL functions defined in the pg_catalog in Redshift.

Mapping of SQL functions from the pg_catalog

Redshift	Snowflake
pg_catalog.row_number()	row_number()
pg_catalog.replace()	replace()
pg_catalog.lead()	lead()