Learn R Programming
RemixAutoML (version 0.5.0)

SQL_SaveTable: SQL_SaveTable

Description

SQL_SaveTable create a database table

Usage

SQL_SaveTable(
  DataToPush,
  DBConnection,
  SQLTableName = "",
  RowNames = NULL,
  ColNames = TRUE,
  CloseChannel = TRUE,
  AppendData = FALSE,
  AddPK = TRUE,
  Safer = TRUE
)

Arguments

DataToPush

data to be sent to warehouse

DBConnection

RemixAutoML::SQL_Server_DBConnection()

SQLTableName

The SQL statement you want to run

RowNames

c("Segment","Date")

ColNames

Column names in first row

CloseChannel

TRUE to close when done, FALSE to leave the channel open

AppendData

TRUE or FALSE

AddPK

Add a PK column to table

Safer

TRUE

See Also

Other Database: AutoDataDictionaries(), ExecuteSSIS(), SQL_ClearTable(), SQL_DropTable(), SQL_Query_Push(), SQL_Query(), SQL_Server_BulkPull(), SQL_Server_BulkPush(), SQL_Server_DBConnection(), SQL_UpdateTable()