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

SAS Innovate 2025: Register Now

Registration is now open for SAS Innovate 2025 , our biggest and most exciting global event of the year! Join us in Orlando, FL, May 6-9.
Sign up by Dec. 31 to get the 2024 rate of just $495.
Register now!

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
  • 804 views
  • 0 likes
  • 2 in conversation