Description Usage Arguments Value Examples
Transfers table from one database to the another without overloading R memory. Best used when databases don't have a connection to eachother.
1 | copy_loop_to(conn1, conn2 = NULL, name, n = NULL, statement)
|
conn1: |
Connection to initial database where the table is coming from. |
conn2: |
Connection to the database where the table is transferring to. If conn2 is NULL then conn2 will default to initial database. |
name: |
Name of table on conn2 database |
n: |
Batch loader, amount of data to be transferred with each cycle. |
statement: |
SQL statement on initial database. |
Transfers table from intital database to another.
1 2 | #Sends table (created from sql statement) from post database to tera database with a batch load of 100.
copy_loop_to(post, tera, "testdata", 100, "SELECT * FROM TESTTABLE")
|
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.