Creating a Scripted Sources

  1. Navigate to Modeler Prepare.
  2. Create a new scripted source.
    There are two ways to create new scripted sources:
    • Click ... and then select + Create Scripted Source.
    • Select your raw source, and then click the + icon on that source to create a new scripted source from that raw source.


  3. Specify the name for the new source, then click Confirm.


  4. Specify or edit the source Select Statement, Script, and Output Columns.


    Select Statement
    The select statement for the script. Click Validate to validate the statement.
    Script
    The script code for the scripted data source. Click Validate to validate the script.
    Output Columns
    The output columns for the scripted source. For varchar column types, you can set the column width to ensure your imported data is not truncated. The default width is 50 characters. Click +Add Column to add new columns.
  5. Click Apply.