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

Community

Tables selected/Total in Schema should be able to download in the excel.

Answered
Nitin Bhagat User

1) Workday 

2) ServiceNow

 

Additional details: 

I need the ability to export both the complete list of tables available in a schema and the subset of tables currently selected into an Excel file.

The challenge is that schemas can contain a very large number of tables, and when we need to analyze them or promote selected tables from lower to higher environments, managing the selection through the UI becomes difficult and time-consuming, especially when selecting or deselecting one table at a time.

Requirements:

  1. The full list of tables and the selected tables should be downloadable in Excel format.
  2. The downloaded Excel file should also be uploadable into the schema for another pipeline, so that the same set of tables can be selected automatically in the target pipeline.

Please sign in to leave a comment.

Comments

1 comment

Date Votes
  • Official comment
    Frank Fivetranner

    Hi Nitin,



    Your goal to efficiently export and re-import table selections for large schemas is clear. While Fivetran does not currently support Excel downloads or uploads of table selections directly within the UI, a similar outcome can be achieved using our existing API tools.



    Workaround Steps:



    1. Use the Fivetran REST API to retrieve the full list of tables in your schema and the subset of selected tables. The /schemas and /tables endpoints provide this information.

    2. Export this data to a CSV or Excel file by transforming the API response as needed (e.g., using Python or a spreadsheet tool).

    3. To configure another pipeline with the same table selections, use the API to update the target connector’s selection of tables based on the previously exported set.



    Comprehensive instructions are available in our Help Center API documentation.



    Would this approach address your immediate requirements, or do you have specific constraints where the native UI-based Excel option is essential?



    Thanks,
    Frank