Hi, quick question. We're using Google sheets conn...
# replication-troubleshooting
a
Hi, quick question. We're using Google sheets connector. And we want to cast columns in the Google sheet as integers. I think the answer is
NO
but I wanted to ask if is possible in some way to do casting of Sheet's columns with this connector? https://docs.airbyte.com/integrations/sources/google-sheets/#data-type-mapping
m
Today isn’t possible to select the data type mapped by Airbyte 😞
a
Hi thanks Marcos for answering! How hard it would be? Is there any open issue that you know about this?
u
Yes there is an open issue https://github.com/airbytehq/airbyte/issues/2390 more generic to all sources and destination. I don't think there is an easy fix for the issue today.
a
Thanks, yep it's too generic
We would need to investigate how to get cell type if possible from Google's APIs
u
Yes, probably something as the file connector with pandas with reader_options where you can define using parameters can be a good solution