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

#  

# Exploring the Databases

## Overview

***

<img src="https://mintcdn.com/skypoint/B_C-fE3LxFENR53e/doc_snippets/databases.png?fit=max&auto=format&n=B_C-fE3LxFENR53e&q=85&s=178e631ad744c67a41b81187fd86de07" alt="Alt text" width="722" height="247" data-path="doc_snippets/databases.png" />

***

The **Databases Explorer** in Skypoint Studio provides an intuitive, unified interface to browse all data in your Lakehouse. It leverages Databricks **Unity Catalog** to organize data assets (catalogs, schemas, and tables) in a hierarchical structure. This upgrade offers a comprehensive view of all schemas and tables under Unity Catalog, greatly improving data visibility, organization, and accessibility within the Lakehouse for a seamless and efficient user experience. All changes made through Lakehouse SQL (such as adding or deleting records in a table) are synced to the Lakehouse in real-time, ensuring the explorer always reflects the latest data.

## To select and explore a Database

For every import, skyData adds a database to its analytical store known as Lakehouse.

1. In the left pane, go to the **Lakehouse** > **Explorer**.

<img src="https://mintcdn.com/skypoint/tLGqpc7J49ffHAJB/doc_snippets/explorerone.png?fit=max&auto=format&n=tLGqpc7J49ffHAJB&q=85&s=2f40a58c1c64de2231a2e8c9c04f14d3" alt="Alt text" width="1210" height="688" data-path="doc_snippets/explorerone.png" />

The **Catalog page** appears

2. Click on the **Drop-down** menu of the Catalog to see the Schemas under the Catalog.

<img src="https://mintcdn.com/skypoint/tLGqpc7J49ffHAJB/doc_snippets/explorertwo.png?fit=max&auto=format&n=tLGqpc7J49ffHAJB&q=85&s=81d7bf1cb88f53101ca91614409327f9" alt="Alt text" width="1207" height="682" data-path="doc_snippets/explorertwo.png" />

3. Then Click on the **Schemas** drop-down menu to see tables.

<img src="https://mintcdn.com/skypoint/tLGqpc7J49ffHAJB/doc_snippets/explorerthree.png?fit=max&auto=format&n=tLGqpc7J49ffHAJB&q=85&s=f7045ab814a1ae054b8b64fe097cbb33" alt="Alt text" width="1210" height="685" data-path="doc_snippets/explorerthree.png" />

4. Click on **Search** button to search the tables.
5. Then, Click on **Table name (Arrow)** button to sort the tables.

In the **Explorer** window under **Schema**, tables are organized into three layers: **Bronze**, **Silver**, and **Gold**. Each layer is represented by an icon-Bronze, Silver, or Gold, Indicating the data layer of a table:

<img src="https://mintcdn.com/skypoint/tLGqpc7J49ffHAJB/doc_snippets/explorerfour.png?fit=max&auto=format&n=tLGqpc7J49ffHAJB&q=85&s=a54d8e2ee8804ef084a803e9f79bd7e6" alt="Alt text" width="1206" height="685" data-path="doc_snippets/explorerfour.png" />

* **Bronze** – Tables of raw data ingested from various sources in the Dataflow with every light transformation.
* **Silver** – Refined and transformed view of the data for example after Map in the MDM / Stitch process.
* **Gold** – Consumption and business level aggregate tables such as Profiles (Customer, Employee, Organization etc.), Timelines, Audience, and Metrics.

| Item              | Description                                                          |
| :---------------- | :------------------------------------------------------------------- |
| Table Name        | The name of the tables.                                              |
| Total Records     | The number of rows of that individual database.                      |
| Edited by         | The user who updated the imported data to formulate a processed one. |
| Last Refresh date | The date and time when the database were last updated.               |
| Source            | Type of data source such as connectors that ingested the data.       |
| Data Completeness | Indicates the comprehensiveness of the data.                         |
| Data Standards    | The layers of data present in table.                                 |

2. Select a **Table** to know more about the attributes and the data.
3. The **Attributes** tab is opened by default and shows a table.

In the Attributes page, you will see a tabular representation of all the attributes present inside that entity with their details.

<img src="https://mintcdn.com/skypoint/tLGqpc7J49ffHAJB/doc_snippets/explorerfive.png?fit=max&auto=format&n=tLGqpc7J49ffHAJB&q=85&s=d4e9e9e7cc93f6557c2f7333f637c000" alt="Alt text" width="1207" height="684" data-path="doc_snippets/explorerfive.png" />

| Item              | Description                                                                                                          |
| :---------------- | :------------------------------------------------------------------------------------------------------------------- |
| Attribute Name    | Shows name of the attribute.                                                                                         |
| Data type         | Shows data type such as String or Integer.                                                                           |
| Semantic Label    | Describes the attribute.                                                                                             |
| Is Sensitive Data | Use this property to classify Semantic Labels as Sensitive.                                                          |
| Summary           | Indicates you with some important characteristics of the data, such as unique values, counts, nulls, missing values. |

4. Select the **Data** tab to see the details about individual records of the entity.
5. Click on **Columns** to customize the columns needed.

<p />

<img src="https://mintcdn.com/skypoint/tLGqpc7J49ffHAJB/doc_snippets/explorersix.png?fit=max&auto=format&n=tLGqpc7J49ffHAJB&q=85&s=87f8fc4822ad02a71c9fe205a614dbe0" alt="Alt text" width="1215" height="685" data-path="doc_snippets/explorersix.png" />

6. .Click on **Download CSV** to download data in CSV

<Note>
  In the data tab, you will see a tabular representation of the data with its values. The Column option side panel drop-down fields have a search functionality with a search placeholder. The search functionality has been made easier for the user by adding a search feature on the Column Options drop-down fields. Users can type for any attributes in the Column Settings field. This avoids the scrolling required for the long list of attributes.
</Note>

After a successful download, you can open the CSV file. You'll find detailed information about a list of attributes associated with the database.