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.
You will need to have access to the following ThoughSpot components:
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.
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¶
Once you have logged on to the ThoughtSpot cloud service, navigate to the Data screen.
Then navigate to the Connections tab.
Click the Add connection button.
Name your connection and select the Google Bigquery tile. Click the Continue button.
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.
Click on the Consume view you want to query and select all the fields.
Then click Create Connection.
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.
Once ThoughtSpot has finished its clever work, you will be presented with your Consume views.
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.
Click the Data Samples Tab to see a sample of your data from AgileData
Lucky last step is to use ThoughSpot to ask questions of your data and get answers.