Community Conundrum 27: Stacks of Questions is live! Read More

Importing dataset with Google Sheets API

Dataiker
Dataiker
Importing dataset with Google Sheets API

Hi Crew, 

I'm trying to upload a new googlesheets dataset to an existing project on DSS. I followed the steps in the guidelines you share here (https://www.dataiku.com/product/plugins/googlesheets/) but despite having completed them "Waiting for dataset to be configured" still appears where the dataset's preview is meant to show. And the "Test & Get Schema" button is disabled/shaded over.
Any idea what I might have missed/might be doing wrong please? 

Ultimately, the only thing I haven't done when setting up the API relevant to my googlesheet, is set up an OAuth consent screen. Could that be it?

Thanks for your help & looking forward to figuring it out! 

0 Kudos
2 Replies
Neuron
Neuron

@ValentineR 

In the past, I've gotten the google plugin to work.  The hardest thing I found in doing this was to get the entire google setup side of the connection setup.  

Are you getting any error messages in the logs when you try to make the connection?

There is also some more documentation here.  

https://github.com/dataiku/dataiku-contrib/tree/master/googlesheets

--Tom
0 Kudos
Dataiker
Dataiker

Hi,

Do you get an error when you click on the "test & get schema" button?

Jeremy, Product Manager at Dataiku
0 Kudos
Labels (2)