teradata

Teradata: FIRST_VALUE and LAST_VALUE Funtions

Teradata: PIVOT and UNPIVOT Clause

Teradata Role Access on Databases

Calculate Teradata Database Size

Save Spark DataFrame to Teradata and Resolve Common Errors

Teradata SQL - First Day of a Month

Teradata: Grant Select Access on One or Several Columns Only

Teradata SQL: Rights on a Database

Teradata SQL: Rights Held by Database

Teradata - Add User to a Role

Check User Access on Teradata

Check Role Access on Tables/Views in Teradata

Teradata Cast BIGINT to String

Teradata tdwallet Examples

Teradata NULLIFZERO and ZEROIFNULL Function

Teradata No More Room in Database Error and Table Skewness

Find out Teradata AMP (vprocs) Count

Teradata Hash Functions

Spark Scala: Load Data from Teradata

Teradata - Update with Joins to Another Table

Calculate MD5 in Teradata

Create Procedure with Dynamic Return Result in Teradata

Convert TimeStamp to Date in Teradata

Teradata RANDOM Number

Create Multiset Temporary Table in Teradata

This article demonstrates how to create volatile table in a Teradata procedure, perform DML actions (INSERT, DELETE, UPDATE) against it and then return the result set dynamically from the temporary table in the procedure.

Load JSON File into Teradata via BTEQ

Load XML File into Teradata via BTEQ

Export CSV File via TPT

Export Text File via Teradata FastExport

Teradata FastLoad with Optional Quotes

Teradata FastLoad Skip Header Line

Teradata FastLoad - Load CSV File

Load CSV into Teradata via TPT

Teradata ISNULL Alternatives

Teradata RPAD - Right Padding

Teradata LPAD - Left Padding

Extract XML Data via SQL Functions in Teradata

Extract JSON Data via SQL Functions in Teradata

Select First Row in Each GROUP BY Group in Teradata

Teradata SQL - Round Numbers to Hundreds or Thousands

Teradata SQL - Get Rid of Spaces from String

Teradata SQL LIKE: Contains, Starts With, Ends With Functions

This page shows you how to use LIKE

Trim Leading or/and Trailing Zeros in Teradata

This page shows how to trim or remove leading or/and trailing zeros using Teradata SQL.

Python: Save Pandas DataFrame to Teradata

Truncate table in Teradata

Create, Insert, Delete, Update Operations on Teradata via JDBC in Python

Teradata SQL - Use OREPLACE to Replace or Remove Characters

Save DataFrame to SQL Databases via JDBC in PySpark

Teradata SUBSTRING / SUBSTR and REGEXP_SUBSTR Functions

Teradata SQL - COALESCE and NULLIF Functions

Teradata SQL - TRYCAST / TRY_CAST Function

Teradata SQL - LEAD and LAG OLAP Functions

Teradata SQL - DATEADD Function Alternative for ADD / Subtract Days or Months

Teradata SQL - WITH - Use a reference of a CTE to another CTE

Read and parse JSON in SQL / Teradata

JSON is commonly used in modern applications for data storage and transfers. Pretty much all programming languages provide APIs to parse JSON.

Select top N records in SQL / Teradata

In different databases, the syntax of selecting top N records are slightly different. They may also differ from ISO standards.

Calculate time difference in SQL / Teradata

This code snippet shows how to calculate time differences.

Convert varchar to date in SQL / Teradata

This code snippet shows how to convert string to date in Teradata.

Load Data from Teradata in Spark (PySpark)

Useful DBC (Data Base Computer) System Views in Teradata

Connect to Teradata database through Python

Setup Teradata in Microsoft Azure

This page provides the steps to create a Teradata database in Microsoft cloud computing platform Azure.

Teradata SQL Tricks for SQL Server/Oracle Developers

For many SQL Server or Oracle developers, you may encounter some inconveniences when writing SQL queries. For example, how to select from dummy table or local defined variables. This page summarize the equivalents in Teradata SQL.

Teradata Tutorial – DateTime Related Functions and Examples

This post summarize the common functions that are used when dealing with DateTime datatypes in Teradata.

LINQ SQL to Teradata

[C#] Connect to Teradata Database via .NET Data Provider

Create ETL Project with Teradata through SSIS

Connect to Teradata Virtual Machine Guest from Windows Host

Querying Teradata and SQL Server - Tutorial 2 Filtering and Sorting

Querying Teradata and SQL Server - Tutorial 1: The SELECT Statement

Querying Teradata and SQL Server - Tutorial 0: Preparation

Install Teradata Express 15.0.0.8 by Using VMware Player 6.0 in Windows