# How to Set Up Metabase in Skyone Studio?

O **Metabase** é uma ferramenta de código aberto para exploração, visualização e compartilhamento de dados de forma simples e intuitiva. Integrado ao **Skyone Studio**, ele permite que os usuários acessem, analisem e compartilhem informações de maneira prática, utilizando dados replicados do Data Warehouse como base para suas consultas e visualizações.

* **Usuários novos**: o acesso ao **Metabase** já vem habilitado automaticamente.
* **Usuários antigos**: é necessário solicitar habilitação ao suporte.

### **Benefits**

* Native integration with **Skyone Studio**, with no separate installation required.
* Intuitive and interactive data visualization.
* Ability to customize the data update frequency.
* Easy selection of data sources for queries.

### **Key Terms (Glossary)**

* **Metabase**: Open-source tool for data analysis and visualization.
* **Data Warehouse**: Centralized environment for data storage and querying.
* **Replicas**: Updated copies of data for querying in Metabase.

***

### **Configuration Steps**

Setting up and using **Metabase** in **Skyone Studio** is carried out in 3 main steps: accessing the tool, defining the replica update frequency, and selecting the databases that will be available for queries.

Each step is essential to ensure that Metabase functions correctly, with up-to-date data compatible with analysis needs.

### **Steps:**

* [**\[ Step 01 \] How to access Metabase**](#how-to-access-metabase): Access Metabase through **Skyone Studio** or directly via the URL displayed on the publication screen, using the provided credentials.
* [**\[ Step 02 \] Replica Configuration**](#replica-configuration): Define the data update frequency, ensuring that the information in Metabase is always current according to your needs.
* [**\[ Step 03 \] Database Selection**](#database-selection): Choose the Data Warehouse databases that Metabase will be able to view and use for queries and analysis.

***

### **How to access Metabase**

1. In the side menu, click on **Publish**.

<figure><img src="https://2493694111-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FQPcfIOA6Tl2Bmk6CdV2O%2Fuploads%2FObuXnHpSjF98ZagGi4Gx%2FWSR1FXYsQS.png?alt=media&#x26;token=c5142196-b8db-4c7b-8a70-28b40d33e3f5" alt=""><figcaption></figcaption></figure>

2. Then, select the **Metabase** option.
3. The **Metabase** publishing screen will be displayed, showing the following information:

* Access URL for **Metabase**
* Admin credentials
* Data replication frequency
* Selection of databases **Metabase** can query

<figure><img src="https://2493694111-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FQPcfIOA6Tl2Bmk6CdV2O%2Fuploads%2FuNnVVJ5xnGJTeDYQnXvw%2Fx5n7hB6dws.png?alt=media&#x26;token=92b04e5f-8f7c-446f-bfdd-3a295290225d" alt=""><figcaption></figcaption></figure>

#### To access Metabase directly, follow these steps:

1. Copy the URL displayed on the publishing screen and paste it into your browser.

<figure><img src="https://2493694111-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FQPcfIOA6Tl2Bmk6CdV2O%2Fuploads%2FA1bEpe4xlXG8ZGWUE82l%2FpXLDrwWriU.png?alt=media&#x26;token=3f39ae6d-ddee-43f0-8e44-460b9969c8b8" alt=""><figcaption></figcaption></figure>

2. Enter your access credentials.

<figure><img src="https://2493694111-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FQPcfIOA6Tl2Bmk6CdV2O%2Fuploads%2FCqkFtrMg9HrPTz7beq58%2Fchrome_Wms1rtsshj.png?alt=media&#x26;token=ba4997d5-6c64-46e4-aa44-819f0eb48462" alt=""><figcaption></figcaption></figure>

{% hint style="info" %}
The **Metabase** password is automatically generated and will be shown on the publishing screen.
{% endhint %}

### Replica Configuration

In the replication frequency section, you can define how often the data replicated to **Metabase** is updated. Available options are:

* 30 minutes
* 1 hour
* 2 hours
* 3 hours
* 6 hours
* 12 hours
* 24 hours

<figure><img src="https://2493694111-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FQPcfIOA6Tl2Bmk6CdV2O%2Fuploads%2FncYuqrgqduY3mw7bENOu%2Fchrome_NX1uCdQoqw.gif?alt=media&#x26;token=df450a68-d284-44b0-8e78-6db13c3bdd80" alt=""><figcaption></figcaption></figure>

There is also a "**Sync Now**" option, which forces an immediate data update.

### Database Selection

You must select which databases Metabase is allowed to query. These databases correspond to the data sources already available in Skyone Studio’s Data Warehouse.

***

### **Demonstration Video**

To make the process easier to understand, watch the video below for a practical demonstration of all the steps covered in this documentation. The video shows each screen, click, and configuration required to complete the MetaBase integration in Skyone Studio.

{% embed url="<https://files.gitbook.com/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FQPcfIOA6Tl2Bmk6CdV2O%2Fuploads%2FUFrmN0yXuaGEW3xXusy5%2Fmeta%20base%20-%20EN.mp4?alt=media&token=82848b23-0f4e-4175-995f-bfea4406a4ab>" %}

***

### FAQ&#x20;

<details>

<summary>Do I need to request access to Metabase?</summary>

Only for existing users. For new users, access is enabled automatically.

</details>

<details>

<summary>Where can I find my Metabase password?</summary>

On the Metabase publication screen within **Skyone Studio**.

</details>

<details>

<summary>Can I update the data manually?</summary>

Yes. Use the **“Sync Now”** option.

</details>

<details>

<summary>Can I choose which databases to view?</summary>

Yes, as long as they are available in the **Skyone Studio Data Warehouse**.

</details>