Skip to main content
Documentation
Feature Requests Trust Center Status Page

Community

Transformations: API Support for Transformation Management

Completed
David DeWitt User

The number of dbt transformations that we have is growing and is expected to grow rapidly in the next several months.

Managing a large number of dbt transformations via the web-based GUI is cumbersome at best.

When do you plan to include dbt Transformation Management as one of the options available through your REST API?

Please sign in to leave a comment.

Comments

11 comments

Date Votes
  • Anna User

    Hi David DeWitt, we are planning to build Transformations management for dbt into the REST API later this year. If you're interested in being an early tester of this feature, I'd love to hear more about your use case. What actions would you find most valuable in the API?

  • Richard Flitcroft User

    I would like to be able to create a Basic Transformation via the rest API.

    My use case is that I have another service which creates a significant number of connectors, and for each there is a small SQL statement that I want to be executed after the connector has completed synchronisation.

  • Anna User

    Thanks for elaborating Richard– I'll add this to our backlog and continue to monitor this ticket for upvotes. In the meantime, I'm interested in setting up some time with you to discuss the transformations roadmap more broadly.

  • Anna User

    David DeWitt Richard Flitcroft are you still interested in a REST API for transformations? Would love to add you to our Private Preview program.

  • Richard Flitcroft User

    Note that we have notification of events by webhook, this is not as important.
    However we are aiming to automate and codify as much as possible, and the ability to configure DBT setup via API/Terraform would be valuable.

  • David DeWitt User
      Yes, please add me to your private preview program.
     
      Thank you!
  • Anna User

    Sent you both an email with more information!

  • Brian Marks User

    Are there any plans to add transformations to the Fivetran Terraform provider? If that's available in private preview, I'd be happy to try it out!

    https://github.com/fivetran/terraform-provider-fivetran 

  • Anna User

    Hi Brian Marks– transformations endpoints are not yet on the short-term roadmap for the Terraform provider. I've opened a ticket for the relevant team to prioritize!

  • Ashwini Ramu User
    • Edited

    Is this feature implemented ? I was looking in support docs to trigger transformation via API or Airflow

  • Anna User

    @Ashwini Transformations API endpoints are available in Private Preview, and the docs are here. Please reach out directly to transformations@fivetran.com if you run into issues.