Name Sanitization

Hevo uses a Name Sanitization system to provide a consistent user experience across Destinations. This system encourages the use of a simple, consistent, and readable vocabulary when naming the tables and columns. To achieve this, Hevo replaces all non-alphanumeric characters and spaces in a table or column name with an underscore.

---

When are Names Sanitized?

Names are sanitized while mapping a Source Event Type to a table in the Destination using Auto Mapping or when you try to create a table manually using the Hevo UI. In the latter case, Hevo validates the table name you provide before creating a Destination table with it. If the validation fails, a message is displayed on the Hevo UI.

If you do not want Hevo to sanitize the table and column names, you can turn off this feature while configuring the Destination. In the case of Amazon Redshift, however, sanitization is enforced if Auto Mapping is active.

---

Name Sanitization in the Destination

When setting up a Destination, Hevo sanitizes the table and column names if you enable the Sanitize Table/Column Names option. How sanitization is done depends on the Auto Mapping setting.

Auto Mapping is enabled

As a part of sanitizing the names, Hevo:

• Converts the table and column names to lowercase.

• Replaces each non-alphanumeric (special) character with an underscore.

• Removes the trailing underscores.

For example, the Source Event Type, Table$namE_05_ is converted to table_name_05. Here, Hevo converted all alphabetical characters to lowercase, replaced the special character $ with an underscore, and removed the trailing underscore. The same conventions apply to column names.

Note: In the case of Amazon Redshift Destinations, even when Name Sanitization is not selected, Hevo converts the tables and columns to lowercase. This is because, by default, Amazon Redshift does not allow uppercase names for tables and columns. Read the Amazon Redshift Developer Guide for information on naming database objects.

Auto Mapping is turned off

When creating tables manually, how names are sanitized depends on the Destination type:

• Amazon Redshift: Hevo converts the table name to lowercase and does not sanitize it. For example, the table name Table$namE_05_ is converted to table$name_05_. The same conventions apply to column names.

  Note: In the case of Amazon Redshift Destinations, even when Name Sanitization is not selected, Hevo converts the tables and columns to lowercase. This is because, by default, Amazon Redshift does not allow uppercase names for tables and columns. Read the Amazon Redshift Developer Guide for information on naming database objects.

• Google BigQuery: According to the Google BigQuery reference guide for naming tables, you cannot create a table name with special characters. Hevo displays an error message if a table name with special characters, such as Table$n@mE_05_, is provided manually. However, you can name your tables with uppercase characters and trailing underscores. The same conventions apply to column names.

• Database Destinations: In the case of database Destinations, such as MySQL, PostgreSQL, SQL Server, and Amazon Aurora MySQL, Hevo converts the table name to lowercase. For example, the table name Table$namE_05_ is converted to table$name_05_. The same conventions apply to column names.

---

Revision History