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