.. _thoughspot_magicbook-consume:

=====================
ThoughtSpot
=====================

Connecting ThoughtSpot to AgileData Consume
==============================================

This MagicBook outlines how to connect ThoughtSpot to the Consume area of your AgileData tenancy.  By following this MagicBook you will be able to use ThoughtSpot to query and visualise the Consume data which is available to you in AgileData.

The data stored within AgileAdata.io is physically stored in a database called Google BigQuery.  ThoughtSpot can natively connect to the Google BigQuery database with a few simple steps.  This MagicBook describes these steps.

Pre Requisites
==============================================

You will need to have access to the following ThoughSpot components:

* ThoughtSpot Cloud

    This MagicBook assumes you have signed up for the ThoughtSpot service and have a valid login for this service.

* AgileData connection details

    Contact your AgileData team and ask for your Project Id and Service Account information to be used to connect ThoughSpot to your data.


Connection Steps
==============================================

The first stage is to connect ThoughtSpot to the AgileData Consume view.

There is an optional stage to configure the ThoughSpot semantic layer (Worksheets).


Connect ThoughtSpot to AgileData Consume View
----------------------------------------------------

Step 1

    Once you have logged on to the ThoughtSpot cloud service, navigate to the Data screen.

.. image:: https://storage.googleapis.com/docs-agiledata-io/product-guild/consume/lastmile-viz/thoughtspot/1.png
    :width: 800

Step 2

    Then navigate to the Connections tab.

.. image:: https://storage.googleapis.com/docs-agiledata-io/product-guild/consume/lastmile-viz/thoughtspot/2.png
    :width: 800


Step 3
    
    Click the Add connection button.

.. image:: https://storage.googleapis.com/docs-agiledata-io/product-guild/consume/lastmile-viz/thoughtspot/3.png
    :width: 800

Step 4

    Name your connection and select the Google Bigquery tile.  Click the Continue button.

.. image:: https://storage.googleapis.com/docs-agiledata-io/product-guild/consume/lastmile-viz/thoughtspot/4.png
    :width: 800

Step 5

    Enter the Project Id and the Service Account information you have received from AgileData.  

        If you do not have this information get in touch with your magical AgileData team and ask for your Project Id and Service Account information to be used to connect ThoughSpot to your data.

    Click the Continue button.

    If your connection details were correct you will see a screen with your Consume views displayed.

.. image:: https://storage.googleapis.com/docs-agiledata-io/product-guild/consume/lastmile-viz/thoughtspot/5.png
    :width: 800

Step 6 

    Click on the Consume view you want to query and select all the fields.

.. image:: https://storage.googleapis.com/docs-agiledata-io/product-guild/consume/lastmile-viz/thoughtspot/6.png
    :width: 800

Step 7

    Then click Create Connection.

.. image:: https://storage.googleapis.com/docs-agiledata-io/product-guild/consume/lastmile-viz/thoughtspot/7.png
    :width: 800

Step 8
    
    Click confirm in the pop up modal.

    ThoughtSpot will now connect to your AgileData.  Under the covers ThoughtSpot is doing some clever things to index and classify your data, so it may take a few seconds to perform this step depending on the volume and complexity of your data.

.. image:: https://storage.googleapis.com/docs-agiledata-io/product-guild/consume/lastmile-viz/thoughtspot/8.png
    :width: 800

Step 10 

    Once ThoughtSpot has finished its clever work, you will be presented with your Consume views. 

.. image:: https://storage.googleapis.com/docs-agiledata-io/product-guild/consume/lastmile-viz/thoughtspot/9.png
    :width: 800

Step 11

    Click on the Consume view to see the fields ThoughtSpot has found and the different options ThoughtSpot has defaulted for each field.  You can update these options following good ThoughtSpot practices. 

.. image:: https://storage.googleapis.com/docs-agiledata-io/product-guild/consume/lastmile-viz/thoughtspot/10.png
    :width: 800

Step 12

 Click the Data Samples Tab to see a sample of your data from AgileData

.. image:: https://storage.googleapis.com/docs-agiledata-io/product-guild/consume/lastmile-viz/thoughtspot/11.png
    :width: 800

Step 13

    Lucky last step is to use ThoughSpot to ask questions of your data and get answers.

.. image:: https://storage.googleapis.com/docs-agiledata-io/product-guild/consume/lastmile-viz/thoughtspot/12.png
    :width: 800


Frequently Asked Questions
============================