Hello there, I am trying to connect a Gsheet as a ...
# ask-community-for-troubleshooting
h
Hello there, I am trying to connect a Gsheet as a source (with SnowFlake as a destination). The header is not on the first but row no.3 of the sheet and once ingested, the value (i.e. column names) are ingested like any other row. I saw that we could add reader_options when the source was a file, any chance we can do something similar for gsheet? (I couldn’t see any other thread with the same issue, which is surprising). If not, what would be the alternative? storing the sheet as a .csv or .xls and import it from a S3 or GCS? Many thanks !