SSIS Components for DataRobot

Build 21.0.7930

Projects

Datarobot Projects

Table Specific Information

Queries to Projects will get information for all Projects. Information for a single, specific project can be retrieved by querying with the Id for that specific project:
SELECT * FROM Projects WHERE Id = 'abcdefghi'

Columns

Name Type Description
id [KEY] String the id of a project
projectName String the name of a project
fileName String the name of the dataset used to create the project
stage String the stage of the project - if modeling, then the target is successfully set, and modeling or predictions can proceed.
autopilotMode Int the current autopilot mode, either 0 for full autopilot, 1 for semi-automatic, or 2 for manual mode
created Datetime the time of project creation
target String the target of the project
metric String the metric used to select the best-performing models
partition String a json aggregate containing information on the partitioning of the project into training, holdout, and validation sets
recommender String a json aggregate containing options for recommender problems
advancedOptions String a json aggregate specifying advanced settings for the project
positiveClass Int if the project uses binary classification, the class designated to be the positive class. Otherwise, null.
maxTrainPct Int the maximum percentage of the dataset that can be used to successfully train a model without going into the validation data train a model without going into the validation data
scaleoutMaxTrainPct Int the maximum percentage of the dataset that can be used to successfully train a scaleout model without going into the validation data. May exceed maxTrainPct, in which case only scaleout models can be trained up to this point.
scaleoutMaxTrainRows Int the maximum number of rows of the dataset that can used be used to successfully train a scaleout model without going into the validation data. May exceed maxTrainRows, in which case only scaleout models can be trained up to this point.
holdoutUnlocked Boolean whether the holdout has been unlocked
targetType String either Regression, Binary (for binary classification) or Multiclass, dependingon the selected target

Copyright (c) 2021 CData Software, Inc. - All rights reserved.
Build 21.0.7930