# Connection

<figure><img src="/files/ICQcW1uIVYF2pvilNLDV" alt=""><figcaption></figcaption></figure>

Connection is used to manage access for Data Warehouses.\
It includes authentication credentials uploaded by users to execute queries and retrieve table information.

## Key Features

* Run queries:
  * Issue queries with authentication in [Notebooks](/data-exploration/notebook.md) , [Reports](/sharing/report.md) and Queries
    * A caching function works to prevent unncessary job execution. For more information, please check [(Appendix) Query Execution and Cache](/data-exploration/appendix-cache.md)
* Aggregate metadata:
  * Aggregate schema metadata using [Table Sync](/connect-and-manage-data/connection/sync-table-metadata.md) to maintain up-to-date and comprehensive data records.
* Access control:
  * Manage access control to restrict which users and groups can execute queries and retrieve the results of the execution. See details in [Access Control for Connection](/access-control/access-control-for-resources/access-control-for-connection.md).

## How to Set Up

* Create and configure the settings, including uploading authentication information. Please refer to the setup guide for each warehouse.
  * [Supported Warehouses](/connect-and-manage-data/supported-warehouses.md)
* Trigger synching to retrieve and save the metadata of tables.
  * [Sync Table Metadata](/connect-and-manage-data/connection/sync-table-metadata.md)


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.codatum.com/connect-and-manage-data/connection.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.