Reading a BigQuery View

rafael_rosado97
rafael_rosado97 Partner, Dataiku DSS Core Designer, Dataiku DSS ML Practitioner, Dataiku DSS Adv Designer, Registered Posts: 61 Partner

Hi, everyone.

I'm trying to read a BigQuery View on my Dataiku project, but the next error appears: Cannot list a table of type VIEW. Caused by: GoogleJsonResponseException: 400 Bad Request GET.

Do you know why It occurs?

Thanks!

Answers

  • Zach
    Zach Dataiker, Dataiku DSS Core Designer, Dataiku DSS Adv Designer, Registered Posts: 153 Dataiker

    Hi @rafael_rosado97
    ,

    Support for reading BigQuery views using the built-in driver was added in DSS 11.1.0. If you're running an older version, you'll need to upgrade. For more information, see the release notes.

    Alternatively, you can use the Google-provided driver instead of the built-in driver. For more information, see Google-provided driver. After you install the driver, you'll need to configure your BigQuery connection by going to Administration > Connections > your connection > Driver to use.

    Thanks,

    Zach

  • rafael_rosado97
    rafael_rosado97 Partner, Dataiku DSS Core Designer, Dataiku DSS ML Practitioner, Dataiku DSS Adv Designer, Registered Posts: 61 Partner

    Thank you, @ZachM
    !!

    It's useful for me.

Setup Info
    Tags
      Help me…