google-bigquerylooker-studiodata-connections

Google BigQuery connector (Connect Data Studio to BigQuery tables) - I would like to modify this connector to customize for my special requirements

I need to modify the Google Data Studio - Google BigQuery Connector for the customized requirements.

https://support.google.com/datastudio/answer/6370296

First Question: How could I find the source code for this data connector?

Second question:

According to the guide, https://developers.google.com/datastudio/connector/reference, getData(), Returns the tabular data for the given request.

And the response is in this format

{
     "schema":[
        {
           "name":"OpportunityName",
           "dataType":"STRING"
        },
        {
           "name":"IsVerified",
           "dataType":"BOOLEAN"
        },
        {
           "name":"Created",
           "dataType":"STRING"
        },
        {
           "name":"Amount",
           "dataType":"NUMBER"
        }
     ],
     "rows":[
        {
           "values":[
              "Interesting",
              true,
              "2017-05-23",
              "120453.65"
           ]
        },
        {
           "values":[
              "SF",
              false,
              "2017-03-03",
              "362705286.92"
           ]
        },
        {
           "values":[
              "Spring Sale",
              true,
              "2017-04-21",
              "870.12"
           ]
        }
     ],
     "cachedData":true
  }

But BigQuery could have 100 millions records in the table. We don't care that it could be 100 millions records, we just give the response in this format anyway?

Thanks!

Solution

  • The existing DS-BQ connector is not open source, hence you won't be able to modify its behavior.

    With that said: