Want to Stop Rebuilding "Expensive" Parts of your Flow? Explicit Builds are the Answer!READ MORE

Doing INSERTs into Teradata from R

Antal
Level 3
Doing INSERTs into Teradata from R

I want to do INSERTs into Teradata Vantage database from an R script using the dataiku R api. Speciaficaly to support database interaction from a shiny app.

I've tried doing the following:

 

library(dataiku)

dataiku::dkuSQLQueryToData(connection="DATAIKU_DEV_03", query="insert into <database>.<table> values (1, 2, 3, 4)")

 

 

 which doesn't give an error, but also nothing happens...
I've read in the documentation (here https://doc.dataiku.com/dss/api/8.0/R/dataiku/reference/dkuSQLQueryToData.html), that in some databases a COMMIT is needed after the transaction.

However, doing:

 

dataiku::dkuSQLQueryToData(connection="DATAIKU_DEV_03", query="insert into <database>.<table> values (1, 2, 3, 4)", postQueries=c("COMMIT"))

 

Gives the error: 

 

[Teradata Database] [TeraJDBC 17.10.00.22] [Error 3706] [SQLState 42000] Syntax error: COMMIT WORK not allowed for a DBC/SQL session.

 

 

Does anyone know how to do this in Teradata database?

0 Kudos
0 Replies

Labels

?
Labels (1)
  • R

A banner prompting to get Dataiku