Hi Team,
Here we try to intergrate databrick from custom application.
databrickTableInsertion: async function(data){
console.log("DAtabrick insertion db ", data.payload);
var token = "*";
var server_hostname = "freshworks-biz-apps-prod.cloud.databricks.com";
var http_path = "*";
console.log("DAtabrick insertion 1 ");
const client = new DBSQLClient();
console.log("DAtabrick insertion 2 ");
client.connect(
options = {
token: token,
host: server_hostname,
path: http_path
}).then(
async client => {
const session = await client.openSession();
const queryOperation = await session.executeStatement(
statement = "SELECT 1",
options = { runAsync: true });
console.log("DAtabrick insertion 3 ", queryOperation);
const result = await queryOperation.fetchAll();
console.log("DAtabrick insertion 4 ", queryOperation);
await queryOperation.close();
console.log("DAtabrick insertion result 5 ", result);
await session.close();
await client.close();
console.log("DAtabrick insertion result 7 ", );
renderData(null, { "status": 200, "message": data.payload });
}).catch(error => {
console.log(error);
renderData({ "status": error ? error.status : 500, "message": error }, null);
});
}
};```
The above code is written in server.js and it is not working in our sandbox instance but working in local.
Can someone help in this?