Retrieve Exact Names of Schemas, Tables, and Columns

In order for the request to succeed, you must specify the correct parameter values. When you call endpoints that require passing schema, table, or column names as path or payload parameters, specify the names exactly as they appear in the source.

IMPORTANT: Do not rely on the example requests and responses in our REST API documentation or on how the names appear in your destination. Fivetran transforms schema, table, and column names according to our naming conventions.

We recommend that you retrieve the exact schema, table, and column names of your connector before you call endpoints that require passing schema, table, or column as path or payload parameters.

You can use either of the following methods:

• In your Fivetran dashboard: Go to the Schema tab of your connector and use the schema, table, or column names displayed there. See the following example:

  

• Using Fivetran REST API: Call the Retrieve a Connector Schema Config endpoint.

NOTE: The connector schemas define what tables and columns present in the source your connector syncs. Most Fivetran REST API endpoint requests and responses use the connector schema names as path or payload parameters. On the other hand, the destination schema that we use as a name of your connector defines how the data is stored in your destination. You specify the destination schema name either in the connector setup form or as a value of the schema payload parameter in the Create a Connector endpoint request when creating a connector.