Skip to main content
Docs
Feature Requests Onboarding Trust Center Status Page

Community

Exporting Schema

Answered
Subhro User

Needed some help to export the active connector schemas from the database.

Please sign in to leave a comment.

Comments

2 comments

Date Votes
  • Official comment
    Kevin Kim Fivetranner

    Hi Subhro,

    Thanks for your post in our portal!

    I need more information to make sure that I understand your request. Could you clarify what you are hoping to accomplish? What are you trying to export, and where are you trying to export to?

  • Florent Julien User

    I did find a workaround - we could use the following API endpoint to do this:

    GET https://api.fivetran.com/v1/connectors/{connector_id}/schemas

    This would return the list you are looking for, albeit in a JSON format - you could however parse it to produce a more readable format if you'd like!

    But this is a workaround and have a csv file with the info directly available in the Ui will be very helpful. This should be easy to do as the API endpoint already exist in your backend.

    One of the main pain points are: as the search is clearly not doing the job, we loose a lot of time to find tables/columns. Also, if we have several similar connectors, doing a comparison is too painful, having an export/reimport of the schema will be really helpful.

    Thanks for considering that.