PrerequisiteThe database user for Cluster must have CREATE TABLE permission.
- Select .
On Select system page, select the System, and your authentication method:
Option Description Use current session Use the current user's session. Enter credentials Enter the Username and Password of a user with access to the selected system.
Define the parameters for analysis.
Parameter Description Data source Select the Database, Table, Identifier column, and Sample size.The Identifier column must be unique.You can also specify additional options such:
- Scaling method: You can use Std (standard deviation), Midrange (distance from mean), or No scaling.
- Number of clusters to generate from the data
- Maximum number of iterations that the algorithm runs before quitting if the convergence threshold has not been met.
Analysis type Select the type of analysis to perform: KMeans or KModes. Target columns Select at least 2 columns from the Data source.
- [Optional] Click SHOW SQL then PREVIEW SQL to preview the generated SQL.
If you change the parameters, select RUN again.
Select a Database, enter a unique Prefix to identify the output table created by the analysis, and click RUN ANALYSIS.
Standard character requirements for Advanced SQL Engine tables apply.If you enter a prefix used for existing tables, those tables are overwritten.