BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
maxd
Calcite | Level 5

I have a data job that needs to output NCOA data into an existing table in Teradata. However, I'm getting an error (32: Data Access Plugin - Output table doesn't exist) when I run the data job. I've made sure the correct output table is selected under properties in the Data Target (Update) node and the inputs (DSN, Schema_name, Table_name, Fields, Primary_key, etc) to the Data Target (Update) node are correct based on my existing table in Teradata. What is required in the Data Target (Update) node to insert data into an empty table? 

1 ACCEPTED SOLUTION

Accepted Solutions
Patrick
Opal | Level 21

@maxd

The message 32: Data Access Plugin - Output table doesn't exist looks to me like:

- Access to Teradata as such is working

- Either the table does really not exist in Teradata or your user connecting to Teradata doesn't have the right privileges to "see" the table.

View solution in original post

2 REPLIES 2
Patrick
Opal | Level 21

@maxd

The message 32: Data Access Plugin - Output table doesn't exist looks to me like:

- Access to Teradata as such is working

- Either the table does really not exist in Teradata or your user connecting to Teradata doesn't have the right privileges to "see" the table.

maxd
Calcite | Level 5

After giving the user correct access to the table in Teradata, the job is running. Thank you for your guidance.

sas-innovate-2026-white.png



April 27 – 30 | Gaylord Texan | Grapevine, Texas

Registration is open

Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!

Register now

How to connect to databases in SAS Viya

Need to connect to databases in SAS Viya? SAS’ David Ghan shows you two methods – via SAS/ACCESS LIBNAME and SAS Data Connector SASLIBS – in this video.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 2 replies
  • 1207 views
  • 0 likes
  • 2 in conversation