Hey guys, my question is about column names generated for BigQuery tables (in my case, BigQuery wareshouse is the destination) by Airbyte - is there any way to co-erce the column names to be similar to those generated by FiveTran as described here - https://fivetran.com/docs/getting-started/core-concepts#namingconventions

Hi Rahul, unfortunately no, we don't expose a way to do yet. We are working on exposing custom transformations to users so this should be possible in a few weeks

Conversion of multiple underscores to a single underscore - so I tried uploading data from Google Sheets to my org’s BigQuery warehouse, and these were the following anomalies that I noted :-

Got cha. I'm guessing the blocker today is downstream processing relies on the Fivetran normalised names?

Sorry, didn’t get you 😅

haha I'm trying to understand how the naming not matching Fivetran affects your workflow 🙂

Oh okay, so basically sometimes we’re having to move between Fivetran and Airbyte due to some reasons for doing data sync-ups in our BigQuery warehouse. Change in column names messes up with some things that are done on the BigQuery table column names

Ah interesting. What's the reason for switching between Fivetran and Airbyte?

No I mean, we aren’t switching continuously, its just that we’d decided to move onto Airbyte and let’s say, due to some unforeseen circumstances, we had to switch to Fivetran temporarily, but yeah, we want to move to permanently move to Airbyte, but again, if we do have to switch for certain unforeseen circumstances again, its good that the column names in the sync-ups match up, otherwise the codebase would need to be modified again

Understood! Thanks for explaining

Added here -> https://github.com/airbytehq/airbyte/issues/3392

Thanks Rahul! Let us know if there is anything else we can help with. Excited to welcome you to Airbyte 🙃