Integrate the Fivetran API with the Python API

Setup the Fivetran API trigger to run a workflow which integrates with the Python API. Pipedream's integration platform allows you to integrate Fivetran and Python remarkably fast. Free for developers.

Start for free — no credit card required

Watch a demo

Trusted by 1,000,000+ developers from startups to Fortune 500 companies

Popular Fivetran and Python Actions#

Run Python Code with the Python API

Write Python and use any of the 350k+ PyPi packages available. Refer to the Pipedream Python docs to learn more.

Try it

Overview of Fivetran#

The Fivetran API enables automated, effortless replication of data from various sources into a cloud warehouse. By leveraging Fivetran in Pipedream, you can programmatically manage your Fivetran connectors, set up and control data pipelines, and trigger data syncs. Pipedream's serverless platform allows for the creation of workflows that can respond to HTTP requests, process events on a schedule, and interact with numerous other services to create complex automation solutions.

Connect Fivetran#

import { axios } from "@pipedream/platform"
export default defineComponent({
  props: {
    fivetran: {
      type: "app",
      app: "fivetran",
    }
  },
  async run({steps, $}) {
    return await axios($, {
      url: `https://api.fivetran.com/v1/users`,
      headers: {
        "Content-Type": `application/json`,
      },
      auth: {
        username: `${this.fivetran.$auth.api_key}`,
        password: `${this.fivetran.$auth.api_secret}`,
      },
    })
  },
})

Overview of Python#

Develop, run and deploy your Python code in Pipedream workflows. Integrate seamlessly between no-code steps, with connected accounts, or integrate Data Stores and manipulate files within a workflow.

This includes installing PyPI packages, within your code without having to manage a requirements.txt file or running pip.

Below is an example of using Python to access data from the trigger of the workflow, and sharing it with subsequent workflow steps:

Connect Python#

def handler(pd: "pipedream"):
  # Reference data from previous steps
  print(pd.steps["trigger"]["context"]["id"])
  # Return data for use in future steps
  return {"foo": {"test":True}}

Start for free — no credit card required

Watch a demo