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: Access Metabase through Skyone Studio or directly via the URL displayed on the publication screen, using the provided credentials.

• [ Step 02 ] Replica Configuration: Define the data update frequency, ensuring that the information in Metabase is always current according to your needs.

• [ Step 03 ] 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.

1. Then, select the Metabase option.

2. 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

To access Metabase directly, follow these steps:

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

1. Enter your access credentials.

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

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.

FAQ