Renaming columns/fields in a stream

Summary

Exploring the possibility of renaming columns/fields in a stream during data loading.


Question

Is there a way to rename a column/field in a stream? For example if I in my source a column is called col_a can I change it to be loaded as col_b?



This topic has been created from a Slack thread to give it more visibility.
It will be on Read-Only mode here. Click here if you want
to access the original thread.

Join the conversation on Slack

["rename-column", "field", "stream", "data-loading"]

If you’re using Builder/Low-Code, you’d do this with two Transformations—one to duplicate the field with new name, and another to delete the original one. Docs:
https://docs.airbyte.com/connector-development/connector-builder-ui/record-processing#transformations