Supported Authentication Methods | Teradata Query Service - Authenticating to the Teradata System - Teradata Query Service

Teradata® Query Service Installation, Configuration, and Usage Guide for Customers - 4.01.03.01, 4.01.07.00

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Teradata Query Service
Release Number
4.01.03.01, 4.01.07.00
Published
September 2023
Language
English (United States)
Last Update
2024-02-16
dita:mapPath
qla1666844235399.ditamap
dita:ditavalPath
ft:empty
dita:id
enn1467244092237
Product Category
Analytical Ecosystem
The Query Service API uses HTTP Basic to authenticate requests. When you send a request, you must include the authorization type and value in the Authorization header.
If you are a VantageCloud Enterprise user, contact Teradata Support to set up Query Service.
The Authorization header is constructed as follows:
  1. The username and password are combined into a string ("username:password").
  2. The resulting string is encoded using the RFC2045-MIME variant of Base64, except not limited to 76 char/line.
  3. The authorization method and a space ("Basic ") is added to the encoded string.The resulting value is Basic [Base64 encoded "username:password"].
curl --insecure -X POST \
"$HOST:1443/systems/prod/queries" \
-H 'Accept: application/vnd.com.teradata.rest-v1.0+json, */*; q=0.01' \
-H 'Content-Type: application/json' \
-H 'Authorization: Basic ZGJjOmRiYw==' \
-d '{"query": "SELECT * FROM dbc.dbcinfo", "format": "csv", "include_columns": true}'