GET_MODEL_ATTRIBUTE
Extracts either a specific attribute from a model or all attributes from a model. Use this function to view a list of attributes and row counts or view detailed information about a single attribute. The output of GET_MODEL_ATTRIBUTE is a table format where users can select particular columns or rows.
Syntax
GET_MODEL_ATTRIBUTE ( USING PARAMETERS model_name = 'model‑name' [, attr_name = 'attribute' ] )
Parameters
model_name |
Name of the model (case-insensitive). |
attr_name | Name of the model attribute to extract. If omitted, the function shows all available attributes. Attribute names are case-sensitive. |
Privileges
Non-superusers: model owner, or USAGE privileges on the model
Examples
This example returns a summary of all model attributes.
=> SELECT GET_MODEL_ATTRIBUTE ( USING PARAMETERS model_name='myLinearRegModel'); attr_name | attr_fields | #_of_rows -------------------+---------------------------------------------------+----------- details | predictor, coefficient, std_err, t_value, p_value | 2 regularization | type, lambda | 1 iteration_count | iteration_count | 1 rejected_row_count | rejected_row_count | 1 accepted_row_count | accepted_row_count | 1 call_string | call_string | 1 (6 rows)
This example extracts the details
attribute from the myLinearRegModel
model.
=> SELECT GET_MODEL_ATTRIBUTE ( USING PARAMETERS model_name='myLinearRegModel', attr_name='details'); coeffNames | coeff | stdErr | zValue | pValue -----------+--------------------+---------------------+-------------------+----------------------- Intercept | -1.87401598641074 | 0.160143331525544 | -11.7021169008952 | 7.3592939615234e-26 waiting | 0.0756279479518627 | 0.00221854185633525 | 34.0890336307608 | 8.13028381124448e-100 (2 rows)