Ocient DB

The recommended connector library for Ocient is sqlalchemy-ocient.

Install the Ocient Driver

pip install sqlalchemy-ocient

Connecting to Ocient

The format of the Ocient DSN is:

ocient://user:password@[host][:port][/database][?param1=value1&...]

The DSN for connecting to an exampledb database hosted at examplehost:4050 with TLS enabled is:

ocient://admin:abc123@examplehost:4050/exampledb?tls=on

NOTE: You must enter the user and password credentials. host defaults to localhost, port defaults to 4050, database defaults to system and tls defaults to unverified.

User Access Control

Make sure the user has privileges to access and use all required databases, schemas, tables, views, and warehouses, as the Ocient SQLAlchemy engine does not test for user or role rights by default.