---
title: "External BI prerequisites"
slug: "dataquery-bi-preparing-vpc"
updated: 2026-09-17T09:17:50Z
published: 2026-09-17T09:17:50Z
canonical: "guide.ncloud-docs.com/dataquery-bi-preparing-vpc"
---

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

# External BI prerequisites

Available in VPC

You can connect Data Query from an external business intelligence (BI) tool.

Data Query is compatible with most BI tools that support [Trino](https://trino.io/) connectivity. In addition to the BI tools listed below, many other BI tools can be connected and used in a similar way.

### Open Source BI tools

- [Superset](/docs/en/dataquery-bi-superset-vpc)
- [Zeppelin](/docs/en/dataquery-bi-zeppelin-vpc)

### Authenticate external BI tool connection

Username and password authentication is supported for connecting to Data Query from external BI tools.

              Note

              

- Username and password: Access Key and Secret Key of the user's sub account

              Caution

              

- Entering a username and password in external tools can be a security risk, so you cannot use the authentication key of the customer account (main account).
- Follow the instructions below to create an authentication key (Access Key) for your sub account.

### Create Sub Account and authentication key for Data Query BI

To create a Data Query BI-specific sub account and authentication key for username and password authentication in external BI tools:

              Note

              

For more information on creating Sub Account, see [Sub Account user guide{target="_blank"}](/docs/en/subaccount-overview).

#### 1. Create Sub Account

1. From NAVER Cloud Platform console, navigate to **Menu** > **All Services** > **Management & Governance** > **Sub Account**.
2. In the **Sub Account** menu, click **[Create Sub Account]**.
3. Enter the Sub Account information.
  - Login ID: Enter the ID to use for login.
  - Username: Enter the name of the user who will use the sub account.
  - Email: Enter the user's email address.
  - Access permissions
    - Console access: **Disabled**
      - Console access is now allowed for Data Query BI-dedicated accounts.
    - API Gateway access: **Allowed**
      - Set to Allowed to generate Access Keys for use in BI.
      - Select accessible sources (all or specified) based on the user's BI environment.
  - Two-factor authentication options: **Required**

- For all other options, use the default settings.

1. Enter the information above and click **[Create]**.

#### 2. Add Sub Account policy

1. In the **Sub Accounts** menu, click the logic ID created in the **1. Create Sub Account** section.
2. In the **Sub Account details** menu for the account, select the **Policy** tab at the bottom.
3. Click **[Add individual permission]** and select the policy name `NCP_VPC_DATA_QUERY_BI_TOOL_USER`, and click **[Add]** to grant Data Query-related service access permissions.

              Caution

              

- For security reasons, use the created Sub Account exclusively for the Data Query BI tool. Do not add any permissions other than those related to Data Query.

#### 3. Create Sub Account Access Key

1. In the **Sub Accounts** menu, click the logic ID created in the **1. Create Sub Account** section.
2. In the **Sub Account details** menu for the account, select the **Access Key** tab at the bottom.
3. Click **[Create]** to create an **Access Key and Secret Key**.