InfluxDB Connector for Google Data Studio

This is not an official Google product.

This Data Studio Connector lets users query datasets from InfluxDB v2 instances through the InfluxDB API.

How it works

Connect your InfluxDB to Google Data Studio and start pushing your data to in minutes.

How to add the InfluxDB Connector to Data Studio

Direct link

To add the InfluxDB Connector in Data Studio you can use this link:

.

From Data Studio

TBD: If you are already in Data Studio, click the "Create" button and select "Data Source". From there you can search for the InfluxDB Connector.

Connect your InfluxDB to Data Studio

To access your InfluxDB, enter your Connection information:

• InfluxDB URL
• Token
• Organization
• Bucket
• Measurement

• How to retrieve the Organization
• How to retrieve the Token

Set up Metrics

Once you are connected, Data Studio will show you a list of all the fields available from your Measurement. This includes your Tag set, Field set and Timestamp.

Visualize your data in Data Studio

After you have reviewed the fields, press "CREATE REPORT" button to create your report.

Inspiration

• COVID-19 report powered by InfluxDB

InfluxDB 1.8 compatibility

InfluxDB 1.8.0 introduced forward compatibility APIs for InfluxDB 2.0. This allow you to easily move from InfluxDB 1.x to InfluxDB 2.0 Cloud or open source.

Connector usage differences:

1. Use the form username:password for an authentication token. Example: my-user:my-password. Use an empty string ("") if the server doesn't require authentication.
2. The organization parameter is not used. Use a string - as a value.

Troubleshooting

This app isn't verified

When authorizing the connector, an OAuth consent screen may be presented to you with a warning "This app isn't verified". This is because the connector has requested authorization to make requests to an external API (E.g. to fetch data from the service you're connecting to).

This warning will no longer be display after the connector will include in Partner connectors gallery - see #2

Development

• Test version of the Connector: AKfycbySDF4eD7wmA_awZ6aoCwENuXs1Opw_T0DIJ8F
• Production version of the Connector: AKfycbwhJChhmMypQvNlihgRJMAhCb8gaM3ii9oUNWlW_Cp2PbJSfqeHfPyjNVp15iy9ltCs

Open Apps Script project in your browser:

$ yarn open

Push your local changes to Apps Script:

$ yarn push

Update the production deployment of connector:

$ yarn deploy

Contributing

Bug reports and pull requests are welcome on GitHub at https://github.com/influxdata/influxdb-gds-connector.

License

The gem is available as open source under the terms of the MIT License.