https://linen.dev logo
Join Slack
Powered by
Hi , I made a successful connection google sheet a...
# announcements
n
Hi , I made a successful connection google sheet as source and snowflake as destination. I am able to launch successfully. But problem is not reading and populating data in snowflake DB. Could anyone please help me why its not reading data the googlesheet data?
j
What does your source configuration look like for this?
Also, could you share the logs for the sync? (you can click on one of the runs and then there’s a button to download the logs)
n
@Jared Rhizor (Airbyte) Logs
logs-26-0.txt
@Jared Rhizor (Airbyte): Source configuration
j
What kind of machine is this running on? Mac? Linux?
n
@Jared Rhizor (Airbyte) - Linux
its hosted in EC2 - AMazon Linux2 server
j
Could you also share the connection configuration? You can get that by clicking on the source and then the destination and clicking on the 
Settings
n
@Jared Rhizor (Airbyte): Source & destination:
j
Sorry it’s a bit confusing
if you click on sources on the left, and then clikc on your specific source, and then click on the snowflake destination
you should be on a page that has the title “From {source} to {destination}”
That settings tab should show which streams you’re selecting
n
@Jared Rhizor (Airbyte): Below details you looking for?
j
yeah, that’s it
can you open the dropdown for 
Sheet1
and screenshot that?
n
@Jared Rhizor (Airbyte): it shows my old googlesheet file
j
ok so I think I can tell what the problem is
Did you change the headers in the spreadsheet after setting up the sync?
n
yes I completely changed the google sheet itself. not only headers.
j
We have a ticket we’re actively working on that should make it possible to update the schema used for syncing https://github.com/airbytehq/airbyte/issues/1401
That feature should be released in about a week
Unfortunately until then the only way to fix this is to delete and recreate the source
n
Got it. I will try deleting the source and retry it
Thanks Jared
j
Happy to help.
For your actual use case, do you expect to have headers changing frequently?
n
@Jared Rhizor (Airbyte): No, I was doing some poc, instead of big file, picked small one to test out. So in connection I changed the spreadsheet id.
After recreating the source connection, it worked fine
j
great!
n
@Jared Rhizor (Airbyte): regarding headers change frequently - yes, some columns will be added or removed
j
For the short term (in about a week) we’re adding support to make it possible to manually update the schema/headers you want to sync.
Later this year we’re planning on adding support for more automatic schema update handling.
👍 2
2 Views
Open in Slack
PreviousNext
Powered by