A reserved keyword is a word that has a special meaning, and is therefore “reserved from use.” Reserved keywords are also known as reserved identifiers.

In this guide, we’ll cover:


Reserved keyword basics

What's a reserved keyword?

A reserved keyword is a word that has a special meaning, and is therefore “reserved from use.” Reserved keywords are also known as reserved identifiers.

In Stitch, there are two types of reserved keywords:

  • Stitch reserved keywords, or words that are reserved to Stitch. For example: The _sdc prefix used in Stitch system tables and columns.
  • Destination reserved keywords, or words that are reserved by a destination.

Why can't I use reserved keywords?

Stitch reserves its own keywords to ensure your data is loaded accurately. Additionally, each destination has its own list of reserved keywords and its own reasons for reserving those words.

Refer to the Keyword reference section for info about the keywords reserved for each destination.

What happens to data that contains reserved keywords?

If a table or column contains a reserved keyword, the destination will reject the data and create a record in the rejected records log.

An error will also surface in the Notifications tab in Stitch.


Reserved keyword reference

In this section are the reserved keywords for each destination supported by Stitch.

Note: Keywords are case-insensitive. This means that ABC, aBc, abc, etc. are all considered the same.

Amazon Redshift reserved keywords

Refer to Amazon Redshift Documentation’s documentation for the full list of keywords reserved by Amazon Redshift.

Keyword Type Description
__BI Stitch

Can’t be used as a suffix in column names; reserved by Stitch to accommodate changed data types.

__BO Stitch

Can’t be used as a suffix in column names; reserved by Stitch to accommodate changed data types.

__DE Stitch

Can’t be used as a suffix in column names; reserved by Stitch to accommodate changed data types.

__DO Stitch

Can’t be used as a suffix in column names; reserved by Stitch to accommodate changed data types.

__IT Stitch

Can’t be used as a suffix in column names; reserved by Stitch to accommodate changed data types.

__ST Stitch

Can’t be used as a suffix in column names; reserved by Stitch to accommodate changed data types.

__TI Stitch

Can’t be used as a suffix in column names; reserved by Stitch to accommodate changed data types.

_SDC Stitch

Can’t be used as a prefix in table or column names.

_RJM Stitch

Can’t be used as a prefix in table or column names.

Google BigQuery reserved keywords

Refer to Google BigQuery (v1) Documentation’s documentation for the full list of keywords reserved by Google BigQuery.

Keyword Type Description
__BO Stitch

Can’t be used as a suffix in column names; reserved by Stitch to accommodate changed data types.

__FL Stitch

Can’t be used as a suffix in column names; reserved by Stitch to accommodate changed data types.

__IT Stitch

Can’t be used as a suffix in column names; reserved by Stitch to accommodate changed data types.

__NU Stitch

Can’t be used as a suffix in column names; reserved by Stitch to accommodate changed data types.

__ST Stitch

Can’t be used as a suffix in column names; reserved by Stitch to accommodate changed data types.

__TI Stitch

Can’t be used as a suffix in column names; reserved by Stitch to accommodate changed data types.

_FILE_ Destination

Can’t be used as a prefix in column names.

_PARTITION_ Destination

Can’t be used as a prefix in column names.

_ROW_TIMESTAMP Destination

Can’t be used as a prefix in column names.

_TABLE_ Destination

Can’t be used as a prefix in column names.

_SDC Stitch

Can’t be used as a prefix in table or column names.

_RJM Stitch

Can’t be used as a prefix in table or column names.

Google BigQuery reserved keywords

Refer to Google BigQuery (v2) Documentation’s documentation for the full list of keywords reserved by Google BigQuery.

Keyword Type Description
__BO Stitch

Can’t be used as a suffix in column names; reserved by Stitch to accommodate changed data types.

__FL Stitch

Can’t be used as a suffix in column names; reserved by Stitch to accommodate changed data types.

__IT Stitch

Can’t be used as a suffix in column names; reserved by Stitch to accommodate changed data types.

__NU Stitch

Can’t be used as a suffix in column names; reserved by Stitch to accommodate changed data types.

__ST Stitch

Can’t be used as a suffix in column names; reserved by Stitch to accommodate changed data types.

__TI Stitch

Can’t be used as a suffix in column names; reserved by Stitch to accommodate changed data types.

_FILE_ Destination

Can’t be used as a prefix in column names.

_PARTITION_ Destination

Can’t be used as a prefix in column names.

_ROW_TIMESTAMP Destination

Can’t be used as a prefix in column names.

_TABLE_ Destination

Can’t be used as a prefix in column names.

_SDC Stitch

Can’t be used as a prefix in table or column names.

_RJM Stitch

Can’t be used as a prefix in table or column names.

Microsoft Azure SQL Data Warehouse reserved keywords

Refer to Microsoft Azure SQL Data Warehouse Documentation’s documentation for the full list of keywords reserved by Microsoft Azure SQL Data Warehouse.

Keyword Type Description
__BO Stitch

Can’t be used as a suffix in column names; reserved by Stitch to accommodate changed data types.

__DE Stitch

Can’t be used as a suffix in column names; reserved by Stitch to accommodate changed data types.

__FL Stitch

Can’t be used as a suffix in column names; reserved by Stitch to accommodate changed data types.

__INST Stitch

Can’t be used as a suffix in column names; reserved by Stitch to accommodate changed data types.

__ST Stitch

Can’t be used as a suffix in column names; reserved by Stitch to accommodate changed data types.

_SDC Stitch

Can’t be used as a prefix in table or column names.

_RJM Stitch

Can’t be used as a prefix in table or column names.

Panoply reserved keywords

Refer to Panoply Documentation’s documentation for the full list of keywords reserved by Panoply.

Keyword Type Description
__BI Stitch

Can’t be used as a suffix in column names; reserved by Stitch to accommodate changed data types.

__BO Stitch

Can’t be used as a suffix in column names; reserved by Stitch to accommodate changed data types.

__DE Stitch

Can’t be used as a suffix in column names; reserved by Stitch to accommodate changed data types.

__DO Stitch

Can’t be used as a suffix in column names; reserved by Stitch to accommodate changed data types.

__IT Stitch

Can’t be used as a suffix in column names; reserved by Stitch to accommodate changed data types.

__ST Stitch

Can’t be used as a suffix in column names; reserved by Stitch to accommodate changed data types.

__TI Stitch

Can’t be used as a suffix in column names; reserved by Stitch to accommodate changed data types.

_SDC Stitch

Can’t be used as a prefix in table or column names.

_RJM Stitch

Can’t be used as a prefix in table or column names.

PostgreSQL reserved keywords

Refer to PostgreSQL Documentation’s documentation for the full list of keywords reserved by PostgreSQL.

Keyword Type Description
__BI Stitch

Can’t be used as a suffix in column names; reserved by Stitch to accommodate changed data types.

__BO Stitch

Can’t be used as a suffix in column names; reserved by Stitch to accommodate changed data types.

__DE Stitch

Can’t be used as a suffix in column names; reserved by Stitch to accommodate changed data types.

__DO Stitch

Can’t be used as a suffix in column names; reserved by Stitch to accommodate changed data types.

__IT Stitch

Can’t be used as a suffix in column names; reserved by Stitch to accommodate changed data types.

__ST Stitch

Can’t be used as a suffix in column names; reserved by Stitch to accommodate changed data types.

__TI Stitch

Can’t be used as a suffix in column names; reserved by Stitch to accommodate changed data types.

_SDC Stitch

Can’t be used as a prefix in table or column names.

_RJM Stitch

Can’t be used as a prefix in table or column names.

Snowflake reserved keywords

Refer to Snowflake Documentation’s documentation for the full list of keywords reserved by Snowflake.

Keyword Type Description
__BO Stitch

Can’t be used as a suffix in column names; reserved by Stitch to accommodate changed data types.

__DE Stitch

Can’t be used as a suffix in column names; reserved by Stitch to accommodate changed data types.

__FL Stitch

Can’t be used as a suffix in column names; reserved by Stitch to accommodate changed data types.

__IT Stitch

Can’t be used as a suffix in column names; reserved by Stitch to accommodate changed data types.

__ST Stitch

Can’t be used as a suffix in column names; reserved by Stitch to accommodate changed data types.

__TI Stitch

Can’t be used as a suffix in column names; reserved by Stitch to accommodate changed data types.

__VA Stitch

Can’t be used as a suffix in column names; reserved by Stitch to accommodate changed data types.

_SDC Stitch

Can’t be used as a prefix in table or column names.

_RJM Stitch

Can’t be used as a prefix in table or column names.



Questions? Feedback?

Did this article help? If you have questions or feedback, feel free to submit a pull request with your suggestions, open an issue on GitHub, or reach out to us.