Using QuickSight to run SQL queries
Amazon QuickSight is a cloud-based business intelligence service, that you can use to run custom SQL queries on your ingested data. For more information about QuickSight and its capabilities, refer to the AWS documentation.
Creating a QuickSight data set
When creating a QuickSight new data set from the ingested data, select Presto as the source and use the following configuration settings:
| Setting | Description |
|---|---|
| Data source name | A descriptive name for this data source |
| Database server | The hostname of GeoSpock database; for example: sqlaccess.<platform_domain_name> So, for example, if your platform domain is geospock.example.com, set Database server to: sqlaccess.geospock.example.com |
| Port | 8446 |
| Catalog | geospock |
| Username | Your GeoSpock database username |
| Password | The password for your GeoSpock database account |
| Enable SSL | Enable this option |
For further guidance about how to create a QuickSight data set, refer to the AWS documentation.