> ## Documentation Index
> Fetch the complete documentation index at: https://docs.jaantonio.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Connection

> Connect with your read-only Analytics role.

Analytics uses a read-only PostgreSQL connection. Lambda shows the connection details for the
bound `trunk` role in **Analytics > Roles**.

## Connection details

<Steps>
  <Step title="Open Roles">Open **Analytics > Roles** in your workspace.</Step>

  <Step title="Copy the connection details">
    Copy the host, port, database, username, and password for the bound `trunk` role.
  </Step>

  <Step title="Store the password safely">
    Put the password in your team's secret store. Do not place it in report files or source code.
  </Step>

  <Step title="Require TLS">
    Configure your SQL or Power BI connection to use TLS and verify the server certificate.
  </Step>

  <Step title="Use the reporting schema">
    Start with the views in `reporting`. Use deeper data layers only when the consultation needs
    them.
  </Step>
</Steps>

## Readiness

If the role or database is not ready, wait for **Analytics > Roles** to show a healthy state. Ask
your Lambda administrator for help if it stays unavailable.