Implementation
This handler is implemented usingpsycopg2
, a Python library that allows you to use Python code to run SQL commands on the YugabyteDB database.
The required arguments to establish a connection are as follows:
user
is the database user.password
is the database password.host
is the host name, IP address, or URL.port
is the port used to make TCP/IP connection.database
is the database name.schema
is the schema to which your table belongs.
If you installed MindsDB locally via pip, you need to install all handler dependencies manually. To do so, go to the handler’s folder (mindsdb/integrations/handlers/yugabyte_handler) and run this command:
pip install -r requirements.txt
.Usage
In order to make use of this handler and connect to the YugabyteDB database in MindsDB, the following syntax can be used:NOTE : If you are using YugabyteDB Cloud with MindsDB Cloud website you need to add below 3 static IPs of MindsDB Cloud to 
allow IP list
for accessing it publicly.