Ask Your Question
0

Reading from a view : JDBC multitable consumer

asked 2019-04-11 10:45:18 -0500

Gautam gravatar image

updated 2019-04-11 10:56:42 -0500

I'm running into validation errors on trying to specify a view in table_config if I specify a view name in table_name_pattern field.

It works fine when I specify a table. The validation error on the UI is: JDBC_66 - No Tables matches the configuration in the origin.

Is there something else which needs to be configured. I was reading this https://streamsets.com/documentation/...

Referring to "reading from views" section here.

edit retag flag offensive close merge delete

Comments

Which version of SDC? Also confirm if you have Enable Non-Incremental Load checked or not.

iamontheinet gravatar imageiamontheinet ( 2019-04-11 14:09:36 -0500 )edit

3.8.0 Enable Non-Incremental Load is unchecked

Gautam gravatar imageGautam ( 2019-04-11 14:36:30 -0500 )edit

So does your view actually have primary key? If not, check Enable Non-Incremental Load and see it it works.

iamontheinet gravatar imageiamontheinet ( 2019-04-11 15:16:10 -0500 )edit

1 Answer

Sort by ยป oldest newest most voted
0

answered 2019-04-12 08:46:00 -0500

Gautam gravatar image

It was a problem with permissions on the DB we had. Heave it resolved now. Should I mark this question as closed someway?

edit flag offensive delete link more

Comments

I am glad you got it resolved. Just, fyi, if the table does not have PK and Enable Non-Incremental Load is not checked, you get the same error. Let's leave the QandA open in case someone runs into the same issue.

iamontheinet gravatar imageiamontheinet ( 2019-04-12 09:25:39 -0500 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2019-04-11 10:45:18 -0500

Seen: 52 times

Last updated: Apr 11