Connector Improvement: Connector Improvement: Google Sheet Lock in Data Type Schema
CompletedHi 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
-
Official comment
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 -
Hi Marvin,
The Google Drive connector now supports type locking. Find documentation here.Best,
Parmeet
Please sign in to leave a comment.
Comments
2 comments