Is there any one using Teradata Studio and encountering the following.
The connectivity is via JDBC.
I have a schema test and user id test. After I created table under the schema test , I could not see my table from the Explorer. I need to highlight the table and import data.
What I can see is . Where is my table?
You have to expand the Data Source Explorer a couple of more layers:
If you created the table by running the CREATE TABLE SQL in the SQL Editor, you might need to use the Refresh context menu item on the Tables node of the tree in order to see the newly created table.
It may be that you have created the table and pressed the button, but it errored out and never got created too. Try to refresh.
You can also double check by using
select databasename,tablename from dbc.tables where tablename='your-tablename -here'
Once you see that it is there in Result set viewer, search for it in the explorer by expanding the Data source explorer, one by one level.
select databasename,tablename from dbc.tables where tablename='W01SPM_CAL'
have the correct output.
The tool version is 15.
The default setting of the preference "Show Databases and Users in Hierarchical Display" is to have the Data Source Explorer show databases that have a database other than DBC as its owner as a subnode of the database that owns it. You can see and set the preference by selecting the Preferences menu item in the Window menu then expanding the Teradata Datatools Preferences category and selecting the Data Source Explorer Load Preferences. It's the first item in the "What to display" section.
Could it be that you have that preference set to its default and the database is owned by another database other than DBC? If so, you can expand the database that owns the pmr72292999738 and it will show up as a node under the owner database.
Or you can uncheck the preference "Show Databases and Users in Hierarchical Display" and all the databases in the system will be shown.
Customers want this behavior by default because their systems often have a very large number of databases and the time to load the information that is collected was taking longer than they wanted to wait. Also, this is the behavior of the SQL Assistant tool.
Chuckbert, Thank you very much for helping me find the tables. As I am a new guy for Teradata but I have knowledge of Oracle and DB2. So, I want to ask more questions for me to better understan the TD structure if you have time to answer(I won't ask more questions in this post :)).
Sorry for the bornig questions.
1. A user is associated with a login profile and yes, can have nested databases. Nested databases are created using the FROM <DatabaseName> clause in the CREATE DATABASE statement. providing the owning user or database.
2. Excerpt from the Teradata Database Administration documentation: