teradata

72 items tagged with "teradata"

72 Articles

Articles

Teradata: FIRST_VALUE and LAST_VALUE Funtions

2021-08-13
Teradata

Teradata: PIVOT and UNPIVOT Clause

2021-08-13
Teradata

Teradata Role Access on Databases

2021-06-22
Code Snippets & Tips

Calculate Teradata Database Size

2021-04-01
Teradata

Save Spark DataFrame to Teradata and Resolve Common Errors

2021-03-08
Teradata

Teradata SQL - First Day of a Month

2021-02-04
Code Snippets & Tips

Teradata: Grant Select Access on One or Several Columns Only

2021-01-19
Code Snippets & Tips

Teradata SQL: Rights on a Database

2021-01-19
Code Snippets & Tips

Teradata SQL: Rights Held by Database

2021-01-19
Code Snippets & Tips

Teradata - Add User to a Role

2021-01-19
Code Snippets & Tips

Check User Access on Teradata

2021-01-19
Teradata

Check Role Access on Tables/Views in Teradata

2021-01-19
Teradata

Teradata Cast BIGINT to String

2020-12-27
Code Snippets & Tips

Teradata tdwallet Examples

2020-12-27
Teradata

Teradata NULLIFZERO and ZEROIFNULL Function

2020-12-26
Code Snippets & Tips

Teradata No More Room in Database Error and Table Skewness

2020-12-26
Teradata

Find out Teradata AMP (vprocs) Count

2020-12-26
Code Snippets & Tips

Teradata Hash Functions

2020-12-26
Teradata

Spark Scala: Load Data from Teradata

2020-12-19
Spark & PySpark

Teradata - Update with Joins to Another Table

2020-12-13
Teradata

Calculate MD5 in Teradata

2020-09-21
Teradata

Create Procedure with Dynamic Return Result in Teradata

2020-09-21
Teradata

Convert TimeStamp to Date in Teradata

2020-09-21
Teradata

Teradata RANDOM Number

2020-09-20
Teradata

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.

2020-09-20
Teradata

Load JSON File into Teradata via BTEQ

2020-09-14
Teradata

Load XML File into Teradata via BTEQ

2020-09-14
Teradata

Export CSV File via TPT

2020-09-14
Teradata

Export Text File via Teradata FastExport

2020-09-14
Teradata

Teradata FastLoad with Optional Quotes

2020-09-13
Teradata

Teradata FastLoad Skip Header Line

2020-09-13
Teradata

Teradata FastLoad - Load CSV File

2020-09-13
Teradata

Load CSV into Teradata via TPT

2020-09-13
Teradata

Teradata ISNULL Alternatives

2020-09-08
Teradata

Teradata RPAD - Right Padding

2020-09-07
Teradata

Teradata LPAD - Left Padding

2020-09-07
Teradata

Extract XML Data via SQL Functions in Teradata

2020-08-31
Teradata

Extract JSON Data via SQL Functions in Teradata

2020-08-31
Teradata

Select First Row in Each GROUP BY Group in Teradata

2020-08-26
Teradata

Teradata SQL - Round Numbers to Hundreds or Thousands

2020-07-26
Code Snippets & Tips

Teradata SQL - Get Rid of Spaces from String

2020-07-26
Code Snippets & Tips

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

This page shows you how to use LIKE

2020-07-26
Code Snippets & Tips

Trim Leading or/and Trailing Zeros in Teradata

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

2020-07-26
Code Snippets & Tips

Python: Save Pandas DataFrame to Teradata

2020-05-03
Spark & PySpark

Truncate table in Teradata

2020-04-22
Code Snippets & Tips

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

2020-04-22
Python Programming

Teradata SQL - Use OREPLACE to Replace or Remove Characters

2020-04-04
Code Snippets & Tips

Save DataFrame to SQL Databases via JDBC in PySpark

2020-03-20
Spark & PySpark

Teradata SUBSTRING / SUBSTR and REGEXP_SUBSTR Functions

2020-03-15
Code Snippets & Tips

Teradata SQL - COALESCE and NULLIF Functions

2020-03-15
Code Snippets & Tips

Teradata SQL - TRYCAST / TRY_CAST Function

2020-03-15
Code Snippets & Tips

Teradata SQL - LEAD and LAG OLAP Functions

2020-03-15
Code Snippets & Tips

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

2020-03-15
Code Snippets & Tips

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

2020-03-15
Teradata

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.

2019-11-18
Code Snippets & Tips

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.

2019-11-18
Code Snippets & Tips

Calculate time difference in SQL / Teradata

This code snippet shows how to calculate time differences.

2019-11-18
Code Snippets & Tips

Convert varchar to date in SQL / Teradata

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

2019-11-18
Code Snippets & Tips

Load Data from Teradata in Spark (PySpark)

2019-07-06
Spark & PySpark

Useful DBC (Data Base Computer) System Views in Teradata

2018-05-19
Teradata

Connect to Teradata database through Python

2018-01-10
Teradata

Setup Teradata in Microsoft Azure

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

2017-10-15
Teradata

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.

2017-10-15
Teradata

Teradata Tutorial – DateTime Related Functions and Examples

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

2017-10-14
Teradata

LINQ SQL to Teradata

2015-06-16
C# Programming

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

2015-05-28
Teradata

Create ETL Project with Teradata through SSIS

2015-05-16
Teradata

Connect to Teradata Virtual Machine Guest from Windows Host

2015-05-16
Teradata

Querying Teradata and SQL Server - Tutorial 2 Filtering and Sorting

2015-05-04
Teradata

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

2015-05-03
Teradata

Querying Teradata and SQL Server - Tutorial 0: Preparation

2015-05-02
Teradata

Install Teradata Express 15.0.0.8 by Using VMware Player 6.0 in Windows

2014-06-29
Teradata