View teradatasqlalchemy on Snyk Open Source Advisor

Unable to verify the project's public source code repository.

Package Health Score

61 / 100

security
Security review needed
popularity
Popular
maintenance
Sustainable
community
Limited

Explore Similar Packages

teradatasql
78

Popularity

Popular

GitHub Stars: ?
Forks: ?
Contributors: -

Direct Usage Popularity

Based on project statistics from the GitHub repository for the PyPI package teradatasqlalchemy, we found that it has been starred ? times.

Security

Security review needed

Security and license risk for latest version

Release Date: Oct 30, 2024
Direct Vulnerabilities: 0
C
0
H
0
M
0
L
Indirect Vulnerabilities: 0
C
0
H
0
M
0
L
License Risk: 0
H
0
M
0
L

All security vulnerabilities belong to production dependencies of direct and indirect packages.

License

Teradata License Agreement

Security Policy

We found a way for you to contribute to the project! Looks like teradatasqlalchemy is missing a security policy.

You can connect your project's repository to Snyk to stay up to date on security alerts and receive automatic fix pull requests.

Keep your project free of vulnerabilities with Snyk

Maintenance

Sustainable

Commit Frequency

Unavailable commit data

Open Issues: ?
Open PR: ?
Last Release: 7 days ago
Last Commit: unknown

Further analysis of the maintenance status of teradatasqlalchemy based on released PyPI versions cadence, the repository activity, and other data points determined that its maintenance is Sustainable.

We found that teradatasqlalchemy demonstrates a positive version release cadence with at least one new version released in the past 3 months.

In the past month we didn't find any pull request activity or change in issues status has been detected for the GitHub repository.

Community

Limited

Readme: Yes
Contributing.md: No
Code of Conduct: No
Contributors: 0
Funding: No

This project has seen only 10 or less contributors.

Embed Package Health Score Badge

Keep your project healthy

Check your requirements.txt

Ensure all the packages you're using are healthy and well-maintained

Snyk Vulnerability Scanner

Get health score & security insights directly in your IDE

Package

Python Versions Compatibility: >=3.4

Age: 6 years
Latest Release: 7 days ago
Dependencies: 0 Direct
Versions: 19
Maintainers: 1
Wheels: OS Independent

Readme

Teradata SQL Driver Dialect for SQLAlchemy

This package enables SQLAlchemy to connect to the Teradata Database.

This package requires 64-bit Python 3.4 or later, and runs on Windows, macOS, and Linux. 32-bit Python is not supported.

For community support, please visit the Teradata Community forums.

For Teradata customer support, please visit Teradata Access.

Release Notes:

teradatasqlalchemy 20.0.0.3

Implemented visit column() method to add table name or alias name while generating string representation of SQL expression.
Implemented visit_function() method to add table name or alias name while generating string representation of Function expression.

teradatasqlalchemy 20.0.0.2

Updated queryband utility to be used by multiple python packages in multilevel hierarchy of imports.
has_table() now checks for existence of views as well by default. When new keyword argument table_only is set to True, has_table() will exclusively check for existence of tables only.

teradatasqlalchemy 20.0.0.1

Minor bug fix for inline help.

teradatasqlalchemy 20.0.0.0

Added a utility to enable querybands for function calls in python packages. Any python client package can import queryband package and can configure its name and version to track the vantage usage with help of logs available with DBQlogTbl.

teradatasqlalchemy 17.20.0.0

Added support for SQLAlchemy >= 2.0
div operator is no more supported.

teradatasqlalchemy 17.0.0.5

Added xviews support for below APIs.:
- get_columns
- get_foreign_keys
- get_pk_constraint
- get_schema_names
- get_transaction_mode
- get_unique_constraints

teradatasqlalchemy 17.0.0.4

Added ART Table support for get_columns API.

teradatasqlalchemy 17.0.0.3

Resolved a minor bug.

teradatasqlalchemy 17.0.0.2

Added support for below Teradata's datatypes:
- JSON
- XML
- TDUDT
- GEOMETRY
- MBR
- MBB
Optimised below APIs
- has_table
- has_view
- get_table_names
- get_view_names
Minor bug fixes.

Installation

Use pip to install the Teradata SQL Driver Dialect for SQLAlchemy.

Platform	Command
macOS or Linux	`pip install teradatasqlalchemy`
Windows	`py -3 -m pip install 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.

Platform	Command
macOS or Linux	`pip install --no-cache-dir -U teradatasqlalchemy`
Windows	`py -3 -m pip install --no-cache-dir -U teradatasqlalchemy`

License

Use of the Teradata SQL Driver Dialect for SQLAlchemy is governed by the License Agreement for the Teradata SQL Driver Dialect for SQLAlchemy.

When the Teradata SQL Driver Dialect for SQLAlchemy is installed, the LICENSE file is placed in the teradatasqlalchemy directory under your Python installation directory.

Documentation

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. This permits you to view the documentation offline, when you are not connected to the Internet.

The README.md file is a plain text file containing the documentation for 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.

Using the Teradata SQL Driver Dialect for SQLAlchemy

Your Python script must import the sqlalchemy package in order to use the Teradata SQL Driver Dialect for SQLAlchemy.

import sqlalchemy

After importing the sqlalchemy package, your Python script calls the sqlalchemy.create_engine function to open a connection to the Teradata Database.

Specify the Teradata Database hostname as the host component of the URL. Note that COP Discovery is not implemented yet.

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.

The username and password may be specified as a host prefix, or as connection URL parameters.

Username and password specified as a host prefix:

eng = sqlalchemy.create_engine('teradatasql://guest:please@whomooz')

Username and password specified as connection URL parameters:

eng = sqlalchemy.create_engine('teradatasql://whomooz/?user=guest&amp;password=please')

Username and password specified as connection URL parameters take precedence over a host prefix, if both are specified.

Connection Parameters

The following table lists the connection parameters currently offered by the Teradata SQL Driver Dialect for SQLAlchemy.

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. For comparison, Teradata JDBC Driver connection parameters are documented here.

Parameter	Default	Type	Description
`account`		string	Specifies the Teradata Database account. Equivalent to the Teradata JDBC Driver `ACCOUNT` connection parameter.
`column_name`	`false`	boolean	Controls the behavior of cursor `.description` sequence `name` items. Equivalent to the Teradata JDBC Driver `COLUMN_NAME` connection parameter. False specifies that a cursor `.description` sequence `name` item provides the AS-clause name if available, or the column name if available, or the column title. True specifies that a cursor `.description` sequence `name` item provides the column name if available, but has no effect when StatementInfo parcel support is unavailable.
`cop`	`true`	boolean	Specifies whether COP Discovery is performed. Equivalent to the Teradata JDBC Driver `COP` connection parameter.
`coplast`	`false`	boolean	Specifies how COP Discovery determines the last COP hostname. Equivalent to the Teradata JDBC Driver `COPLAST` connection parameter. When `coplast` is `false` or omitted, or COP Discovery is turned off, then no DNS lookup occurs for the coplast hostname. When `coplast` is `true`, and COP Discovery is turned on, then a DNS lookup occurs for a coplast hostname.
`database`		string	Specifies the initial database to use after logon, instead of the user's default database. Equivalent to the Teradata JDBC Driver `DATABASE` connection parameter.
`dbs_port`	`1025`	integer	Specifies Teradata Database port number. Equivalent to the Teradata JDBC Driver `DBS_PORT` connection parameter.
`encryptdata`	`false`	boolean	Controls encryption of data exchanged between the Teradata Database and the Teradata SQL Driver for Python. Equivalent to the Teradata JDBC Driver `ENCRYPTDATA` connection parameter.
`fake_result_sets`	`false`	boolean	Controls whether a fake result set containing statement metadata precedes each real result set.
`lob_support`	`true`	boolean	Controls LOB support. Equivalent to the Teradata JDBC Driver `LOB_SUPPORT` connection parameter.
`log`	`0`	integer	Controls debug logging. Somewhat equivalent to the Teradata JDBC Driver `LOG` connection parameter. This parameter's behavior is subject to change in the future. This parameter's value is currently defined as an integer in which the 1-bit governs function and method tracing, the 2-bit governs debug logging, the 4-bit governs transmit and receive message hex dumps, and the 8-bit governs timing. Compose the value by adding together 1, 2, 4, and/or 8.
`logdata`		string	Specifies extra data for the chosen logon authentication method. Equivalent to the Teradata JDBC Driver `LOGDATA` connection parameter.
`logmech`	`TD2`	string	Specifies the logon authentication method. Equivalent to the Teradata JDBC Driver `LOGMECH` connection parameter. Possible values are `TD2` (the default), `JWT`, `LDAP`, `KRB5` for Kerberos, or `TDNEGO`.
`max_message_body`	`2097000`	integer	Not fully implemented yet and intended for future usage. Equivalent to the Teradata JDBC Driver `MAX_MESSAGE_BODY` connection parameter.
`partition`	`DBC/SQL`	string	Specifies the Teradata Database Partition. Equivalent to the Teradata JDBC Driver `PARTITION` connection parameter.
`password`		string	Specifies the Teradata Database password. Equivalent to the Teradata JDBC Driver `PASSWORD` connection parameter.
`sip_support`	`true`	boolean	Controls whether StatementInfo parcel is used. Equivalent to the Teradata JDBC Driver `SIP_SUPPORT` connection parameter.
`teradata_values`	`true`	boolean	Controls whether `str` or a more specific Python data type is used for certain result set column value types.
`tmode`	`DEFAULT`	string	Specifies the transaction mode. Equivalent to the Teradata JDBC Driver `TMODE` connection parameter. Possible values are `DEFAULT` (the default), `ANSI`, or `TERA`.
`user`		string	Specifies the Teradata Database username. Equivalent to the Teradata JDBC Driver `USER` connection parameter.

FAQs

What is teradatasqlalchemy?

Teradata SQL Driver Dialect for SQLAlchemy. Visit Snyk Advisor to see a full health score report for teradatasqlalchemy, including popularity, security, maintenance & community analysis.

Is teradatasqlalchemy popular?

The python package teradatasqlalchemy receives a total of 270,190 weekly downloads. As such, teradatasqlalchemy popularity was classified as a popular. Visit the popularity section on Snyk Advisor to see the full health analysis.

Is teradatasqlalchemy safe to use?

While scanning the latest version of teradatasqlalchemy, we found that a security review is needed. A total of 0 vulnerabilities or license issues were detected. See the full security scan results.

Last updated on 5 November-2024, at 12:08 (UTC).

Build a secure application checklist

Select a recommended open source package

Minimize your risk by selecting secure & well maintained open source packages

DONE

Scan your app for vulnerabilities

Scan your application to find vulnerabilities in your: source code, open source dependencies, containers and configuration files

SCAN NOW

Fix identified vulnerabilities

Easily fix your code by leveraging automatically generated PRs

AUTO FIX

Monitor for new issues

New vulnerabilities are discovered every day. Get notified if your application is affected

MONITOR APP

Package Health Score

Explore Similar Packages

Direct Usage Popularity

Security and license risk for latest version

Commit Frequency

Embed Package Health Score Badge

Keep your project healthy

Check your requirements.txt

Snyk Vulnerability Scanner

Readme

Teradata SQL Driver Dialect for SQLAlchemy

Table of Contents

Release Notes:

teradatasqlalchemy 20.0.0.3

teradatasqlalchemy 20.0.0.2

teradatasqlalchemy 20.0.0.1

teradatasqlalchemy 20.0.0.0

teradatasqlalchemy 17.20.0.0

teradatasqlalchemy 17.0.0.5

teradatasqlalchemy 17.0.0.4

teradatasqlalchemy 17.0.0.3

teradatasqlalchemy 17.0.0.2

Installation

License

Documentation

Using the Teradata SQL Driver Dialect for SQLAlchemy

Connection Parameters

FAQs

What is teradatasqlalchemy?

Is teradatasqlalchemy popular?

Is teradatasqlalchemy safe to use?

Build a secure application checklist

Select a recommended open source package

Scan your app for vulnerabilities

Source Code

Open Source

Container

Config

Fix identified vulnerabilities

Monitor for new issues