pass parameters to file with sql statement using Scala to be used sqlContext.sql(string)

[#1]

I am using Scala on data science workbench and I have file with sql stataement would like to make it dynamic sql by passing argument to parameters. I then would like to pass it  sqlContext.sql(string) .

This is what I have tried but does not work.

val FromDate = "2019-02-25"

val sqlfile = fromFile("sql3.py").getLines.mkString

val result = sqlContext.sql(sqlfile)

On the file I have:

Select col1, col2 from table1 where transdate = '${FromDate}'

Any help would be appreciated. 

Thanks

[#2]

Did you try CDSW environment variables? 

https://www.cloudera.com/documentation/data-science-workbench/latest/topics/cdsw_environment_variabl...

[#3 · Accepted solution]

This worked at the end..

val FromDate = "2019-02-25"

val sqlfile = fromFile("sql3.py").getLines.mkString

val sqlfil2= sqlfile.replace("${From_timeStamp}",From_timeStamp)

val result = sqlContext.sql(sqlfile2)

On the file I have:

Select col1, col2 from table1 where transdate = '${FromDate}'

[#4]

Only one question I have the line which you made bold in that you are trying to replace "from_timestamp" but you are using "fromdate" in your sql file.

Any reason behind it ?