DOCS >REPLICATION >LOADING >STITCH AND DESTINATION RESERVED KEYWORDS

Get started with a free trial today

Already have an account? Sign in

Stitch and Destination Reserved Keywords

A reserved keyword is a word that has a special meaning, and is therefore “reserved from use.” Reserved keywords are also known asreserved 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 asreserved 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 theKeyword 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 therejected records log.

An error will also surface in theNotifications tab in Stitch.

Reserved keyword reference

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

Note: Keywords arecase-insensitive. This means thatABC,aBc,abc, etc. are all considered the same.

Amazon Redshift (v2) reserved keywords

Refer toAmazon 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 toGoogle 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 toGoogle 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 toMicrosoft 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 toMicrosoft 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 toMySQL’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 toPanoply’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 toPostgreSQL’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 toSnowflake’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
Syncing Data Syncing New Columns Replication Methods Replication Keys Resetting Replication Keys	Data Discrepancy Guide Missing Objects Missing Columns & NULL Values Non-Replicating Data & Unsupported Data Types Destination & Integration Compatibility

Questions? Feedback?

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

Movatterモバイル変換