Briskport docs

Appearance

Configuring Your Warehouse for Briskport Integration: Step-by-Step Guide ​

Ensuring your warehouse is configured correctly is crucial for a smooth data flow from Crisp to your storage solution via Briskport. This guide will walk you through the necessary steps to set up your warehouse, ensuring it's primed for data reception and organization.

Please note that, currently, Briskport exclusively supports the PostgreSQL database for integration and data storage

Prerequisites ​

Before you proceed, ensure you have:

  • Completed Step 1: Linking Briskport with Crisp.
  • Access to your data warehouse with administrative rights.

Step-by-Step Instructions ​

1. Preparing Your Database Schema ​

  1. Launch your terminal and connect to your PostgreSQL server using an account with administrative privileges:
bash
psql -h <database-url> -p <database-port> -U <privileged-database-user> -d <database-name>
psql -h <database-url> -p <database-port> -U <privileged-database-user> -d <database-name>
  1. Create a dedicated schema for Briskport:
sql
CREATE SCHEMA briskport;
CREATE SCHEMA briskport;

2. Setting Up Database User ​

  1. Create a dedicated user for Briskport and assign a password:
sql
CREATE USER briskport_user WITH PASSWORD '<strong-password-here>';
CREATE USER briskport_user WITH PASSWORD '<strong-password-here>';

Note: Always use a strong password and replace '<strong-password-here>' with your chosen password.

  1. Grant the user rights to use the briskport schema:
sql
GRANT USAGE ON SCHEMA briskport TO briskport_user;
GRANT USAGE ON SCHEMA briskport TO briskport_user;
  1. Provide the user with rights to create tables within the schema:
sql
GRANT CREATE ON SCHEMA briskport TO briskport_user;
GRANT CREATE ON SCHEMA briskport TO briskport_user;
  1. Grant full rights to modify, retrieve, insert, or delete data:
sql
GRANT ALL ON ALL TABLES IN SCHEMA briskport TO briskport_user;
GRANT ALL ON ALL TABLES IN SCHEMA briskport TO briskport_user;
  1. Ensure these rights extend to future tables:
sql
ALTER DEFAULT PRIVILEGES IN SCHEMA briskport GRANT ALL ON TABLES TO briskport_user;
ALTER DEFAULT PRIVILEGES IN SCHEMA briskport GRANT ALL ON TABLES TO briskport_user;
  1. For optimal performance, limit the user connections. Adjust the number based on your needs:
sql
ALTER USER briskport_user CONNECTION LIMIT 2;
ALTER USER briskport_user CONNECTION LIMIT 2;

3. Verifying Database Configuration ​

  1. After setting up your schema and user, ensure that you can connect to the database using the briskport_user credentials and interact with the briskport schema.
  2. Test the creation of a table or the insertion of data to confirm the user has appropriate rights.

With these steps finalized, your warehouse should be appropriately configured and ready to interact seamlessly with Briskport. In case of challenges or if questions arise, get in touch with our responsive support team.