Code: import teradatasql ExecutionContext = teradatasql.connect (host="xxxx", user="xxxx", password="xxx") def select(exec_context: ExecutionContext): try
I am trying to run the below sql by liquibase and I am getting an error expected something between "TABLE" and the keyword "IF" keyword .This is for teradata da
pretty new to teradata and trying to figure out how to repeat a simple insert statement. I have the following statement Insert into Test (Id) values ((sel max (
SELECT DISTINCT DEL.BABY_ID, DEL.MOTHER_ID, MIN(DEL.CHECK_VISIT_DATE) OVER (PARTITION BY DEL.MOTHER_ID) AS Del_FIRST_DATE, (DEL.CHECK_VISIT_DATE)
I'm looking for an easier way to do this. My current code is written as below: CASE WHEN LENGTH(CAST (MTH AS VARCHAR(4))) = 1 THEN CAST(CAST (YR AS VARCH
I have a Teradata table which contains LOB objects in different columns. When I do a query, it pops up window to ask where to save the LOB objects as txt files
I am having a hard time trying to find something that would be equivalent to YEARFRAC (Excel) for Teradata. I messed around with the below, but want I want it t
I have table that is in the following format: Number Departing Arriving Departure Time Removal Indicator 1 Miami Dallas 1 PM N 1 Chicago Dallas 3 PM Y 1 Dallas
Using Teradata.. I want to write a query that joins table 1 and table 2 on item code to the location in table 2. There are multiple locations per item code and
I wish to extract a few Calender Weeks from an yearly data. Once that's done, I want to pivot it, so that there is one row for each ID. We have a table DB.MY_CW
I was trying to split int column in Teradata but its showing error *** Failure 9134 Unsupported type detected. SELECT col1,strtok(col2,0 ,1) FROM table;
I have installed Teradata Vantage Express on an Azure VM according to these instructions: https://quickstarts.teradata.com/run-vantage-express-on-microsoft-azur
UPDATE tb FROM Table1 tb, ( SELECT oreplace(data, '.', '') AS data FROM Table2 ) tb2 SET column = 'Y' WHERE tb.column1
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
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
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
I try to run this query using Spring JDBC Template public static String FIND_CNC_OPE_GRAPPE_BY_FCT_ID = "SELECT " +"EXPO.COD_NA
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
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
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