BookmarkSubscribeRSS Feed
Baizee
Calcite | Level 5

Hi,

 

I just want to know in addition to importing a Teradata table via SAS VA, can we import a Teradata view using the GUI option in VA?

 

One of my users have created a TD view, but when she is trying to import that via VA, she can't see it. She can see TD tables but is unable to see the View.

 

Kind regards,

1 REPLY 1
SuryaKiran
Meteorite | Level 14

Try running LIBNAME in SAS EG or PC SAS or SAS Studio or Teradata SQL Assist and check whether those views can be accessed or not. If not then something to do with access permissions for the user. 

 

If yes then SAS VA can also read those views. Instead of typing the view names while importing try browse to see the tables or views. If your user name contains then special characters then use quotes. 

 

Note: Make sure the server, schema and other credentials to access the views are correct. 

 

image.png

Thanks,
Suryakiran

Ready to join fellow brilliant minds for the SAS Hackathon?

Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.

Register today!
Tips for filtering data sources in SAS Visual Analytics

See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 1 reply
  • 716 views
  • 0 likes
  • 2 in conversation