My Fivetran Google Sheets Connector was syncing to table in database, can you change column name?

0

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?

Alejandro Penzini Answered question May 9, 2023
0

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.

Alejandro Penzini Changed status to publish July 4, 2023
You are viewing 1 out of 1 answers, click here to view all answers.

Maximize Your Data Potential With ITS

Feedback on Q&A