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

# Starburst Galaxy

> Connect Starburst Galaxy to Ryft to sync query history, tables, and views.

### Prerequisites

Before beginning the setup, make sure you have the following privileges (usually, you should reach out to an administrator with access to the `accountadmin` role):

* `Manage service account`
* `Create role`
* `Manage security`
* `Create cluster`

***

## Step 1: Creating the Role

**1.** Navigate to **Admin** > **Access** > **Roles and privileges** in the Starburst Galaxy sidebar

**2.** Click **Add role** to create a new role

**3.** Configure the role:

* **Role name**: `ryft_access`
* Click **Add role**

<img className="block" src="https://mintcdn.com/ryft/L5DPwfzBtA5mdzde/images/starburst_step_1.png?fit=max&auto=format&n=L5DPwfzBtA5mdzde&q=85&s=9b576170500b5fd2ddc94fde0d57d46e" alt="Starburst Integration Step" width="2876" height="1792" data-path="images/starburst_step_1.png" />

***

## Step 2: Granting Role Access

In this step, you will configure Ryft’s role to access Starburst metadata and logs, namely:

* Tables and views schema information
* Query logs

**1.** Click on the **ryft\_access** role, then navigate to the **Policies** tab

**2.** Click **Add policy** to create a new policy

<img className="block" src="https://mintcdn.com/ryft/L5DPwfzBtA5mdzde/images/starburst_step_2_add_policy.png?fit=max&auto=format&n=L5DPwfzBtA5mdzde&q=85&s=d533c3db6c35901d1b4a054529ce2d00" alt="Starburst Integration Step" width="3004" height="1802" data-path="images/starburst_step_2_add_policy.png" />

**3.** Under "Define policy details", set the policy name and description:

* **Policy name**: `ryft_access_policy`
* **Description**: Access for Ryft's Starburst integration
* Click **Next**

<img className="block" src="https://mintcdn.com/ryft/L5DPwfzBtA5mdzde/images/starburst_step_2_add_policy2.png?fit=max&auto=format&n=L5DPwfzBtA5mdzde&q=85&s=e5f5d950d7146cc30a1d5a003aa3c114" alt="Starburst Integration Step" width="2826" height="1766" data-path="images/starburst_step_2_add_policy2.png" />

**4.** Under "Define policy scopes", select the data scope for the following metadata tables:

* **Catalogs**: Select `galaxy_telemetry`
* **Schemas**: Select the following schemas:
  * `galaxy_telemetry.information_schema`
  * `galaxy_telemetry.public`
* **Tables**: Select the following tables:
  * `galaxy_telemetry.information_schema.schemata`
  * `galaxy_telemetry.information_schema.tables`
  * `galaxy_telemetry.information_schema.columns`
  * `galaxy_telemetry.information_schema.views`
  * `galaxy_telemetry.public.query_history`
* Choose **Match everything in scope**
* Click **Next**

<img className="block" src="https://mintcdn.com/ryft/L5DPwfzBtA5mdzde/images/starburst_step_2_add_policy3.png?fit=max&auto=format&n=L5DPwfzBtA5mdzde&q=85&s=d4a270d5ebc10129f662869c99352c85" alt="Starburst Integration Step" width="2858" height="1778" data-path="images/starburst_step_2_add_policy3.png" />

**5.** Configure access permissions:

* **Grant**: ALLOW
* **Privileges**: Select (for read access)
* Click **Create policy**

<img className="block" src="https://mintcdn.com/ryft/L5DPwfzBtA5mdzde/images/starburst_step_2_add_policy4.png?fit=max&auto=format&n=L5DPwfzBtA5mdzde&q=85&s=c6282acd65b3ce8629641314fa5f8ecd" alt="Starburst Integration Step" width="2858" height="1786" data-path="images/starburst_step_2_add_policy4.png" />

***

**6.** Navigate to the **Privileges** tab and choose **Add privilege**

**7.** Choose the **Account** tab and click on **View all query history**

<img className="block" src="https://mintcdn.com/ryft/L5DPwfzBtA5mdzde/images/starburst_step_2_add_policy6.png?fit=max&auto=format&n=L5DPwfzBtA5mdzde&q=85&s=0eb37fe10def97a2bffa4e65adf9fd5c" alt="Starburst Integration Step" width="2776" height="1726" data-path="images/starburst_step_2_add_policy6.png" />

**8.** Press **Save privileges**

## Step 3: Creating the Service Account

**1.** Navigate to **Admin** > **Access** > **Service accounts**

**2.** Click **Create new service account**

**3.** Configure the service account:

* **User name**: `ryft-access-sa`
* **Default role**: `ryft_access`
* Check **Generate password**
* Click **Create**

<img className="block" src="https://mintcdn.com/ryft/L5DPwfzBtA5mdzde/images/starburst_step3_1.png?fit=max&auto=format&n=L5DPwfzBtA5mdzde&q=85&s=01c93333a3feeccaa6739f52073d7c85" alt="Starburst Integration Step" width="2864" height="1794" data-path="images/starburst_step3_1.png" />

**4.** Set a password description (e.g., `ryft-sa-password`) and click **Generate password**

<Note>
  **Important**: Save the generated password immediately. You will not be able to view it again after this step. It needs to be shared with your Ryft representative after initial setup is complete.
</Note>

**5.** Note the **username** of the new service account, to share it with Ryft later

<img className="block" src="https://mintcdn.com/ryft/L5DPwfzBtA5mdzde/images/starburst_step3_2.png?fit=max&auto=format&n=L5DPwfzBtA5mdzde&q=85&s=541a69f062138f37afd109895902e6c3" alt="Starburst Integration Step" width="3692" height="1024" data-path="images/starburst_step3_2.png" />

***

## Step 4: Creating the Cluster

**1.** Navigate to **Admin** > **Clusters** in the sidebar and click **Create cluster**

**2.** Under "Create new cluster", set up the following configuration:

* **Name**: `ryft-access-cluster`
* **Catalogs**: Select `galaxy_telemetry (us-east-1)`
* **Cloud provider region**: AWS US East (N. Virginia)
* **Access**: Select the `ryft_access` role
* **Execution mode**: Standard
* **Auto suspend**: 5 Minutes
* **Autoscale cluster workers**: Enable with range 1-4 workers
* Click **Create cluster**

<Note>
  `us-east-1` is the region of the `galaxy_telemetry` catalog, regardless of where your lake is stored.
</Note>

<img className="block" src="https://mintcdn.com/ryft/L5DPwfzBtA5mdzde/images/starburst_cluster.png?fit=max&auto=format&n=L5DPwfzBtA5mdzde&q=85&s=0d5cca91d0b0f2ac51134208745364be" alt="Starburst Integration Step" width="2846" height="1786" data-path="images/starburst_cluster.png" />

<img className="block" src="https://mintcdn.com/ryft/L5DPwfzBtA5mdzde/images/starburst_cluster_1.png?fit=max&auto=format&n=L5DPwfzBtA5mdzde&q=85&s=4f288a76da8930542a85258367fca766" alt="Starburst Integration Step" width="2858" height="1788" data-path="images/starburst_cluster_1.png" />

***

## Step 5: Getting Connection Information

Once your cluster is configured, you will need to share its connection details with Ryft.

**1.** Click on the new cluster’s name and then "Partner Connect"

<img className="block" src="https://mintcdn.com/ryft/L5DPwfzBtA5mdzde/images/starburst_cluster_2.png?fit=max&auto=format&n=L5DPwfzBtA5mdzde&q=85&s=395312d95ca0278d86d0649a02e4b7fe" alt="Starburst Integration Step" width="3924" height="1602" data-path="images/starburst_cluster_2.png" />

**2.** Click on “Connection info” and then copy the connection information from the `Port` and `Host` blocks.

<img className="block" src="https://mintcdn.com/ryft/L5DPwfzBtA5mdzde/images/starburst_cluster_3.png?fit=max&auto=format&n=L5DPwfzBtA5mdzde&q=85&s=b889d9616a6cbcb8500f815a0df8953f" alt="Starburst Integration Step" width="2858" height="1790" data-path="images/starburst_cluster_3.png" />

***

## Step 6: Extract the Catalog name that is used to access external Iceberg tables

Click on "Catalogs" tab (Under "Data" section), and locate the catalog that is connected to your Iceberg external catalog.
Provide the catalog name (from the "name" column) to Ryft.

<img className="block" src="https://mintcdn.com/ryft/L5DPwfzBtA5mdzde/images/starburst_step_6_catalogs.png?fit=max&auto=format&n=L5DPwfzBtA5mdzde&q=85&s=b7337ea42548d1666f363a7427092e7c" alt="Starburst Integration Step" width="2966" height="1092" data-path="images/starburst_step_6_catalogs.png" />

<Check>
  **Setup Complete!**
  In order to finalize the integration with Starburst Galaxy, share the following information with Ryft:

  * Ryft’s service account **username** and **password** from step **3**
  * Ryft’s cluster **host** and **port** from step **5**
  * Starburst **catalog name** for the catalog that is used to access external Iceberg tables from step **6**
</Check>