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.

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

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