System catalog tables

Important Notice: Migration of Documentation Website

Please be advised that our documentation website is currently undergoing a migration to a new platform. To ensure you have access to the most up-to-date information, we kindly request that you visit our new documentation website located at:

Official Snowflake Snowconvert Documentation

For any immediate assistance or if you encounter any issues, please contact our support team at [email protected].

Thank you for your understanding.

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()