Skip to main content
Docs
Feature Requests Onboarding Trust Center Status Page

Community

Connector Improvement: Connector Improvement: Google Sheet Lock in Data Type Schema

Completed
Marvin Moreno User

Hi FiveTran Team,

 

We will sometimes set up analytic and other teams with access for data entry via google sheets that are connected via fivetran and synced to a destination.

For metric columns, if a user changes the data type from integer to float in the gsheet, that will affect any downstream data processing on our side since the gsheet synced table also their data type column changed.

Is it possible to change the behavior so that changing the data type from integer to float on google sheets creates a new column instead along with a warning message in the dashboard?

 

Marvin

Please sign in to leave a comment.

Comments

2 comments

Date Votes
  • Official comment
    Parmeet Kohli Fivetranner

    Hi Marvin, thanks for submitting this request!  While we don't have this planned at this time, data type control is something we are considering for our file connectors. We will continue to collect customer demand and keep you posted.

    Best,
    Parmeet

  • Parmeet Kohli Fivetranner

    Hi Marvin, 

    The Google Drive connector now supports type locking. Find documentation here.

    Best,
    Parmeet