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.
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
DataSet connector is already published on Google Data Studio.
Start in Google Data Studio. Click
In the Search field type
Scalyrand you should see
Scalyr PowerQueryas a partner connector. Select the connector and that will Launch the connector configuration.
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.
Parameters: You will be asked to fill in the parameters.
|US Region or EU Region as per your DataSet account.
|DataSet Read API Key
|Copy and paste this from your DataSet account. Please ensure the API key has sufficient permission to run the query.
|Enter the DataSet PowerQuery here. Escaping is not required. Sorting is optional. It's recommended to define only the
columns you need to retrieve.
On the next screen you will observe the list of
Fieldswhich are essentially
Columnsfrom PowerQuery. The
Typein 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.
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
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.