# Overview

Prism enables users to connect to a data warehouses and open-source processing systems. These connections are specified in the [profile.yml](https://docs.runprism.com/v0.2.6/fundamentals/config-files/profile-yml) file.

Connections can be established via the [`prism connect`](https://docs.runprism.com/v0.2.6/cli/connect) command using the CLI.

The following pages specify how users can connect to the resources and how users can access these resources within their tasks:

* [sql](https://docs.runprism.com/v0.2.6/adapters/sql)
  * [BigQuery](https://docs.runprism.com/v0.2.6/adapters/sql/bigquery)
  * [Postgres](https://docs.runprism.com/v0.2.6/adapters/sql/postgres)
  * [Redshift](https://docs.runprism.com/v0.2.6/adapters/sql/redshift)
  * [Snowflake](https://docs.runprism.com/v0.2.6/adapters/sql/snowflake)
  * [Trino](https://docs.runprism.com/v0.2.6/adapters/sql/trino)
* [PySpark](https://docs.runprism.com/v0.2.6/adapters/pyspark)
* [dbt](https://docs.runprism.com/v0.2.6/adapters/dbt)

Note that all of these integrations require basic familiarity with the [`hooks`](https://docs.runprism.com/v0.2.6/fundamentals/tasks/hooks) object.