​
Creating a service account user

​
1. Access PostgreSQL

Open your PostgreSQL client or connect to the database server using the psql command-line tool: 
psql -U postgres

​
2. Create the service user

Use the CREATE USER command to define the user and assign a secure password: 
CREATE USER service_user WITH PASSWORD 'secure_password';
  • Replace service_user with your desired username.
  • Replace secure_password with a strong password.

​
3. Grant necessary privileges

Fabi.ai needs read access to the schemas that you wish to query. To grant the ability to connect to a database: 
GRANT CONNECT ON DATABASE your_database TO service_user;
To give access to specific schemas: 
GRANT USAGE ON SCHEMA your_schema TO service_user;
To allow the user to read from tables: 
GRANT SELECT ON ALL TABLES IN SCHEMA your_schema TO service_user;
Optional: To automatically grant privileges on new tables: 
ALTER DEFAULT PRIVILEGES IN SCHEMA your_schema GRANT SELECT ON TABLES TO service_user;
PostgreSQL Documentation: Privileges

​
Connecting PostgreSQK to Fabi.ai

Once you’ve generated your service user credentials, follow the steps in Connecting to Your Data
For information about our industry-leading security practices, check out our Security hub.

​
Hydra

For organizations that use PostgreSQL, we’ve partnered with Hydra to provide real-time analytics on transactional databases. Hydra is a high-performance database system that leverages DuckDB to combine transactional and analytical capabilities in one platform. It streamlines real-time analytics on live transactions and events by eliminating the need for data movement and transformation (ETL) between the transactional rowstore and the analytical columnstore. Combining Hydra and Fabi.ai creates a powerful analytical experience leveraging AI directly on transactional databases withour compromising latency or uptime.