topic Can't see newly created Teradata table under Libraries in SAS EG in SAS Enterprise Guide

Can't see newly created Teradata table under Libraries in SAS EG

ijm_wf — Tue, 24 Sep 2019 03:30:53 GMT

I created a Teradata table with a data step in SAS EG, but can't see the new table under libraries even after I refresh. According to the SAS log, the table is created with the expected number of observations and variables. I also do not see the new table when I attempt to view it using Teradata SQL Assistant. Has anyone else experienced this issue? Please advise. Thanks.

libname tlibrary teradata server='ABC.XYZ.COM' connection=global dbmstemp=yes  database="ABC_TST" user="a12345@LDAP" pwd="XXXXXX" mode=Teradata;

data tlibrary.new_t_table;
	set ds1 ds2 ds3;
        run;

Re: Can't see newly created Teradata table under Libraries in SAS EG

VinitvictorCorr — Tue, 24 Sep 2019 07:17:32 GMT

right click on libraries and then click refresh

Re: Can't see newly created Teradata table under Libraries in SAS EG

Ksharp — Tue, 24 Sep 2019 12:55:59 GMT

Try to add option SCHEMA= in libname statement .

The following code could check Schema.

proc sql;
connect to  teradata(database="ABC_TST" user="a12345@LDAP" pwd="XXXXXX") ;

select *
 from connection to teradata(teradata::SQLTables) ;
quit;

Re: Can't see newly created Teradata table under Libraries in SAS EG

Tom — Tue, 24 Sep 2019 14:07:02 GMT

Did you intend to create a volatile table in Teradata? It is not clear to me that the SAS tools to show lists of datasets in a library will work to show volatile tables in a Teradata session. Try using the Teradata command HELP VOLATILE TABLE to see what volatile tables exist in your session.

proc sql ;
  connect using tlibrary ;
  select * from connection to tlibrary (help volatile table);
quit;