Access to the ServiceTrade Data Warehouse with Amazon QuickSight is available only to ServiceTrade Enterprise customers.  For more information about ServiceTrade Enterprise, contact sales@servicetrade.com.


Amazon QuickSight is a low-cost, high-performance business intelligence and reporting tool.  By leveraging ServiceTrade's integration with QuickSight, managers, owners, and business analysts can gain insights into customer service data.

Connecting to Amazon QuickSight

Important - please read first:

  • Access to your Data Warehouse for use with Amazon QuickSight is available only to Enterprise customers. More information about ServiceTrade Enterprise is available here.
  • Amazon QuickSight is a cloud application and tool that is separate from your ServiceTrade account. You will need first to sign up for an Amazon QuickSight account and log into it before being able to move your ServiceTrade data into it.
  • Contact ServiceTrade support at support@servicetrade.com to receive your ServiceTrade Data Warehouse username/schema and password. This information is specifically for connecting ServiceTrade to QuickSight after you have logged in to the application and is not your account name or password to log into Amazon's QuickSight services.

Connecting to the data warehouse

Your ServiceTrade data is made available to QuickSight through an Amazon Redshift data warehouse.  To use QuickSight to create reports and visualizations from your ServiceTrade data, you will need to connect your QuickSight account to your data warehouse.  The initial connection process will connect QuickSight to your data warehouse and allow you to access any and all ServiceTrade data warehouses going forward.

  1. Log into QuickSight
  2. Click ‘Manage Data’
  3. Click ‘New Data Set’
  4. Click ‘Redshift (manual connect)’
  5. Enter the following:
  • Data source name:  ServiceTrade Data Warehouse
  • Database server:  redshift-1.servicetrade.com
  • Port:  5439
  • Database name:  main
  • Username (schema):  <your assigned data warehouse username>
  • Password:  <your assigned data warehouse password>
  1. Click ‘Validate Connection’ to confirm connection parameters
  2. Click ‘Create data source’
  3. Choose the schema that you were assigned
  4. Choose the data source table that you want to visualize, such as ‘jobs’.  (You can create additional data sources for other tables later)
  5. Click ‘Directly query your data’
  6. Click ‘Edit/Preview data’
  7. If desired, change the name of the data source, then click ‘Save’

Adding more data source tables

  1. Log into QuickSight
  2. Click ‘Manage Data’
  3. Click ‘New Data Set’
  4. In ‘Existing data sources’, click the data source you created when originally setting up QuickSight (such as 'ServiceTrade Data Warehouse')
  5. Click ‘Create data set’
  6. Choose the schema that you were assigned
  7. Choose the data source table that you want to visualize
  8. Click ‘Directly query your data’
  9. Click ‘Edit/Preview data’
  10. If desired, change the name of the data source, then click ‘Save’

Repeat this process for each additional data source table that you want to visualize.

Refreshing a data source table

ServiceTrade may periodically add new columns to your data warehouse tables.  To gain access to those new columns, you will need to refresh your data source table.

  1. Log into QuickSight
  2. Click ‘Manage Data’
  3. Cick the data set to be refreshed
  4. Click ‘Edit data set’
  5. See that the new columns are available in the list of fields on the left
  6. Click ‘Save’

Note:  It is NOT necessary to refresh your data source tables to get updated data (new jobs, invoices, etc) from ServiceTrade -- that data will be updated automatically on a set schedule.  Manually refreshing a data source table is only needed to gain access to new columns of data in your data warehouse.

Please review this article for more information about the specific fields included in each data warehouse dataset.

Did this answer your question?