#teradata

As 2026 approaches, Morgan Stanley anticipates a more challenging landscape for the IT hardware sector, characterized by narrowing leadership, elevated valuations, macroeconomic inconsistencies, and rising memory costs. In this environment, strategic stock selection becomes paramount, with the firm highlighting five standout overweight recommendations. Leading the pack is Apple, poised to benefit…

Teradata, a data analytics and cloud platform company, has introduced a new generative AI capability called ask.ai for its VantageCloud Lake platform. This feature provides a natural language interface, enabling users to query their company's data and receive instant responses from VantageCloud Lake, a cloud analytics and data platform designed for AI applications. By simplifying complex coding and querying processes, ask.ai aims to boost productivity, speed, and efficiency for both technical and non-technical users, democratizing access to Teradata's powerful cloud-native platform for data analysis. This increased use of data and analytics is expected to drive innovation and positively impact business outcomes.

Natural language interfaces have become mainstream, setting new expectations for accessing and utilizing information, even within complex enterprise environments and among non-technical roles. The implementation of generative AI capabilities like ask.ai can save employees time and enhance overall productivity.

The effectiveness of generative AI tools depends on the quality of an enterprise's analytics capabilities and data sets. Teradata's VantageCloud Lake offers a harmonized data approach and rich in-database analytics to ensure the accuracy and comprehensiveness of ask.ai's results, enabling reliable cloud analytics for informed decision-making at all levels.

In Teradata system tables are stored under DBC schema.

1- For columns, it is dbc.columns

select * from dbc.columns

eg: For views,

it is dbc.tables with a filter on a column something named table_type 'V' (where V stands for Views)

select * from dbc.tables

In Teradata DBC.Tables contains many of the objects that exist on the system. (e.g. Stored Procedures, UDF, Triggers, Macros, Views, Tables, Hash Index, Join Index, etc.) The column Table Kind is used to identify the type of object.

SELECT * FROM DBC.TABLES WHERE TABLEKIND = '<see below>' A = Aggregate Function

B = Combined Aggregate Function and ordered analytical function

D = JAR E = External Stored Procedure

F = Standard Function

G = Trigger

H = Instance or Constructor Method

I = Join Index

J = Journal

M = Macro

N = Hash Index

O = No Primary Index (Table)

P = Stored Procedure

Q = Queue Table

R = Table Function

S = Ordered Analytical Function

T = Table

U = User-defined data type

V = View

X = Authorization

Y = GLOP Set

Realtime Example:-

SELECT  a.TBL_REC_ID ,b.DOMAIN_NM ,b.TGT_DB_NM ,b.SRC_TBL_NM ,b.TGT_TBL_NM ,a.COL_REC_ID ,a.SRC_TBL_COL_NM ,a.TGT_TBL_COL_NM ,a.PUB_VW_COL_NM ,a.SRC_COL_DATA_TYP ,a.TGT_COL_DATA_TYP ,a.COL_LEN ,a.COL_SCALE ,a.COL_FORMAT ,a.COL_NOT_NULL_IND ,a.FILT_CRI ,a.AS_OF_TMS ,a.UPD_TMS ,a.AS_AT_TMS ,a.SRC_DEL_IND ,a.JN_IND

Teradata is a well-known Relational Database Management System created by the Teradata Corporation. Using the concept of parallelism, Teradata is used to create large-scale data warehousing applications. A free virtual computer has been offered for anyone

Teradata is a well-known Relational Database Management System created by the Teradata Corporation. Using the concept of parallelism, Teradata is used to create large-scale data warehousing applications. A free virtual computer has been offered for anyone who wants to learn and practice. Use the following link to access Teradata’s downloads page, where you can select the type of virtual machine…