PostgreSQL
Connecting Fabi.ai to your PostgreSQL instance.
Creating a service account user
1. Access PostgreSQL
Open your PostgreSQL client or connect to the database server using the psql
command-line tool:
2. Create the service user
Use the CREATE USER
command to define the user and assign a 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:
To give access to specific schemas:
To allow the user to read from tables:
Optional: To automatically grant privileges on new tables:
PostgreSQL Documentation: Privileges
Connecting PostgreSQK to Fabi.ai
Once you’ve generated your service user credentials, follow the steps in Connecting to Your Data
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.