Snowflake Solutions Expertise and
Community Trusted By

Enter Your Email Address Here To Join Our Snowflake Solutions Community For Free

Snowflake Solutions Community

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

Sign in with google.com

To continue, google.com will share your name, email address, and profile picture with this site.

Harness the Power of Data with ITS Solutions

Innovative Solutions for Comprehensive Data Management

Feedback on Q&A