The script formats can rang from syntax for statistical software to database schema definition. These will typically accompany some sort of data export and the syntax and data would both be used to recreate the data set in the target platform. In the case of database scripts, data can optionally be self contained by including insert statements in the syntax.

Database

Get Database Options

http://host/rds/api/package/types/MONET_DB

Database Options

{
    "objectId": "bf4ee15f-3152-4b40-8877-2f168e24bf71",
    "type": "MONET_DB",
    "optionProperties": [
        {
            "description": "File name",
            "enumValues": [],
            "label": "File name",
            "name": "fileName",
            "type": "TEXT",
            "value": "",
            "repeatable": false,
            "required": true,
            "readOnly": false
        },
        {
            "description": "Bulk import data from a CSV file instead of using insert statements",
            "enumValues": [],
            "label": "Bulk import",
            "name": "bulkImport",
            "type": "BOOLEAN",
            "value": true,
            "repeatable": false,
            "required": false,
            "readOnly": false
        },
        {
            "description": "Creates a table for each classification as well as the fact table which contains all the data",
            "enumValues": [],
            "label": "Create dimension tables",
            "name": "createDimensionTables",
            "type": "BOOLEAN",
            "value": false,
            "repeatable": false,
            "required": false,
            "readOnly": false
        },
        {
            "description": "Database name",
            "enumValues": [],
            "label": "Database name",
            "name": "dbName",
            "type": "TEXT",
            "value": "db_name",
            "repeatable": false,
            "required": true,
            "readOnly": false
        },
        {
            "description": "Specifies that the data should be added to the database script. If false only the table schemas will be created.",
            "enumValues": [],
            "label": "Generate data",
            "name": "generateData",
            "type": "BOOLEAN",
            "value": true,
            "repeatable": false,
            "required": false,
            "readOnly": false
        },
        {
            "description": "Table name",
            "enumValues": [],
            "label": "Table name",
            "name": "tableName",
            "type": "TEXT",
            "value": "table_name",
            "repeatable": false,
            "required": true,
            "readOnly": false
        },
        {
            "description": "Max columns allowed per table, if the table exceeds this number then additional tables will be created and they will need to be pulled together in a view.",
            "enumValues": [],
            "label": "Max columns",
            "name": "maxCols",
            "type": "TEXT",
            "value": 50000,
            "repeatable": false,
            "required": true,
            "readOnly": false
        }
    ]
}

Script Formats

Database