Usage
SetupProjectFromPostgreSQL(server, database, table, username, port = NULL, driver = NULL, fetch = NULL, useDeclareFetch = NULL, projectName = NULL, password = NULL, encryptedPassword = NULL, maxWait = 60 * 60)
Arguments
server
Character string. The address of the MySQL server
database
Character string. The name of the database to use
table
Character string. The name of the table to fetch
username
Character string. The username to use to access the database
port
Optional integer. The port to reach the PostgreSQL server.
If not specified, will use the default specified by DataRobot (5432).
driver
Optional character string. Specify ODBC driver to use. If not specified - use DataRobot default.
See the values within datarobot.enums.POSTGRESQL_DRIVER
fetch
Optional integer. If specified, specifies the number of rows
to stream at a time from the database. If not specified, fetches all results at once.
This is an optimization for reading from the database
useDeclareFetch
Optional bool. On True, server will fetch result as available using DB cursor.
On False it will try to retrieve entire result set - not recommended for big tables.
If not specified - use the default specified by DataRobot.
projectName
Optional character string specifying a project name.
password
Optional character string. The plaintext password to be used to access MySQL database.
Will be first encrypted with DataRobot. Only use this or `encryptedPassword`, not both.
encryptedPassword
Optional character string. The encrypted password to be used to access MySQL database.
Only use this or `password`, not both.
maxWait
The maximum time to wait for each of two steps: (1) The initial project creation
request, and (2) data processing that occurs after receiving the response to this initial
request.