can i remove suffixes with mappings? e.g. user_full to user

The knowledge sources do not explicitly mention removing suffixes from field names using Airbyte mappings. The available mapping types are: • Hashing – irreversibly hashes a field's value • Encryption – reversibly encrypts a field's value • Field renaming – renames a field (e.g.,

original_field_name

→

new_field_name

) • Field filtering – removes a field entirely from records • Row filtering – filters out rows based on a field value condition [Mappings docs] The closest option to what you're describing is field renaming. While it doesn't specifically "remove a suffix," you can use it to rename

user_full

to

user

— which achieves the same end result. [Mappings docs] There is no built-in mapping type that automatically strips a suffix pattern across multiple fields at once. You would need to add a rename mapping for each individual field you want to rename. 👍 0 button 👎 0 button ℹ️ Tip: Mention @kapa.ai in the thread for follow-ups or DM the app for 1-to-1 help.

i dont want to rename field, i want to rename a table

Based on the knowledge sources, Airbyte does not support renaming individual streams/tables directly. However, there are a couple of options available: 1. Stream Prefix – You can add a prefix to all stream names in a connection via the Stream prefix setting on the Schema tab. This prepends the same text to every stream name in the destination. However, this adds a prefix, not removes a suffix. [Configuring Schemas] 2. Google Sheets only – If your source is Google Sheets, that connector specifically supports Stream Name Overrides, which lets you map a source stream name (e.g.,

user_full

) to a custom name (e.g.,

user

). [Google Sheets Stream Overrides] 3. PyAirbyte – If you're using PyAirbyte, you can use

set_table_prefix()

to set a table prefix programmatically, but again this only adds a prefix. [PyAirbyte Reference] > Airbyte does not allow for the renaming of individual streams at this time. [Configuring Schemas] As a workaround, you could rename the table downstream in your destination after Airbyte has synced the data. 👍 0 button 👎 0 button ℹ️ Tip: Mention @kapa.ai in the thread for follow-ups or DM the app for 1-to-1 help.