test data/tables in Teradata Express 13.0 for VMware (4 GB)??

Teradata Express Software
Formerly this board name was Cloud Computing. The name was changed to better represent the product areas covered.
kss
N/A

test data/tables in Teradata Express 13.0 for VMware (4 GB)??

I have Teradata Express 13.0 for VMware (4 GB) up and running. But I could not find any test data/tables in there. Can someone direct me how to find test data where I can query? Do I have to download and run 40GB or 1TB in order to get the test data?

Thank you. 

3 REPLIES
Enthusiast

Re: test data/tables in Teradata Express 13.0 for VMware (4 GB)??

in TD15 I have several DB's under "Samples", there's "retail", "financial" etc. Not sure about 13

run this and you'll get some datasets to play with:

select top 50 
databasename
, tablename
, CurrentPerm
from dbc.tablesize
order by CurrentPerm desc
;

Re: test data/tables in Teradata Express 13.0 for VMware (4 GB)??

Hi,

I recently installed TDExpress15.10.0.7_Sles11_40GB_vp. However i am unable to see "Samples" DB when i query DBC.Tables. Can any one help?

Thanks.

Teradata Employee

Re: test data/tables in Teradata Express 13.0 for VMware (4 GB)??

The tables are not in the Samples DB itself, they are in databases below Samples in the hierarchy.

SELECT DatabaseName, TableName FROM DBC.TablesV

WHERE DatabaseName in (SELECT Child FROM DBC.ChildrenV WHERE Parent = 'Samples');