SnowConvert: Redshift System catalog tables¶
Note
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 (https://docs.aws.amazon.com/redshift/latest/dg/c_intro_catalog_views.html)).
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() |