Summary
User is experiencing issues with the Google Sheets connector in Airbyte, specifically related to the cell limit exceeding 10 million due to potential appending behavior instead of overwriting data as expected.
Question
Hello everyone !
I reach to you because I have some trouble shooting and interrogations about the process of alimentation from airbyte to googlesheet (using googlesheet conector). The issue is the same as listed https://github.com/airbytehq/airbyte/issues/41977|here
=> <https://github.com/airbytehq/airbyte/issues/41977|This action would increase the number of cells in the workbook above the limit of 10000000 cells>
source : snowflake | destination : googlesheets.
Indeed, following failures and diverse experimentations, I doubt about the mode of export declared as ‘overwrite’.
I have the feeling that airbyte appends from the above the data, and clears all the existing data below, but does not delete the rows used previously => which may lead to the 10 millions cells limit at a certain point.
does anyone has more clues about the procedure ?
Or does someone has worked its way around this issue in the end ?
Thank you very much for taking the time to read me ! :simple_smile:
This topic has been created from a Slack thread to give it more visibility.
It will be on Read-Only mode here. Click here if you want
to access the original thread.