PostgreSQL

Job options

[ AGGREGATION_PARALLELISM = <integer> ]
[ COMMENT = '<comment>' ]
[ COMPUTE_CLUSTER = <cluster_identifier> ]
[ CREATE_TABLE_IF_MISSING = { TRUE | FALSE } ]
[ END_AT = { NOW | timestamp } ]
[ RUN_INTERVAL = <integer> { MINUTE[S] | HOUR[S] | DAY[S] } ]
[ RUN_PARALLELISM = <integer> ]
[ START_FROM = { NOW | BEGINNING | timestamp } ]

Jump to

PostgreSQL job options:

• AGGREGATION_PARALLELISM

• CREATE_TABLE_IF_MISSING

General job options:

• COMMENT

• COMPUTE_CLUSTER

• END_AT

• RUN_INTERVAL

• RUN_PARALLELISM

• START_FROM

AGGREGATION_PARALLELISM — editable

Type: integer

Default: 1

(Optional) Only supported when the query contains aggregations. This is formally known as output sharding.

CREATE_TABLE_IF_MISSING

Type: Boolean

Default: false

(Optional) When true, the target table will be created automatically, otherwise the table should already exist.

Please see here for information about publications in PostgreSQL.