DataSet connector for Google Data Studio

The DataSet connector for Google Data Studio makes it possible for you to "blend" multiple data sources with DataSet Powerqueries results and visualize them in a single plane of glass. This has the added benefit of using your own data together with DataSet without duplicating it across to DataSet.

The ability to query all your log data with PowerQueries and visualize as well as correlate with other data sources in an intuitive interface allows anyone to make the log information more useful and accessible to all.

Prerequisites

1. Access to Google Data Studio which is available for free.

2. A DataSet read log API Key: A DataSet API Key is required for Data Studio to send PowerQuery requests to DataSet and return results.

You can obtain one by going to your account in the DataSet product and selecting the “API Keys” from the menu in the top right corner. You can find documentation on API Keys here.

3. PowerQuery: DataSet PowerQuery that you need to use. You can use multiple queries. Please refer to the Powerqueries documentation

Getting started

DataSet connector is already published on Google Data Studio.

1. Start in Google Data Studio. Click Create and then Data Source

2. In the Search field type Scalyr and you should see Scalyr PowerQuery as a partner connector. Select the connector and that will Launch the connector configuration.

3. If this is your first time using the connector or if DataSet updates the connector permissions you may be asked to Authorize Data Studio to use DataSet connector. Since each configuration is linked to a specific PowerQuery you may want to give the Data Source a user friendly name so your teams can reuse your Data. The Authorization may show you permissions requested by DataSet connector. This permission is to connect to DataSet API endpoint only. You will still need the API Key later.

4. Parameters: You will be asked to fill in the parameters.

5. On the next screen you will observe the list of Fields which are essentially Columns from PowerQuery. The Type in the list of fields is a best-effort estimate based on sample data retrieved. You can adjust and customize the field's name, types and aggregations here.

6. Click Explore or Create Report

7. Once in the report interface, you can add visualization and select the DataSet data source you just created. Click "CONNECT" on top right.

Refer to one of our Demo reports

Limitations

1. Data Studio sends all queries with date ranges and not in finer time ranges like hours, minutes or seconds.
2. When you select a single day as the daterange, the DataSet connector will automatically add a time range from 0000 hrs to 23:59:59 to the daterange. This is mainly for compatibility with DataSet query date range input for the same start and end dates.
3. Data studio uses UTC time.

4. Data studio can only fetch a maximum of one million rows of data.