# 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](https://docs.arcwise.app/arcwise-setup/connect-data-warehouse/arcwise-fixed-ip-address "mention") 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