Error: Field 'table' Is Required

Issue

When setting up an S3 connection using the Fivetran REST API, the following error appears in the request response:

Field 'table' is required

Environment

• Connector: AWS S3
• Connection method: REST API

Resolution

To resolve this issue, include the table_group_name parameter in the request payload. For more information, see our Amazon S3 REST API config parameters.

Cause

This issue occurs when the table_group_name parameter is missing from the request payload. This parameter is required because it forms part of the string used in combination with the schema parameter to constitute the connection name. It is mandatory because it allows multiple Merge Mode file type connections to be created, which can then sync to a single destination schema. The table_group_name parameter allows the connection to differentiate datasets internally when loading to the destination.