CreateSchema
Generates a schema file for the current data source. This procedure defines the structure of tables, views, and columns to enable consistent mapping and metadata management for CSV-based integrations.
CreateSchema
Creates a local schema file (.rsd) from an existing table or view in the data model.
The schema file is created in the directory set in the Location connection property when this procedure is executed. You can edit the file to include or exclude columns, rename columns, or adjust column datatypes.
The cmdlet checks the Location to determine if the names of any .rsd files match a table or view in the data model. If there is a duplicate, the schema file will take precedence over the default instance of this table in the data model. If a schema file is present in Location that does not match an existing table or view, a new table or view entry is added to the data model of the cmdlet.
Input
| Name | Type | Description |
| TableName | String | Specifies the name of the collection that defines the schema and determines the name of the generated schema (.rsd) file. |
| URI | String | DEPRECATED: The URI is now resolved automatically based on the TableName input. |
| FileName | String | Specifies the name of the generated schema file (.rsd file). Use the Location connection property to define the directory path where the schema file is stored. |
Result Set Columns
| Name | Type | Description |
| Result | String | Indicates whether the schema creation operation completed successfully or failed. The Result output returns a value of Success or Failure. |
| FileData | String | Returns the contents of the generated schema file when the FileName input is empty. This output provides the schema data directly instead of writing it to a file. |