# 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 as **reserved identifiers**.

In this guide, we’ll cover:

* [Some reserved keyword basics](https://help.qlik.com/en-US/stitch/data-structure/reserved-keywords#reserved-keyword-basics)

* [The keywords reserved by Stitch and its destinations](https://help.qlik.com/en-US/stitch/data-structure/reserved-keywords#reserved-keyword-reference)

## Reserved keyword basics

* [What’s a reserved keyword?](https://help.qlik.com/en-US/stitch/data-structure/reserved-keywords#what-is-a-reserved-keyword)

* [Why can’t I use reserved keywords?](https://help.qlik.com/en-US/stitch/data-structure/reserved-keywords#why-cant-i-use-reserved-keywords)

* [What happens to data that contains reserved keywords?](https://help.qlik.com/en-US/stitch/data-structure/reserved-keywords#data-containing-reserved-keywords)

### 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](https://help.qlik.com/en-US/stitch/data-structure/reserved-keyword-reference) 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](https://help.qlik.com/en-US/stitch/replication/loading/system-tables-columns/rejected-records-system-table).

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)](https://help.qlik.com/en-US/stitch/data-structure/reserved-keywords#redshift-v2-reserved-keywords)

* [Databricks Delta Lake (AWS) (v1)](https://help.qlik.com/en-US/stitch/data-structure/reserved-keywords#databricks-delta-v1-reserved-keywords)

* [Google BigQuery (v1)](https://help.qlik.com/en-US/stitch/data-structure/reserved-keywords#bigquery-v1-reserved-keywords)

* [Google BigQuery (v2)](https://help.qlik.com/en-US/stitch/data-structure/reserved-keywords#bigquery-v2-reserved-keywords)

* [Microsoft Azure Synapse Analytics (v1)](https://help.qlik.com/en-US/stitch/data-structure/reserved-keywords#microsoft-azure-v1-reserved-keywords)

* [Microsoft SQL Server (v1)](https://help.qlik.com/en-US/stitch/data-structure/reserved-keywords#microsoft-sql-server-v1-reserved-keywords)

* [MySQL (v1)](https://help.qlik.com/en-US/stitch/data-structure/reserved-keywords#mysql-v1-reserved-keywords)

* [Panoply (v2)](https://help.qlik.com/en-US/stitch/data-structure/reserved-keywords#panoply-v2-reserved-keywords)

* [PostgreSQL (v1)](https://help.qlik.com/en-US/stitch/data-structure/reserved-keywords#postgres-v1-reserved-keywords)

* [Snowflake (v1)](https://help.qlik.com/en-US/stitch/data-structure/reserved-keywords#snowflake-v1-reserved-keywords)

### Amazon Redshift (v2) reserved keywords

Refer to [Amazon Redshift’s documentation](https://docs.aws.amazon.com/redshift/latest/dg/r_pg_keywords.html) 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](https://cloud.google.com/bigquery/docs/reference/standard-sql/lexical#reserved-keywords) 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](https://cloud.google.com/bigquery/docs/reference/standard-sql/lexical#reserved-keywords) 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](https://docs.microsoft.com/en-us/sql/t-sql/language-elements/reserved-keywords-transact-sql?view=sql-server-2017) 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](https://docs.microsoft.com/en-us/sql/t-sql/language-elements/reserved-keywords-transact-sql) 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](https://dev.mysql.com/doc/refman/8.0/en/keywords.html) 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](https://docs.aws.amazon.com/redshift/latest/dg/r_pg_keywords.html) 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](https://www.postgresql.org/docs/9.4/sql-keywords-appendix.html) 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](https://docs.snowflake.net/manuals/sql-reference/reserved-keywords.html) 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. |