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.

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.


Reserved keyword reference

In Stitch, there are two types of keywords:

Stitch reserved keywords

The following table provides the list of reserved keywords in Stitch, the reason, and the destination(s) the keyword applies to.

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

Keyword Comment Applies to
_SDC

Can’t be used in table or column names.

All destinations
_RJM

Can’t be used in table or column names.

All destinations
__BI

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

  • Amazon Redshift
  • Panoply.io
  • PostgreSQL
__BO

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

  • Amazon Redshift
  • Google BigQuery
  • Panoply.io
  • PostgreSQL
  • Snowflake
__DE

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

  • Amazon Redshift
  • Panoply.io
  • PostgreSQL
  • Snowflake
__DO

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

  • Amazon Redshift
  • Panoply.io
  • PostgreSQL
__FL

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

  • Google BigQuery
  • Snowflake
__INST

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

  • Microsoft Azure SQL Data Warehouse
__IT

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

  • Amazon Redshift
  • Google BigQuery
  • Panoply.io
  • PostgreSQL
  • Snowflake
__NU

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

  • Google BigQuery
__ST

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

  • Amazon Redshift
  • Google BigQuery
  • Panoply.io
  • PostgreSQL
  • Snowflake
__TI

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

  • Amazon Redshift
  • Google BigQuery
  • Panoply.io
  • PostgreSQL
  • Snowflake
__VA

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

  • Snowflake

Destination reserved keywords

In addition to the keywords Stitch reserves, each destination also has its own list of reserved or limited keywords. For more info, including a list of reserved keywords, refer to your destination’s official documentation:



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.