AWS QuickSight

​

Step 1: Create a New Data Source

1. From the left navigation pane, choose Datasets.
2. Select the Data sources tab.
3. Choose Create data source (top right).
4. Choose the PostgreSQL data source card. You should see the following data source creation modal.
5. For Data source name, enter a descriptive name for your Firebolt data source connection. Because you can create many datasets from a connection to Firebolt, it’s best to keep the name simple.
6. For Connection type, only Public is available so leave it as is.
7. Fill out the connection parameters using the values specified in the following table:

   Field	Value
   Host	pg.<region_name>.app.firebolt.io
   Port	5432
   Database name	<account_name>@<database_name>@<engine_name>
   Username	Service account ID (make sure it is the ID and not the name)
   Password	Service account secret

   ​

   Host details

   When using Firebolt’s PostgreSQL-compatible interface, the host URL is based only on the region. Host URL Format: pg.<region_name>.app.firebolt.io
   • <region_name> — The region your account is hosted in (e.g., us-east-1)
   • How to Find Your Region: Use this SQL query in Firebolt to get the region for your account:
   Copy

   Ask AI

   SELECT region FROM information_schema.accounts WHERE account_name = '<your_account>';
   

   ​

   Database field format

   Unlike traditional PostgreSQL databases, Firebolt uses a composite string in the Database field to specify:
   1. Account name
   2. Database name
   3. Engine name
   These are joined using @ separators in a single string:
   Copy

   Ask AI

   <account_name>@<database_name>@<engine_name>
   
8. To verify the connection is working, choose Validate connection.
9. To finish and create the data source, choose Create data source.

​

Step 2: Create a QuickSight Dataset

1. From the left navigation pane, choose Datasets.
2. Choose Create dataset (top right).
3. From the list of existing data sources, select the Firebolt data source you created.
4. Choose Select.
5. To specify the table you want to connect to, first select the Schema you want to use.
6. For Tables, choose the table that you want to use. If you prefer to use your own SQL statement, select Use custom SQL.
7. When prompted to choose a dataset creation mode, select Directly query your data. Firebolt is designed to provide high-performance query execution, so Direct Query is recommended in most cases. (Optional) You may choose Import to SPICE if you specifically require SPICE-based features or caching behavior.
8. Choose Edit/Preview.
9. (Optional) To add more data, use the following steps:
   • Choose Add data in the top right.
   • To connect to different data, choose Switch data source, and choose a different dataset.
   • Follow the prompts to finish adding data.
   • After adding new data to the same dataset, choose Configure this join (the two red dots). Set up a join for each additional table.
10. If you want to add calculated fields, choose Add calculated field.
11. Clear the check box for any fields that you want to omit.
12. Update any data types that you want to change.
13. When you are done, choose Save to save and close the dataset.

​

Allowlisting QuickSight IP Addresses

​

Request allowlisting from Firebolt Support

• Your name and email address
• Your organization name
• Tool: Amazon QuickSight
• QuickSight AWS region (for example: us-east-1)

​

Additional Resources