Skip to content

/AWS1/CL_ML_REDSHIFTMETADATA

Describes the DataSource details specific to Amazon Redshift.

CONSTRUCTOR

IMPORTING

Optional arguments:

io_redshiftdatabase TYPE REF TO /AWS1/CL_ML_REDSHIFTDATABASE /AWS1/CL_ML_REDSHIFTDATABASE

Describes the database details required to connect to an Amazon Redshift database.

iv_databaseusername TYPE /AWS1/ML_REDDATABASEUSERNAME /AWS1/ML_REDDATABASEUSERNAME

A username to be used by Amazon Machine Learning (Amazon ML)to connect to a database on an Amazon Redshift cluster. The username should have sufficient permissions to execute the RedshiftSelectSqlQuery query. The username should be valid for an Amazon Redshift USER.

iv_selectsqlquery TYPE /AWS1/ML_REDSELECTSQLQUERY /AWS1/ML_REDSELECTSQLQUERY

The SQL query that is specified during CreateDataSourceFromRedshift. Returns only if Verbose is true in GetDataSourceInput.


Queryable Attributes

RedshiftDatabase

Describes the database details required to connect to an Amazon Redshift database.

Accessible with the following methods

Method Description
GET_REDSHIFTDATABASE() Getter for REDSHIFTDATABASE

DatabaseUserName

A username to be used by Amazon Machine Learning (Amazon ML)to connect to a database on an Amazon Redshift cluster. The username should have sufficient permissions to execute the RedshiftSelectSqlQuery query. The username should be valid for an Amazon Redshift USER.

Accessible with the following methods

Method Description
GET_DATABASEUSERNAME() Getter for DATABASEUSERNAME, with configurable default
ASK_DATABASEUSERNAME() Getter for DATABASEUSERNAME w/ exceptions if field has no va
HAS_DATABASEUSERNAME() Determine if DATABASEUSERNAME has a value

SelectSqlQuery

The SQL query that is specified during CreateDataSourceFromRedshift. Returns only if Verbose is true in GetDataSourceInput.

Accessible with the following methods

Method Description
GET_SELECTSQLQUERY() Getter for SELECTSQLQUERY, with configurable default
ASK_SELECTSQLQUERY() Getter for SELECTSQLQUERY w/ exceptions if field has no valu
HAS_SELECTSQLQUERY() Determine if SELECTSQLQUERY has a value