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
I created a table using the below definition for a Teradata identity column: ID INTEGER GENERATED BY DEFAULT AS IDENTITY (START WITH 1