Hi All,
We have requirement to fetch data from source PostgreSQL database as per a
condition, hence need to pass a binding variable in query used in Data
Source API as below:
var DeptNbr = 10
val dataSource_dF=cc.load("jdbc",Map("url"->"jdbc:postgresql://
10.00.00.000:5432/db_test?user=username&password=password","driver"->"org.postgresql.Driver","dbtable"->"(select*
from schema.table1 where dept_number=DeptNbr) as table1"))
But it errors saying expected ';' but found '='
Note: As it is an iterative approach hence cannot use constants but need to
pass variable to query
If anybody had a similar implementation to pass binding variable while
fetching data from source database using Data Source than please provide
details on the same
Regards,
Satish Chandra
