CreateUserTable
Creates a schema definition for a MongoDB collection, mapping document structure to a tabular format.
Input
| Name | Type | Description |
| CatalogName | String | The catalog that contains the MongoDB collection. |
| SchemaName | String | The schema associated with the MongoDB collection. |
| TableName | String | The name of the MongoDB collection for which a schema definition is being created. |
| Location | String | The file path where the generated schema definition will be saved. |
| UserTableTempTable | String | The temporary table that contains all column metadata rows used to generate the schema definition. |
| ColumnName | String | The column name field expected in each metadata row of UserTableTempTable. |
| ColumnDataType | String | The SQL data type field expected in each metadata row of UserTableTempTable. |
| ColumnSize | String | The column size field expected in each metadata row of UserTableTempTable. |
| ColumnScale | String | The numeric scale field expected in each metadata row of UserTableTempTable. |
| ColumnIsKey | String | The primary key indicator field expected in each metadata row of UserTableTempTable ('true' for key columns, 'false' otherwise). |
| ColumnIsNull | String | The nullable indicator field expected in each metadata row of UserTableTempTable ('true' for nullable columns, 'false' otherwise). |
| ColumnDefault | String | The default value field expected in each metadata row of UserTableTempTable. |
| ColumnAutoIncrement | String | The auto-increment indicator field expected in each metadata row of UserTableTempTable ('true' for auto-increment columns, 'false' otherwise). |
Result Set Columns
| Name | Type | Description |
| AffectedTables | String | Indicates the number of tables created. Returns '1' if the schema was successfully created, otherwise '0'. |