> ## 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/connecting-to-preset",
  "feedback": "Description of the issue"
}
```

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

</AgentInstructions>

> Learn about connecting Preset to Firebolt.

# Preset

[Preset](https://preset.io/) is a cloud-hosted data exploration and visualization platform built on top of the popular open-source project, [Apache Superset](https://superset.apache.org/). This fully managed service makes it easy to run Superset at scale with enterprise-ready security, reliability, and governance.

Boasting exceptional speed and scalability, Firebolt enables users to adeptly manage substantial data volumes with minimal query latency. The integration with Preset establishes a strong partnership for data professionals, presenting them with a streamlined and efficient workflow. This collaboration ensures prompt loading of Preset dashboards and visualizations, even when confronted with extensive datasets, thereby facilitating the extraction of maximum value from their data.

## Prerequisites

Preset is a managed service so most of the deployment requirements are handled by them.

You will only need:

* To [register](https://manage.app.preset.io/starter-registration/) a Preset account.
* To have a Firebolt account and service account [credentials](/guides/managing-your-organization/service-accounts).
* [Load data](/guides/loading-data) you want to visualise.

<Note>
  Make sure that your [service account's network policy](https://docs.firebolt.io/Guides/managing-your-organization/service-accounts.html#edit-your-service-account-using-the-ui) allows connections from [Preset IPs](https://docs.preset.io/docs/connecting-your-data).
</Note>

## Quickstart

### Create a workspace

A workspace is an organizational unit, accessible by team members, that is created for a specific purpose. You can read Preset's [guidance](https://docs.preset.io/docs/about-workspaces) on workspaces to learn more.

1. To Create a Workspace, navigate to the empty card and select + Workspace.

   <img src="https://mintcdn.com/firebolt/Hc-k8wiP5Rcc9bZ2/assets/images/preset-create-workspace-click.png?fit=max&auto=format&n=Hc-k8wiP5Rcc9bZ2&q=85&s=987c245ecf1cd255bcba3b3d157a1285" alt="Create Workspace" width="10%" data-path="assets/images/preset-create-workspace-click.png" />

2. Define Workspace name and settings

   <img src="https://mintcdn.com/firebolt/Hc-k8wiP5Rcc9bZ2/assets/images/preset-add-new-workspace.png?fit=max&auto=format&n=Hc-k8wiP5Rcc9bZ2&q=85&s=2e5a572b24ad4532e7181b67bc231373" alt="Add new Workspace" width="30%" data-path="assets/images/preset-add-new-workspace.png" />

3. Save the workspace and enter it by clicking the card.

### Setup Firebolt connection

After the initial setup in Preset User Interface head to the `Settings -> Database connections` in the top right corner.

<img src="https://mintcdn.com/firebolt/G3wWYYraB4YzRaOy/assets/images/preset-settings.png?fit=max&auto=format&n=G3wWYYraB4YzRaOy&q=85&s=f51328274305a65a52816bc93cdce473" alt="Database Connections" width="30%" data-path="assets/images/preset-settings.png" />

On the next screen, press the `+ Database` button and select Firebolt from the dropdown.

<img src="https://mintcdn.com/firebolt/wU8j7Hl1Gi7TGWM5/assets/images/superset-connect-a-database.png?fit=max&auto=format&n=wU8j7Hl1Gi7TGWM5&q=85&s=272903280d1c29327ababb557f7587a2" alt="Connect database" width="30%" data-path="assets/images/superset-connect-a-database.png" />

The connection expects a SQLAlchemy connection string of the form:

```
firebolt://{client_id}:{client_secret}@{database}/{engine_name}?account_name={account_name}
```

To authenticate, use a service account ID and secret.
A service account is identified by a `client_id` and a `client_secret`.
Learn how to generate an ID and secret [here](/guides/managing-your-organization/service-accounts).

Account name must be provided, you can learn about accounts in [Manage accounts](/guides/managing-your-organization/managing-accounts) section.

<img src="https://mintcdn.com/firebolt/wU8j7Hl1Gi7TGWM5/assets/images/superset-firebolt-uri.png?fit=max&auto=format&n=wU8j7Hl1Gi7TGWM5&q=85&s=f55f0c340474801536f24c80853eaa52" alt="Credentials" width="30%" data-path="assets/images/superset-firebolt-uri.png" />

Click the Test Connection button to confirm things work end to end. If the connection looks good, save the configuration by clicking the Connect button in the bottom right corner of the modal window.
Now you're ready to start using Preset!

### Build your first chart

To build a chart you can follow our guide in the [Superset section](/guides/integrations/connecting-to-apache-superset#build-your-first-chart), as the Preset works identically.

## Further reading

* [Creating a chart](https://docs.preset.io/docs/creating-a-chart) walkthrough.
* [Creating a Dashboard](https://docs.preset.io/docs/creating-a-dashboard).
* [Collaboration features of Preset](https://docs.preset.io/docs/sharing-and-collaboration).
* [Storytelling in charts](https://docs.preset.io/docs/storytelling-with-charts-and-dashboards-mini-guide).
