# Postgres

## (Optional) Create `arcwise USER` in your database

If you plan to use an existing user ignore this step. The existing user must be granted `USAGE` and `SELECT` privileges on the schema(s) you plan to use with Arcwise.

To create a new user follow these steps in `psql`.

```sql
CREATE USER arcwise WITH PASSWORD '{ENTER_PASSWORD_HERE}';

-- Grant usage on the schema and select privileges on the tables
GRANT USAGE ON SCHEMA public TO arcwise;
GRANT SELECT ON ALL TABLES IN SCHEMA public TO arcwise;

-- OPTIONAL - Revoke select for table(s) that you would prefer to hide 
REVOKE SELECT ON TABLE {your_hidden_table} from arcwise;
```

## (Optional) Allow connection from Arcwise IP address

If you need to add a fixed IP address to your allowlist or network policy, please refer to our  [Arcwise Fixed IP Address](/arcwise-setup/connect-data-warehouse/arcwise-fixed-ip-address.md) page.

### Link Account to Arcwise

Navigate to <https://admin.arcwise.app/> and go to the connections tab.

Input the required fields to link with the user created in Step 1


---

# 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.arcwise.app/arcwise-setup/connect-data-warehouse/postgres.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.