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

#  

# Using skyData Workspaces

## Overview

The Workspace module in skyData Studio allows users to view, configure, and manage workspaces linked to their instances. It provides secure access, promotes efficient resource utilization, and supports centralized workspace management across environments.

With this module, users can:

* Map a workspace to an instance.

* Open the connected Databricks environment to manage workspaces.

* Set up and access SQL credentials for their workspaces.

## To map new Workspaces

Users can map a workspace to an instance that is already connected to an another instance within a tenant.

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

<img src="https://mintcdn.com/skypoint/yrHdYGHo4dyrWTOM/doc_snippets/Workspaceone.png?fit=max&auto=format&n=yrHdYGHo4dyrWTOM&q=85&s=711fc734d8a3c558c03e0ac374179882" alt="Alt text" width="1207" height="685" data-path="doc_snippets/Workspaceone.png" />

The Workspaces window appears.

2. Click **Setup New Workspaces** to map workspaces.

<img src="https://mintcdn.com/skypoint/yrHdYGHo4dyrWTOM/doc_snippets/Workspacetwo.png?fit=max&auto=format&n=yrHdYGHo4dyrWTOM&q=85&s=40881f08f7c2f800f7c7938501a2b8de" alt="Alt text" width="1215" height="688" data-path="doc_snippets/Workspacetwo.png" />

The setup workspace pop-up window appears.

<img src="https://mintcdn.com/skypoint/yrHdYGHo4dyrWTOM/doc_snippets/Workspacethree.png?fit=max&auto=format&n=yrHdYGHo4dyrWTOM&q=85&s=5a2c922320fa7cdb1800f88e13fd6e32" alt="Alt text" width="1209" height="688" data-path="doc_snippets/Workspacethree.png" />

3. Click on **form existing workspace**.

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

4. Select the workspace you want to map from the dropdown menu.

<img src="https://mintcdn.com/skypoint/yrHdYGHo4dyrWTOM/doc_snippets/Workspacenine.png?fit=max&auto=format&n=yrHdYGHo4dyrWTOM&q=85&s=2e078bc242180201af1265fbb90bf7bd" alt="Alt text" width="1213" height="690" data-path="doc_snippets/Workspacenine.png" />

5. Click on **Map** to map the custom workspace to an instance.

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

<Note>
  Only custom workspaces can be configured by users. Default workspaces are view-only and cannot be modified.
</Note>

## To Access Databricks workspace from skyData studio

To open the workspace in Databricks, directly from the skyData studio

1. Click on **arrow** icon present on workspace you want to access.

This will re-direct you to the corresponding databricks workspace

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

<Note>
  Default workspaces cannot be redirected to a Databricks workspace. Only custom workspaces support redirection to Databricks workspace.
</Note>

2. Click on the workspace you want to access.
3. Workspace details page appears.
4. Click the **Open in Databricks** button located at the bottom-left corner.

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

You will be redirected to the corresponding Databricks workspace

<img src="https://mintcdn.com/skypoint/yrHdYGHo4dyrWTOM/doc_snippets/Workspacelast.png?fit=max&auto=format&n=yrHdYGHo4dyrWTOM&q=85&s=0dc81966cf1aa24df2dbc9a6ae194921" alt="Alt text" width="1212" height="688" data-path="doc_snippets/Workspacelast.png" />

## To enable SQL Access

1. Access a **workspace** by clicking on its name.

The **Workspace Details** window appears

<img src="https://mintcdn.com/skypoint/yrHdYGHo4dyrWTOM/doc_snippets/Workspacefive.png?fit=max&auto=format&n=yrHdYGHo4dyrWTOM&q=85&s=1ef0f8638679728d68d218f8000e129c" alt="Alt text" width="1219" height="688" data-path="doc_snippets/Workspacefive.png" />

2. Click **SQL Access** to enable the SQL connection.

<img src="https://mintcdn.com/skypoint/yrHdYGHo4dyrWTOM/doc_snippets/Workspacesix.png?fit=max&auto=format&n=yrHdYGHo4dyrWTOM&q=85&s=851e434c5506fb1fa3ce16a1ef7eb677" alt="Alt text" width="1212" height="688" data-path="doc_snippets/Workspacesix.png" />

<Note>
  skyData supports **Refresh Hive Metastore** to reflect database schema changes made directly to the Lakehouse Delta Lake. With the click of the **Refresh Hive Metastore** button, the metadata gets refreshed to reflect the changes in Lakehouse Databases like listing new tables, new attributes, or removal of tables.
</Note>

5. If necessary, do the following:

| To                                                                   | Do                                                                |
| :------------------------------------------------------------------- | :---------------------------------------------------------------- |
| View and copy the credentials for SQL Access                         | Click **Show fields** and copy the credentials to your clipboard. |
| Initialize a cluster to quickly connect to Lakehouse and run queries | Click **Initialize Warehouse**.                                   |

6. You need to obtain the following Lakehouse workspace SQL credentials:

* Server hostname
* Port
* HTTP path
* JDBC URL
* Personal access token

| Item                  | Description                                                                                                                                          |
| :-------------------- | :--------------------------------------------------------------------------------------------------------------------------------------------------- |
| Server hostname       | Indicates the root URL for Lakehouse workspace SQL endpoint.                                                                                         |
| Port                  | Refers to the port in your cluster credentials.                                                                                                      |
| HTTP path             | Refers to the Lakehouse SQL endpoint provisioned for the instance.                                                                                   |
| JDBC URL              | Indicates the driver that is used to connect to a database. It is a standard protocol for each Instance, which is used to connect with data sources. |
| Personal access token | Contains your security credentials used to authenticate and connect to SQL endpoints.                                                                |

<Note>
  Refresh personal access token generates a personal access token for accessing the lakehouse tables. Clicking the **Refresh** icon, you can set the default expiry time to 90 days. An alert message starts displaying 7 days prior to access token expiration.
</Note>

<Tip>
  skyData is a multi-tenant Software as a Service (SaaS) platform where each customer is a tenant, and each tenant has one or more instances. You can create databases and tables in your Instance. Lakehouse SQL supports data integration at instance level.

  When you click the **Enable** button, by default, the system loads data into Databricks from **Lakehouse** > **Explorer** and creates credentials to authenticate and explore your data through Power BI, Tableau, etc. Lakehouse workspace SQL integrates with all JDBC compliant tools for BI and ELT/ETL use cases.
</Tip>

Once you’ve enabled Lakehouse workspaces, you can begin visualizing and working with tools like Power BI or Tableau.

Also, you can integrate your Lakehouse workspace endpoints and Databricks with more MDS tools such as Fivetran, Airbyte, Dbt, etc. The third-party data integration with Databricks helps you to centralize data from disparate data sources into Lakehouse.

* To get started with third-party tools for data integration, click the **More MDS tools** tile.

<Note>
  Lakehouse workspace SQL capability provides direct full SQL access to your instance-level Delta Lakehouse accessible to Instance Administrator and above roles. You can use any SQL ingestion, transformation, or visualization tools to interact bi-directionally with Lakehouse including Fivetran, Dbt, Power BI, Tableau, and Looker. Any external changes to the Lakehouse will be automatically synchronized using Delta Lake **Change Data Feed (CDF)** to update the skyData metadata store.
</Note>

## See also

[Tenants](tenant.md)
[Instances](instance.md)
[Explorer](entities.md)