![]() ![]() When coplast is true, and COP Discovery is turned on, then a DNS lookup occurs for a coplast hostname. When coplast is false or omitted, or COP Discovery is turned off, then no DNS lookup occurs for the coplast hostname. Equivalent to the Teradata JDBC Driver COPLAST connection parameter. Specifies how COP Discovery determines the last COP hostname. Equivalent to the Teradata JDBC Driver COP connection parameter. Specifies whether COP Discovery is performed. description sequence name item provides the column name if available, but has no effect when StatementInfo parcel support is unavailable. description sequence name item provides the AS-clause name if available, or the column name if available, or the column title. Equivalent to the Teradata JDBC Driver COLUMN_NAME connection parameter. Equivalent to the Teradata JDBC Driver ACCOUNT connection parameter.Ĭontrols the behavior of cursor. For comparison, Teradata JDBC Driver connection parameters are documented here. Our goal is consistency for the connection parameters offered by the Teradata SQL Driver Dialect for SQLAlchemy and the Teradata JDBC Driver, with respect to connection parameter names and functionality. The following table lists the connection parameters currently offered by the Teradata SQL Driver Dialect for SQLAlchemy. Username and password specified as connection URL parameters take precedence over a host prefix, if both are specified. Username and password specified as a host prefix: eng = and password specified as connection URL parameters: eng = sqlalchemy.create_engine('teradatasql://whomooz/?user=guest&password=please') The username and password may be specified as a host prefix, or as connection URL parameters. The URL's host component may optionally be followed by a slash and question mark /? and the URL's query component consisting of connection parameters specified as key = value pairs separated by ampersand & characters. Note that COP Discovery is not implemented yet. Specify the Teradata Database hostname as the host component of the URL. import sqlalchemyĪfter importing the sqlalchemy package, your Python script calls the sqlalchemy.create_engine function to open a connection to the Teradata Database. Your Python script must import the sqlalchemy package in order to use the Teradata SQL Driver Dialect for SQLAlchemy. Using the Teradata SQL Driver Dialect for SQLAlchemy While the file can be viewed with any text file viewer or editor, your viewing experience will be best with an editor that understands Markdown format. The README.md file is a plain text file containing the documentation for the Teradata SQL Driver Dialect for SQLAlchemy. This permits you to view the documentation offline, when you are not connected to the Internet. When the Teradata SQL Driver Dialect for SQLAlchemy is installed, the README.md file is placed in the teradatasqlalchemy directory under your Python installation directory. When the Teradata SQL Driver Dialect for SQLAlchemy is installed, the LICENSE file is placed in the teradatasqlalchemy directory under your Python installation directory. Use of the Teradata SQL Driver Dialect for SQLAlchemy is governed by the License Agreement for the Teradata SQL Driver Dialect for SQLAlchemy. Py -3 -m pip install -no-cache-dir -U teradatasqlalchemy Pip install -no-cache-dir -U teradatasqlalchemy When upgrading to a new version of the Teradata SQL Driver Dialect for SQLAlchemy, you may need to use pip install's -no-cache-dir option to force the download of the new version. Use pip to install the Teradata SQL Driver Dialect for SQLAlchemy. Added support for below Teradata's datatypes:.Added ART Table support for get_columns API.Release Notes: teradatasqlalchemy 17.0.0.5 Using the Teradata SQL Driver Dialect for SQLAlchemy.32-bit Python is not supported.įor community support, please visit the Teradata Community forums.įor Teradata customer support, please visit Teradata Access.Ĭopyright 2023 Teradata. This package requires 64-bit Python 3.4 or later, and runs on Windows, macOS, and Linux. ![]() This package enables SQLAlchemy to connect to the Teradata Database. Teradata SQL Driver Dialect for SQLAlchemy ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |