Ask Your Question

Reading from a view : JDBC multitable consumer

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

Gautam gravatar image

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

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

Referring to "reading from views" section here.

edit retag flag offensive close merge delete


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 -0600 )edit

3.8.0 Enable Non-Incremental Load is unchecked

Gautam gravatar imageGautam ( 2019-04-11 14:36:30 -0600 )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 -0600 )edit

1 Answer

Sort by ยป oldest newest most voted

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

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


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 -0600 )edit

Could you pls share what permission were added to Db. I am also facing same issue @Gautam

KaranAhuja gravatar imageKaranAhuja ( 2020-03-12 12:23:19 -0600 )edit
Login/Signup to Answer

Question Tools

1 follower


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

Seen: 412 times

Last updated: Apr 11 '19