datarobot (version 2.4.0)

SetupProjectFromMySQL: Function to set up a new DataRobot project using data from MySQL table

Description

This function returns the projectName specified in the calling sequence, the unique alphanumeric identifier projectId for the new project, the name of the modeling dataset uploaded to create this project, and the project creation time and date.

Usage

SetupProjectFromMySQL(server, database, table, user, port = NULL, prefetch = 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
user
Character string. The username to use to access the database
port
Optional integer. The port to reach the MySQL server. If not specified, will use the default specified by DataRobot (3306).
prefetch
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
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.

Value

This function returns a list with the following four components: