GCP Looker Studio Data Source Builder

MonitoringGCP

Build Looker Studio data source configurations with BigQuery connectors, custom queries, and calculated fields.

Looker Studio Configuration

Build Looker Studio data source configurations with BigQuery connectors, custom queries, calculated fields, and caching settings.

Required Fields

dataSource.namedataSource.typedataSource.connectorConfig.projectIdfields

{
  "dataSource": {
    "name": "Production Analytics - BigQuery",
    "type": "BIGQUERY",
    "connectorConfig": {
      "projectId": "my-project",
      "datasetId": "analytics_reporting",
      "tableId": "daily_metrics",
      "billingProjectId": "my-project",
      "useFlattenedResults": true
    },
    "customQuery": {
      "enabled": true,
      "sql": "SELECT date, channel, campaign, impressions, clicks, conversions, cost, revenue FROM `my-project.analytics_reporting.daily_metrics` WHERE date >= @DS_START_DATE AND date <= @DS_END_DATE"
    }
  },
  "fields": [
    {
      "name": "date",
      "type": "DATE",
      "aggregation": "NONE",
      "description": "Report date"
    },
    {
      "name": "channel",
      "type": "TEXT",
      "aggregation": "NONE",
      "description": "Marketing channel"
    },
    {
      "name": "impressions",
      "type": "NUMBER",
      "aggregation": "SUM",
      "description": "Total impressions"
    },
    {
      "name": "ctr",
      "type": "PERCENT",
      "aggregation": "NONE",
      "formula": "clicks / impressions",
      "description": "Click-through rate"
    },
    {
      "name": "roas",
      "type": "NUMBER",
      "aggregation": "NONE",
      "formula": "revenue / cost",
      "description": "Return on ad spend"
    }
  ],
  "parameters": [
    {
      "name": "DS_START_DATE",
      "type": "DATE",
      "defaultValue": "TODAYS_DATE_MINUS_30"
    },
    {
      "name": "DS_END_DATE",
      "type": "DATE",
      "defaultValue": "TODAYS_DATE"
    }
  ],
  "caching": {
    "enabled": true,
    "prefetchCacheEnabled": true,
    "maxAge": "12h"
  },
  "sharing": {
    "accessType": "VIEWER",
    "allowEditors": false
  }
}

Generated Output

Output will appear here...

How It Helps

Build Looker Studio data source configurations with BigQuery connectors, custom queries, and calculated fields. This tool helps GCP engineers generate valid configurations quickly without consulting documentation, reducing errors and accelerating infrastructure deployment. All processing runs in your browser with no data sent to external servers.

Things Engineers Ask

How does this Looker Studio Data Source builder keep up with new GCP features?

The Looker Studio Data Source options surface what is currently documented in the Google Cloud reference for that service. When Google adds a new property or value, we add it here after verifying the schema in a real project. If a recently-announced feature is not yet selectable, treat that as a 'not yet supported' signal rather than an opinion that it should not be used.

Can I use this Looker Studio Data Source builder for Google Cloud sovereign or assured workloads?

Most Looker Studio Data Source primitives behave the same in standard, Assured Workloads, and sovereign Google Cloud deployments, but available services, regions, and access controls differ. The output is portable in shape; you must verify service availability and any Assured Workloads constraints before applying in a controlled environment.

Practical Applications

1Producing a Looker Studio Data Source starting point for a new service that follows the Google Cloud reference architecture rather than copy-paste from another team's repo.
2Documenting an existing production Looker Studio Data Source configuration in version control after a console hotfix that bypassed IaC.
3Working out a Looker Studio Data Source configuration during incident response, when the on-call needs a corrected version applied within minutes.
4Onboarding a new engineer by giving them a Looker Studio Data Source sandbox to iterate on without touching live projects.

Related Learning Guides

Firestore Data Modeling26 min read
Cost Optimization Guide24 min read

Was this tool helpful?

Disclaimer: This tool runs entirely in your browser. No data is sent to our servers. Always verify outputs before using them in production. AWS, Azure, and GCP are trademarks of their respective owners.