Teradata

The following code snippet checks user DBC's access on all Teradata objects incl. tables, views. procedures, functions, etc.   select * from dbc.allrights where UserName ='DBC'; Sample output: To check current user's access on database objects in Teradata, use the following ...

The following code snippet checks all roles with access on certain Teradata table or view.  select * from dbc.allrolerights where databasename='TestDb' and tablename = 'test_table'; Sample output: To check certain role's access on database object in Teradata, use the following query ...

Teradata Wallet (tdwallet) is a facility for storage of sensitive/secret information, such as database user password. It is included in  Teradata client utility tools .  For items stored in tdwallet, there are two parts: name of the item that uniquely identities it and the value of the ...

In Teradata, error 'no more room in database' can be common especially when data is not evenly distributed (i.e. high skewness). Sometimes when this error occurs, it might be just because of one or a few AMPs are full. For example, assuming a database with permanent space allocated as 100GB and ...

Teradata hash functions are used to decide data distributions for each row in Teradata tables. When data is inserted into a table, row hash of each record will be calculated first and then the bucket will be calculated, at last the AMP number and fallback AMP number (if fallback is enabled) will be ...

In SQL Server, JOIN can be used to update target table with values from a joined table. In Teradata, this syntax is not as simple or intuitive as SQL Server.  The following example updates table test_table1 with data from test_table2 . Database TestDb; UPDATE test_table1 FROM ...

Teradata has no built-in MD5 function thus custom function needs to be implemented for calculating MD5. This article shows you how to do that using the MD5 message digest UDF provided on Teradata Downloads. Permission CREATE FUNCTION is required for creating UDF in Teradata.  Navigate ...

A procedure contains a number of SQL statements that will be executed in sequence in Teradata. Procedures can be used to return result sets to the invoking clients. In many other databases, it is very easy to return set records to the client in a procedure as SELECT statement can be directly used.

Function CURRENT_TIMESTAMP can be used to retrieve the current timestamp: SELECT CURRENT_TIMESTAMP; Sample output: 20/09/2020 20:55:35.390000-04:00 Function CAST can be used to convert TimeStamp to DATE. SELECT CAST(CURRENT_TIMESTAMP AS DATE) Sample output: 20/09/2020 SELECT ...

RANDOM function in Teradata returns a random integer number for each row of the results table. It is a Teradata extension to the ANSI SQL:2011 standard. Random(lower_bound, upper_bound) The limits for  lower_bound   and upper_bound range from -2147483648 to 2147483647 ...