CREATE TABLE `Submission` (
  `name` VARCHAR(2147483647) CHARACTER SET `UTF-16LE` NOT NULL,
  `version` VARCHAR(2147483647) CHARACTER SET `UTF-16LE` NOT NULL,
  `variant` VARCHAR(2147483647) CHARACTER SET `UTF-16LE` NOT NULL,
  `latest` BOOLEAN NOT NULL,
  `type` VARCHAR(2147483647) CHARACTER SET `UTF-16LE` NOT NULL,
  `license` VARCHAR(2147483647) CHARACTER SET `UTF-16LE` NOT NULL,
  `repository` VARCHAR(2147483647) CHARACTER SET `UTF-16LE` NOT NULL,
  `homepage` VARCHAR(2147483647) CHARACTER SET `UTF-16LE` NOT NULL,
  `documentation` VARCHAR(2147483647) CHARACTER SET `UTF-16LE` NOT NULL,
  `readme` VARCHAR(2147483647) CHARACTER SET `UTF-16LE` NOT NULL,
  `description` VARCHAR(2147483647) CHARACTER SET `UTF-16LE` NOT NULL,
  `keywords` VARCHAR(2147483647) CHARACTER SET `UTF-16LE` NOT NULL ARRAY NOT NULL,
  `uniqueId` VARCHAR(2147483647) CHARACTER SET `UTF-16LE` NOT NULL,
  `file` VARCHAR(2147483647) CHARACTER SET `UTF-16LE` NOT NULL,
  `hash` VARCHAR(2147483647) CHARACTER SET `UTF-16LE` NOT NULL,
  `authorId` VARCHAR(2147483647) CHARACTER SET `UTF-16LE` NOT NULL,
  `submissionTime` TIMESTAMP(3) WITH LOCAL TIME ZONE NOT NULL,
  `event_time` AS NOW(),
  WATERMARK FOR `event_time` AS `event_time` - INTERVAL '0.001' SECOND
) WITH (
  'connector' = 'filesystem',
  'format' = 'flexible-json',
  'path' = '${DATA_PATH}/submission.jsonl',
  'source.monitor-interval' = '10 sec'
);
