Overview

Prism enables users to connect to a data warehouses and open-source processing systems. These connections are specified in the profile.yml file.

Connections can be established via the prism 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

  • BigQuery

  • Postgres

  • Redshift

  • Snowflake

  • Trino

• PySpark

• dbt

Note that all of these integrations require basic familiarity with the hooks object.