Category "teradata"

How to enable TLS on Teradata Express

I have installed Teradata Vantage Express on an Azure VM according to these instructions: https://quickstarts.teradata.com/run-vantage-express-on-microsoft-azur

Target row updated by multiple source rows

UPDATE tb FROM Table1 tb, ( SELECT oreplace(data, '.', '') AS data FROM Table2 ) tb2 SET column = 'Y' WHERE tb.column1

Superset database connection with Teradata error

I am trying to connect TD with superset running in kube. This is code from my Dockerfile: USER root RUN pip install sqlalchemy-teradata RUN pip install

Teradata : Extract Date from string

There is a notation field with different number of characters. Eg Exceed Limit Fee 26-January-2020 or Account Exceed Limit Fee 05-June-2001 I want to extract

Column showing revenue increasing cumulatively, then only repeats the max value after a certain date

I'm creating a dashboard that, among other things, shows how much revenue a rep generated in their first month of joining the company. This is going to be base

A character string to numeric conversion failed while using syntax like 'OPE' =?

I try to run this query using Spring JDBC Template public static String FIND_CNC_OPE_GRAPPE_BY_FCT_ID = "SELECT " +"EXPO.COD_NA

How to create table in teradata that can be accessible by every user

I have a use case where I need to create a table with 1000 columns and encrypt each column by a different user. No granting access to every user is one way of

Teradata merge multiple records into single record

I want to merge multiple record into single record Ex: Input pdt status start_dt end_dt a Inactive 2022/02/02 2022/02/04 a Inctive 2022/02/05 2022/02/10 a Acti

Export data in parquet file in teradata

I cannot figure out a solution for exporting data from the Teradata database in a parquet format. I am using tdload and tbuild method which required tpt script

Teradata identity column and "Duplicate unique prime key error in dbname.tablename"

I created a table using the below definition for a Teradata identity column: ID INTEGER GENERATED BY DEFAULT AS IDENTITY (START WITH 1