# Connection

<figure><img src="https://1875572357-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FzP7hFWzU2Jj7xMbv2nyp%2Fuploads%2Fgit-blob-c7aeb22d2d197f8fa9aa1e351a508db7515701a9%2Fconnection.png?alt=media" 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](https://docs.codatum.com/data-exploration/notebook) , [Reports](https://docs.codatum.com/sharing/report) and Queries
    * A caching function works to prevent unncessary job execution. For more information, please check [(Appendix) Query Execution and Cache](https://docs.codatum.com/data-exploration/appendix-cache)
* Aggregate metadata:
  * Aggregate schema metadata using [Table Sync](https://docs.codatum.com/connect-and-manage-data/connection/sync-table-metadata) 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](https://docs.codatum.com/access-control/access-control-for-resources/access-control-for-connection).

## How to Set Up

* Create and configure the settings, including uploading authentication information. Please refer to the setup guide for each warehouse.
  * [supported-warehouses](https://docs.codatum.com/connect-and-manage-data/supported-warehouses "mention")
* Trigger synching to retrieve and save the metadata of tables.
  * [sync-table-metadata](https://docs.codatum.com/connect-and-manage-data/connection/sync-table-metadata "mention")