Configuring your warehouse

How to configure your PostgreSQL warehouse to receive Crisp.chat conversations from Briskport.

With Briskport, your conversations from Crisp are funneled into your data warehouse, making it essential to have a properly configured warehouse environment. This guide will walk you through the steps needed to prepare your warehouse for Briskport integration.

Note: Briskport exclusively supports the PostgreSQL database for integration and data storage.

Prerequisites

Before starting the warehouse configuration, ensure you have:

Step 1: Prepare the database schema

Connect to your PostgreSQL database using administrative credentials. Create a dedicated schema for Briskport:

CREATE SCHEMA briskport;

Step 2: Establish a dedicated user account

For security and management purposes, it's recommended to create a dedicated user account for Briskport:

CREATE USER briskport_user WITH PASSWORD 'your_strong_password_here';

Grant the necessary permissions to this user:

GRANT USAGE ON SCHEMA briskport TO briskport_user;

GRANT CREATE ON SCHEMA briskport TO briskport_user;

GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA briskport TO briskport_user;

ALTER DEFAULT PRIVILEGES IN SCHEMA briskport GRANT ALL ON TABLES TO briskport_user;

Set a connection limit for the user:

ALTER USER briskport_user CONNECTION LIMIT 2;

Step 3: Verify the setup

After completing the above steps, verify the setup:

  1. Connect to the database using the briskport_user credentials.
  2. Ensure the user can access the briskport schema.
  3. Confirm the user can create tables and insert data within the schema.

If you encounter any issues, please contact our support team for assistance.