🐘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.

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 Dirección IP Fija de Arcwise 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

PreviousBigQueryNextDatabricks