Importing dataset with Google Sheets API

Options
ValentineR
ValentineR Dataiker, Dataiku DSS Core Designer, Dataiku DSS ML Practitioner, Dataiku DSS Adv Designer Posts: 1 Dataiker

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!

Answers

  • tgb417
    tgb417 Dataiku DSS Core Designer, Dataiku DSS & SQL, Dataiku DSS ML Practitioner, Dataiku DSS Core Concepts, Neuron 2020, Neuron, Registered, Dataiku Frontrunner Awards 2021 Finalist, Neuron 2021, Neuron 2022, Frontrunner 2022 Finalist, Frontrunner 2022 Winner, Dataiku Frontrunner Awards 2021 Participant, Frontrunner 2022 Participant, Neuron 2023 Posts: 1,595 Neuron
    Options

    @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

  • jereze
    jereze Alpha Tester, Dataiker Alumni Posts: 190 ✭✭✭✭✭✭✭✭
    Options

    Hi,

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

Setup Info
    Tags
      Help me…