> ## Documentation Index
> Fetch the complete documentation index at: https://docs.firebolt.io/llms.txt
> Use this file to discover all available pages before exploring further.

<AgentInstructions>

## Submitting Feedback

If you encounter incorrect, outdated, or confusing documentation on this page, submit feedback:

POST https://docs.firebolt.io/feedback

```json
{
  "path": "/guides/integrations/quicksight",
  "feedback": "Description of the issue"
}
```

Only submit feedback when you have something specific and actionable to report.

</AgentInstructions>

> Connecting AWS QuickSight and Firebolt via PostgreSQL interface.

# AWS QuickSight

<Callout type="info">
  🧪 **Preview (Beta)** <br />
  Suitable for production read workloads.<br />
  Most PostgreSQL driver features are supported; some PostgreSQL features may not yet be tested and could behave differently or not work in some tools.
</Callout>

<img src="https://mintcdn.com/firebolt/sGanvvbRC2VmtXo2/assets/images/quicksight.png?fit=max&auto=format&n=sGanvvbRC2VmtXo2&q=85&s=ec42d2e5ec21ef7daf67cf537cc08770" alt="AWS QuickSight" width="500" height="127" data-path="assets/images/quicksight.png" />

[AWS QuickSight](https://aws.amazon.com/quicksight/) is a fast, cloud-powered business intelligence service that makes it easy to deliver insights to everyone in your organization. You can use QuickSight to create and publish interactive dashboards, perform ad-hoc analysis, and get business insights from your data.

This guide shows you how to connect AWS QuickSight to Firebolt using the PostgreSQL-compatible interface.

<Callout type="info">
  ℹ️ **Network access requirement** <br />
  QuickSight does not support mutual TLS (mTLS). In most cases, connections work without additional setup. <br />
  If you encounter connectivity issues, your QuickSight IP address may need to be allowlisted by Firebolt. See [Allowlisting QuickSight IP Addresses](#allowlisting-quicksight-ip-addresses).
</Callout>

## Step 1: Create a New Data Source

<Callout type="warning">
  ⚠️ <strong>QuickSight limitations (important)</strong><br /><br />

  AWS QuickSight enforces a PostgreSQL-style limit on the <strong>username length</strong>.

  The full username value: <strong>`<account_name>:<engine_name>:<service_account_id>`</strong> must be <strong>63 characters or fewer</strong>.

  If this limit is exceeded, QuickSight fails with a generic
  <em>“Something went wrong”</em> error and the connection request does <strong>not</strong> reach Firebolt. <br />

  <strong>Service account ID requirement</strong><br />
  Firebolt service accounts with a <strong>57-character</strong> client ID cannot be used with QuickSight.

  To connect QuickSight to Firebolt, you must use a service account with a <strong>shorter client ID</strong> (26 characters).

  If the service account you are using has a 57-character client ID,
  <strong>[create a new service account](/reference-sql/commands/access-control/create-service-account)</strong> with a shorter ID and use it for the connection.

  <strong>Engine name length</strong><br />
  If the combined username exceeds 63 characters due to a long engine name,
  rename the engine to a shorter name for use with QuickSight.

  These constraints are specific to QuickSight and PostgreSQL compatibility,
  not Firebolt itself.
</Callout>

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.

   <img src="https://mintcdn.com/firebolt/sGanvvbRC2VmtXo2/assets/images/quicksight-postgres.png?fit=max&auto=format&n=sGanvvbRC2VmtXo2&q=85&s=bb7c532d711e5479453df589c1f8a4a4" alt="QuickSight Postgres" width="380" height="127" data-path="assets/images/quicksight-postgres.png" />

   You should see the following data source creation modal.

   <img src="https://mintcdn.com/firebolt/sGanvvbRC2VmtXo2/assets/images/quicksight-data-source.png?fit=max&auto=format&n=sGanvvbRC2VmtXo2&q=85&s=bb46eacd18dcfd491aa303e91c1db3ee" alt="QuickSight Data Source Modal" width="670" height="729" data-path="assets/images/quicksight-data-source.png" />

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** | `<database_name>`                                   |
   | **Username**      | `<account_name>:<engine_name>:<service_account_id>` |
   | **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:

   ```sql theme={"theme":{"light":"github-light","dark":"github-dark"}}
   SELECT region FROM information_schema.accounts WHERE account_name = '<your_account>';
   ```

   #### User field details

   Unlike traditional PostgreSQL databases, Firebolt uses a composite string in the User field to specify:

   * Account name
   * Engine name
   * Service account ID

   These are joined using `:` separators in a single string:

   ```
   <account name>:<engine name>:<service_account_id>
   ```

   For example, if your account name is `my_account`, your engine name is `analytics_engine`, and your service account id is `fbcid_xxx` you would enter `my_account:analytics_engine:fbcid_xxx`.

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

After you create a Firebolt data source, you can use it to create a dataset for analysis.
To create a dataset using a Firebolt data source, follow these steps:

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

Amazon QuickSight does not support mutual TLS (mTLS).
If you experience connectivity issues when connecting QuickSight to Firebolt, QuickSight network access for your AWS region may need to be allowlisted by Firebolt.

### Request allowlisting from Firebolt Support

Contact Firebolt Support and request allowlisting, including the following information:

See how to contact [Firebolt Support and severity guidelines](/support/severity-guidelines)

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

After allowlisting is completed, return to QuickSight and retry the connection.

## Calculated fields compatibility

QuickSight supports creating calculated fields using built-in functions.
Most calculated field functions work as expected with Firebolt.

However, in rare cases, a calculated field function may generate SQL that is not supported by Firebolt’s PostgreSQL-compatible interface.

If you encounter an error with a calculated field, use **Custom SQL** in QuickSight and implement the logic directly as SQL instead of relying on the calculated field function.

## Additional Resources

For more information about AWS QuickSight configuration and visualisation, refer to the AWS [documentaion](https://docs.aws.amazon.com/quicksuite/latest/userguide/working-with-visuals.html).