> ## Documentation Index
> Fetch the complete documentation index at: https://ngquct-docs-fix-500-query-results.mintlify.site/llms.txt
> Use this file to discover all available pages before exploring further.

# Teradata

> Browsing databases and objects on Teradata Vantage, with TLS and transaction mode

export const name_0 = "Teradata"

export const plugin_0 = "Teradata Driver"

Port `1025` carries a plain session. Any SSL mode moves the session to `443`, where it runs over the gateway's WebSocket endpoint, and that port cannot be changed. A native Swift driver handles both, with no client library to install.

<Frame caption="The Teradata connection form">
  <img className="block dark:hidden" src="https://mintcdn.com/ngquct-docs-fix-500-query-results/0TDhsORsgVLO0zL5/images/teradata-connection-form.png?fit=max&auto=format&n=0TDhsORsgVLO0zL5&q=85&s=b3b6ab002b72e87e987e9aa37277c090" alt="Teradata connection form" width="1560" height="960" data-path="images/teradata-connection-form.png" />

  <img className="hidden dark:block" src="https://mintcdn.com/ngquct-docs-fix-500-query-results/0TDhsORsgVLO0zL5/images/teradata-connection-form-dark.png?fit=max&auto=format&n=0TDhsORsgVLO0zL5&q=85&s=45529831151e3744e647d149d324238d" alt="Teradata connection form" width="1560" height="960" data-path="images/teradata-connection-form-dark.png" />
</Frame>

## Quick setup

Click **Create Connection…**, select **Teradata**, enter the host, username, and password, and click **Save & Connect**. Any Vantage system that accepts a TD2 logon works; no version is checked.

The {name_0} driver is not in the app. Picking {name_0} in the **Choose a Database** sheet offers the
download before the form opens, and opening a saved {name_0} connection installs it without asking.
**Settings > Plugins > Browse > {plugin_0}** installs it up front. See [Plugins](/features/plugins).

## Connection settings

| Field                   | Description                                                               |
| ----------------------- | ------------------------------------------------------------------------- |
| **Host**                | Teradata database hostname                                                |
| **Port**                | Plain gateway port, default `1025`                                        |
| **Database**            | Default database after logon. Optional; empty uses your account's default |
| **Username / Password** | Teradata credentials                                                      |
| **Logon Mechanism**     | Advanced pane. `TD2` or `TDNEGO`, uppercase. Default `TD2`                |
| **Transaction Mode**    | Advanced pane. `DEFAULT`, `ANSI`, or `TERA`, uppercase                    |
| **SSL Mode**            | **SSL/TLS** pane. **Disabled** by default                                 |

Leave **Transaction Mode** on `DEFAULT`, which takes whatever the system is configured for, unless a script needs `ANSI` or `TERA` case sensitivity and commit rules on the session. A system reachable only through a bastion works over an [SSH tunnel](/connections/ssh-tunneling).

## Connection URL

```text theme={null}
teradata://user:password@host:1025/database
```

**Import from URL…** accepts the scheme; macOS does not route `teradata://` links. See [Connection URL Reference](/connections/urls).

## Databases and objects

A database and a user are both namespaces in Teradata, and both appear as top-level databases in the sidebar with their tables and views inside. A tab bound to a second database keeps the same session: `DATABASE "name"` runs ahead of its statements instead of a reconnect.

Identifiers are quoted with double quotes. Teradata has no `LIMIT`, so a table's first page comes back with `TOP` and later pages with `QUALIFY ROW_NUMBER()`.

## SSL/TLS

| Mode                       | What happens                                                                                |
| -------------------------- | ------------------------------------------------------------------------------------------- |
| **Disabled**               | Plain session on the gateway port                                                           |
| **Preferred**              | TLS on `443`, falling back to a plain session on `1025` when the HTTPS port is unreachable  |
| **Required (skip verify)** | TLS, certificate not checked                                                                |
| **Verify CA**              | Certificate chain checked. Point **CA Certificate** at your CA file for a private authority |
| **Verify Identity**        | Chain and hostname checked                                                                  |

Test TLS on **Required (skip verify)** rather than **Preferred**, or a failed handshake looks like a successful connect.

## Limitations

* Foreign keys are never listed. The Structure tab's Foreign Keys view stays empty for Teradata; read the constraints from its DDL view instead.
* Macros and stored procedures are not in the sidebar. Query them from the editor.
* LDAP, Kerberos, and JWT logon fail before the connect is attempted. Use `TD2` or `TDNEGO`.
* The TLS port is fixed at `443`.

## Troubleshooting

### unsupported: logon mechanism …; only TD2 and TDNEGO are supported

**Logon Mechanism** holds something the driver does not implement. Set it to `TD2` or `TDNEGO`. A value the driver does not recognize, a mechanism typed in lowercase included, is read as `TD2` instead.

### Cannot reach the server

The connect gives up after 20 seconds. Confirm the host, and that port `1025` is open from your network, or `443` if an SSL mode is set.

### Logon fails

Check the username and password, and that the account is not locked.