CData Python Connector for Greenplum

Build 21.0.7930

Using the Connector

This section provides a walk-through for writing Greenplum data access code in Python script.

See Data Model for more information on the available data source entities and how to query them with SQL.

Connecting from Code

See Package Installation and Establishing a Connection for the prerequisite information you need to deploy the connector and configure the connection to Greenplum.

To connect with the greenplum.connector module and its related classes, see Connecting.

Executing SQL

The connection's cursor object is used to directly execute SQL queries. See Querying Data to execute SELECT statements and process the returned result sets. See Updating Data to modify the data in Greenplum with INSERT, UPDATE, and DELETE statements.

Executing Stored Procedures

You can call stored procedures by using the EXECUTE statement. See Calling Stored Procedures for more information.

Batch Processing

See Batch Processing to modify several rows of Greenplum data at once using parameterized INSERT, UPDATE, and DELETE statements.

Copyright (c) 2021 CData Software, Inc. - All rights reserved.
Build 21.0.7930