We are using the Google Sheets Connector in Fivetran. If I change a column name in the first row will it get changed in the database table destination?
Yes, you can change the column name for a table that is being synced by the Fivetran Google Sheets connector. Here's how to do it:
Log in to your Fivetran dashboard and navigate to the connector that is syncing the data from Google Sheets to your database.
Click on the destination tab and select the table that you want to modify.
On the table settings page, scroll down to the "Columns" section and find the column that you want to rename.
Click on the column name to edit it, and then type in the new name for the column.
Click "Save" to save the changes.
After making the changes, you will need to resync the data from Google Sheets to your database by clicking on the "Sync" button on the connector's dashboard.
Once the data has been resynced, you should see the updated column names in your database. It's important to note that if you have any scripts or queries that rely on the old column names, you will need to update them accordingly.
