Creating a Connection
Requirements for a SQL Connection
To set up a PostgreSQL/MySQL connection, you will need:
Hostname or IP address of the server
Database name
Username and password (read-only access is recommended)
Port number
Connection through SDK
Hereβs how you can create a connection in PigeonsAI through the SDK:
Example Output
The output URI from the connection will be used to create a train dataset below.
Security Best Practices
Read-Only Access
It is strongly recommended to use a read-only user for database connections. This minimizes risks and ensures that the operations performed by PigeonsAI are limited to data reading, without any modifications to your data.
Data Access
When pulling data from your database, PigeonsAI only accesses the columns specified in the training dataset creation. No other data is read or transferred, maintaining strict data privacy and minimization principles.
IP Address Whitelisting
Data pulling your cloud/vpc
Last updated