Thank you both for your help.

@Pieter, I'm not sure what you mean by full context. Do you mean, DatabaseLink`SQLSelect?

@Riccardo, I don't think a key value store will work as I am looking for more database functionality. If you can give me a quick example how this would work I can try it.

Here is my updated code which still does not work.

selctTest[table_]:=
Module[{dbFilePath,conn2},

Needs["DatabaseLink`"];
dbFilePath="/wolframcloud/userfiles/*****";
conn2=DatabaseLink`OpenSQLConnection[JDBC["SQLite",dbFilePath]];

DatabaseLink`SQLSelect[conn2,table]
]

CloudDeploy[FormFunction["Table" -> {"key"-> "key","eltesting"-> "eltesting"},selctTest[#Table]&]]

Now I am getting this response:

SQLSelect[OpenSQLConnection[Global`JDBC["SQLite", "/wolframcloud/userfiles/****"]], "key"]

So it seems that database link is not running each time the form is called. How do I make Needs["DatabaseLink`"] run each time?

If you do CloudEvaluate[something, Hold] you get back the expression after it was evaluated on the cloud.

do it with your connection / db select in order to debug what is going on. database connection in the cloud is coming, but in the mean time CloudExpression is a powerful keyvalue storage that is backed by redis. If a key value store is enough for your application, CloudExpression is what you should use.

Hello Ray, You need to reload Needs["DatabaseLink"] and reopen the connection conn before launching a SQLSelect. Btw use full context to make the DatabaseLinkSQLSelect call. The reason for this is that every time you launch a Form a new cloudkernel is used (check kernel sessionid).

good luck.