Holistics Docs - End-to-End Business Intelligence Platform

The Holistics Documentation

Welcome to the Holistics Documentation. You'll find comprehensive guides and documentation to help you start working with Holistics as quickly as possible, as well as support if you get stuck. Let's jump right in!

Documentation    Get Started

Import Google Spreadsheets

Import Google Spreadsheet is a feature that allows admins and analysts to import data
from Google Spreadsheet to a specified database table. Admins/analysts can also specify
the frequency of import to allow the table to be kept in sync with the source Google
Spreadsheet. The destination table then can be used in reports/dashboards like a normal table.

How to do Google Spreadsheet import

Here is a quick 3-step process for querying google sheet data in Holistics. Google sheet reporting in Holistics requires you to import data to a reporting SQL database.

ETL for Google Sheet

Step 1: Set up a data source to allow data import

Set up your SQL database to allow write access for a given data source.
Please have a look at our docs on how to connect your database to Holistics.

Step 2: Create a new data import

Click on 'Data Import' link on the left side menu. Data import list shows up.

Data Import List

Click on 'Add new data import' button. The new data import page opens up.

From the left side form, specify title, source type (currently only Google Spreadsheet is supported), destination data source, destination schema name and table name. Schedule (optional) can also be specified.

Copy and paste Google Spreadsheet URL into the right text box.

New Data Import

Step 3: Validate input and destination table structure

Click on the 'Validate' button below the text box to run and validate the Google Spreadsheet URL. If this is the first time the feature is used, you may need to click on the browser's "Allow Popup" button to allow authentication with Google.

Once authentication with Google is finished, Holistics will proceed to download the file and validate it. If there is no error, a 'Preview' button also becomes available. Toggle it to show/hide preview data generated from the query.

The column definitions are also automatically generated from the result of the downloaded file. The data type of each column can be modified as you see fit.

Validate

For Redshift data sources, there are also advanced options to allow user to customize sort style and distribution style of the destination table. Click on 'Advanced Options' link below columns list to open up advanced options.

Advanced Options

Step 4: Schedule/Execute data import

Schedules for current data import can be modified under Schedules header on the left side panel. Optionally, data import can be executed manually by clicking on 'Execute' link for that import from the list.

Step 5: View data import status from job list

Once a import has executed, either manually or based on its schedules, a new job corresponds to one execution of that import will be created to track its progress. User can click on the refresh icon next to 'Job History' title from import list page to refresh the job list.

Job History

User can also click on 'Logs' link to view the detailed logs of each job execution.

Job Logs

Import Google Spreadsheets