Error: Connection Doesn't Have Schema Config

Issue

After creating a connection using the Fivetran API, calling the Retrieve a Connection Schema Config endpoint returns the following error:

{
  "code": "NotFound_SchemaConfig",
  "message": "Connection with id '<connection_id>' doesn't have schema config"
}

Environment

• All connectors
• Fivetran REST API
• Endpoint: GET /v1/connections/{connection_id}/schemas

Resolution

To resolve this issue, do one of the following before calling the Retrieve a Connection Schema Config endpoint:

• Wait for the initial sync to complete.
• Call the Reload a Connection Schema Config and wait for the reload to finish.
• In Fivetran, go to the Schema tab for the connection and wait for the schema to load.

Cause

When you create a connection using the API, we generate the schema configuration only after one of the following occurs:

• The connection's initial sync
• A schema reload is triggered using the REST API
• A schema is loaded in the Fivetran UI

This issue occurs when you call the Retrieve a Connection Schema Config endpoint before the schema configuration exists. For more information, see our Connection Schema Config documentation.