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
_sdcprefix 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 (v2) reserved keywords
Refer to Amazon Redshift’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. |
Databricks Delta Lake (AWS) (v1) reserved keywords
| Keyword | Type | Description |
| __BO | Stitch |
Can’t be used as a suffix in column names; reserved by Stitch to accommodate changed data types. |
| __DB | 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. |
| __LG | 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 (v1) reserved keywords
Refer to Google BigQuery’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 (v2) reserved keywords
Refer to Google BigQuery’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 Synapse Analytics (v1) reserved keywords
Refer to Microsoft Azure Synapse Analytics’s documentation for the full list of keywords reserved by Microsoft Azure Synapse Analytics.
| 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. |
Microsoft SQL Server (v1) reserved keywords
Refer to Microsoft SQL Server’s documentation for the full list of keywords reserved by Microsoft SQL Server.
| 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. |
| __DT | 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. |
| __JS | 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. |
MySQL (v1) reserved keywords
Refer to MySQL’s documentation for the full list of keywords reserved by MySQL.
| 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. |
| __DT | 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. |
| __JS | 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. |
| _OLD | Stitch |
Can’t be used as a suffix in table names. |
| _STG | Stitch |
Can’t be used as a suffix in table 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. |
Panoply (v2) reserved keywords
Refer to Panoply’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 (v1) reserved keywords
Refer to PostgreSQL’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 (v1) reserved keywords
Refer to Snowflake’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. |
| Related | Troubleshooting |
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.