This function is deprecated. Use SetupProjectFromDataSource
instead.
SetupProjectFromPostgreSQL(server, database, table, username,
port = NULL, driver = NULL, fetch = NULL, useDeclareFetch = NULL,
projectName = NULL, password = NULL, encryptedPassword = NULL,
maxWait = 60 * 60)
character. The address of the MySQL server
character. The name of the database to use
character. The name of the table to fetch
character. The username to use to access the database
integer. Optional. The port to reach the PostgreSQL server. If not specified, will use the default specified by DataRobot (5432).
character. Optional. Specify ODBC driver to use. If not specified - use DataRobot default. See the values within datarobot.enums.POSTGRESQL_DRIVER
integer. Optional. 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
logical. Optional. 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.
numeric. Optional. String specifying a project name.
character. Optional. The plaintext password to be used to access MySQL
database. Will be first encrypted with DataRobot. Only use this or encryptedPassword
,
not both.
character. Optional. The encrypted password to be used to access
integer. 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.
This function returns a list with the following four components:
The name assigned to the DataRobot project
The unique alphanumeric project identifier for this DataRobot project
The name of the CSV modeling file uploaded for this project
Character string containing the time and date of project creation
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.
# NOT RUN {
SetupProjectFromPostgreSQL(server = 'myServer',
database = 'myDatabase',
table = 'myTable',
user = 'postgres',
port = '12345')
# }
Run the code above in your browser using DataLab