Skip to main content

Teradata

Provides access to Teradata database using SQL queries via JDBC driver.

Connection parameters

{
"server": "",
"port": "",
"db": "",
"connString": ""
}

Supported Parameters

TypeValueDescription or Example
num, int, double==100
>>1.02
>=>=4.1
<=<=100
!=!=5
inin (1, 3, 10.2)
min-max1.5-10.0
stringcontainscontains ea
starts withstarts with R
ends withends with w
inin (ab, "c d", "e\"f\"")
regexregex ^(.+)@(.+)$
datetimeanytime
beforebefore 1/1/2022
afterafter 1/1/2022
today
this week
this month
this year
last year
min-max
April 2021
list<string> (1)
  • (1) default parameters are not supported

Supported output types

TypeSupported
BYTEINT, SMALLINT, INTEGER
BIGINT
FLOAT, REAL, DECIMAL
CHAR, VARCHAR, CLOB
DATE, TIME, TIMESTAMP, TIME
WITH TIMEZONE,
TIMESTAMP WITH TIMEZONE
JSON (1)
XML (1)
SPATIAL (1)
ARRAY (1)
BYTE, VARBYTE, BLOBlimited support (2)
  • (1) supported as a string
  • (2) you get unreadable representation, but in query you can cast such a types to varchar, hex

Supported features

  • Schema browsing
  • Join DB tables
  • Aggregation query
  • Connection test

See also: