# Script

This tab is used to insert a JSON script when creating the model to distribute for any kind of source database.

This JSON script which will be stored on a streaming system (e.g. Kafka or Kinesis) so that it can easily be used by another business process, or sent to a Snowflake target database.

The JSON structure is in multi-blocks. It includes static and dynamic parts.

It is user-defined. No specific predefined pattern has to be followed.

Example of script:

```
  "flowFuncName": "RAW_CBR_SF",
  "flowTechName": {
    "db": {
      "alias": "VENUS",
      "server": "VENUS.server",
      "instance": "",
      "base": "",
      "engine": "AS400",
      "source": "",
      "zone": "",
      "techName": ""
    },
    "flatfile": {
      "serverType": "",
      "connexionString": "",
      "sourceFolder": "",
      "souceApplication": "",
      "techName": ""
    },
    "realtime": {
      "siteName": "",
      "engine": "",
      "captor": "",
      "sourceApplication": "",
      "techName": ""
    }
  },
  "instanceType": "",
  "modType": {
    mod: "",
    "batchNumber": ""
  },
  "eventTimestamp": "#FC.JRNDATTIM#",
  "flowTimestamp": " ",
  "transformTimestamp": " ",
  "eventUniqueReferenceID": " ",
  "eventType": "INSERT",
  "sourceReference": {
    "table": "",
    "filename": "",
    "realtime": ""
  },
  "schemaVersion": "",
  "data": {
    #O.DATA#
  },
```

Dynamic parts are:

| ```<br>#O.DATA#<br>``` | ```<br>#FC.JRNDATTIM#<br>``` |
| --- | --- |
| Standard variable that contains all the desired columns from the source table and<br>the O. buffer of the transformation tool.<br><br>Its output structure is as follows:<br><br>{<br><br>"column1\_alpha":"xxxxxxx",<br><br>"column2\_num":-999.999,<br><br>"column3\_date":"20201201"<br><br>} | System variable that contains the date and time of the transaction for the<br>table. It can be found in the S. buffer of the transformation tool. |

Information noteNote: Do not forget to include the associated metadata (see [Environment metadata](https://help.qlik.com/talend/en-US/change-data-capture-reference-guide/7.3/environment-metadata)).