How Do I Back up a Connector’s Schema?

Questionlink

How do I backup my connector’s schema before I edit it?

Environmentlink

REST API - Applicable to all non-Magic Folder connectors.

Answerlink

Use our REST API to back up the connector’s schema.

NOTE: The Fivetran REST API is only available for Standard, Standard Select, Enterprise, and Business Critical accounts.

Get API key and API secretlink

1. On the Fivetran dashboard, go to the Manage Account page.
2. Go to the Settings tab.
3. Scroll down to the API Config section.
4. Select Generate new secret.
5. Copy the API key and the API secret.

Encode API key and secret to Base64 formatlink

1. Execute the following command in your terminal window. Replace the <API key> and <API secret> values with your API key and secret: echo -n '**<API key>**:**<API secret>**' | openssl base64.
2. Note the output. You must use the output as the Basic <output string> in Step 3.

Execute API requestlink

1. Execute the following request in the application of your choice, such as curl or Postman: GET api.fivetran.com/v1/connectors/{connector_id}/schemas. Use the Basic <output string> you found in Step 2.
2. Save the response in JSON format.

Reference documentslink

For more information about API connector configurations, read the following documents:

• Retrieve a Connector Schema Config
• Use Case: Create a new connector based on an existing connector’s parameters