Connect your dataSupported integrations
PostgreSQL
Connect PostgreSQL to Querio.
1. Create a dedicated user
What: Create a non-human PostgreSQL user for Querio.
CREATE USER querio_user WITH PASSWORD 'STRONG_PASSWORD';2. Grant read-only access
What: Give Querio access to the database and schemas it should query.
GRANT CONNECT ON DATABASE my_database TO querio_user;
GRANT USAGE ON SCHEMA public TO querio_user;
GRANT SELECT ON ALL TABLES IN SCHEMA public TO querio_user;
ALTER DEFAULT PRIVILEGES IN SCHEMA public
GRANT SELECT ON TABLES TO querio_user;Repeat the schema grants for each schema Querio should access.
3. Share connection details
Provide:
- Username
- Password
- Host
- Port, usually
5432 - Database
Connection string format:
postgresql://<username>:<password>@<host>:<port>/<database>