Python

This page outlines the steps to use the Python Driver for Connect AI.

Note: Before you can configure and use Python with Connect AI, you must first connect a data source to your Connect AI account. See Sources for more information.

Install the Driver

Follow these steps to download and install the driver:

1. Download and extract the setup archive for your operating system.

   • Mac Download
   • Windows Download
   • Linux Download
2. Follow the steps below for your operating system.

Windows Installation

1. In the extracted archive, open the win folder.

2. Choose the folder for your Python version, and then the folder for your bitness. For example, if you have Python 3.9 and a 64-bit operating system, open the win > Python39 > 64 folder.

3. Open a command prompt and run pip install for the .whl setup file. For example, a 64-bit Python 3.9 install would be pip install cdata_connect_connector-21.0.8049-cp39-cp39-win_amd64.whl.

Mac and Unix Installation

1. In the extracted archive, open the mac or unix folder.

2. Open a Python terminal and run pip install for the appropriate .tar.gz setup file. For example, a Python 3.9 install would be pip install cdata-connect-connector-21.0.8049-python39.tar.gz.

Connect to Connect AI

Follow these steps for an example of how to connect to Connect AI from your Python code:

1. Import cdata.connect, create a connection object, and and pass the connection string as an argument, as in the example below:

   import cdata.connect as mod
   conn = mod.connect("AuthScheme=OAuth;")
   
2. If you are not already logged into Connect AI, the OAuth login page opens in your default web browser. Log in to continue.

3. You can execute SQL statements using this connection. For example, the commands below print all entries for Id in a MailChimp connection:

   cur = conn.execute("SELECT Id FROM MailChimp1.MailChimp.AuthorizedApps")
   rs = cur.fetchall()
   for row in rs:
       print(row)
   

Connect to a Workspace

You can connect the Python client to a specific workspace as follows:

import cdata.connect as mod
conn = mod.connect("AuthScheme=OAuth;Workspace=MyWorkspace")

Learn More

To learn more information about using Python for Connect AI, click here.