I'm using the Flink SQL API with the sql client. I would like to know if there is a reference guide for all available table properties for a specific type/format-type?
For example i want to define a CSV source-table and in the documentation it is written, that there is the option format.allow-comments' = 'true but then the client throws an error, that the option is not available.
Another example, from googling around i found the option ìgnore-first-line, but it is not in the doc.
Looks like your referenced document is legacy, in fact all table connector properties and format properties should be available from the document website:
table connector properties: https://ci.apache.org/projects/flink/flink-docs-release-1.12/dev/table/connectors/#table-sql-connectors
table format properties: https://ci.apache.org/projects/flink/flink-docs-release-1.12/dev/table/connectors/formats/
For example, the CSV format properties is here: https://ci.apache.org/projects/flink/flink-docs-release-1.12/dev/table/connectors/formats/csv.html#format-options
Hope these information can help you.