Docs Home Pulumi IaC Pulumi ESC Pulumi Insights Pulumi Cloud Packages Tutorials
  1. Packages
  2. Fivetran Provider
  3. API Docs
  4. Transformation
fivetran 1.6.0 published on Tuesday, Mar 25, 2025 by fivetran
fivetran/terraform-provider-fivetran

fivetran.Transformation

Explore with Pulumi AI

fivetran logo
fivetran 1.6.0 published on Tuesday, Mar 25, 2025 by fivetran
fivetran/terraform-provider-fivetran

    Resource is in ALPHA state.

    This resource allows you to add, manage and delete transformation projects in your account.

    Example Usage

    Dbt Core Transformation

    Coming soon!

    Coming soon!

    Coming soon!

    Coming soon!

    package generated_program;

import com.pulumi.Context;
import com.pulumi.Pulumi;
import com.pulumi.core.Output;
import com.pulumi.fivetran.Transformation;
import com.pulumi.fivetran.TransformationArgs;
import com.pulumi.resources.CustomResourceOptions;
import java.util.List;
import java.util.ArrayList;
import java.util.Map;
import java.io.File;
import java.nio.file.Files;
import java.nio.file.Paths;

public class App {
    public static void main(String[] args) {
        Pulumi.run(App::stack);
    }

    public static void stack(Context ctx) {
        var transformation = new Transformation("transformation", TransformationArgs.builder()
            .type("DBT_CORE")
            .paused(true)
            .schedule(TransformationScheduleArgs.builder()
                .scheduleType("TIME_OF_DAY")
                .timeOfDay("11:00")
                .build())
            .transformationConfig(TransformationTransformationConfigArgs.builder()
                .projectId("project_id")
                .name("name")
                .steps(                
                    TransformationTransformationConfigStepArgs.builder()
                        .name("name1")
                        .command("command1")
                        .build(),
                    TransformationTransformationConfigStepArgs.builder()
                        .name("name2")
                        .command("command2")
                        .build())
                .build())
            .build(), CustomResourceOptions.builder()
                .provider(fivetran_provider)
                .build());

    }
}

    resources:
  transformation:
    type: fivetran:Transformation
    properties:
      type: DBT_CORE
      paused: true
      schedule:
        - scheduleType: TIME_OF_DAY
          timeOfDay: 11:00
      transformationConfig:
        - projectId: project_id
          name: name
          steps:
            - name: name1
              command: command1
            - name: name2
              command: command2
    options:
      provider: ${["fivetran-provider"]}

    Quickstart Transformation

    Coming soon!

    Coming soon!

    Coming soon!

    Coming soon!

    package generated_program;

import com.pulumi.Context;
import com.pulumi.Pulumi;
import com.pulumi.core.Output;
import com.pulumi.fivetran.Transformation;
import com.pulumi.fivetran.TransformationArgs;
import com.pulumi.resources.CustomResourceOptions;
import java.util.List;
import java.util.ArrayList;
import java.util.Map;
import java.io.File;
import java.nio.file.Files;
import java.nio.file.Paths;

public class App {
    public static void main(String[] args) {
        Pulumi.run(App::stack);
    }

    public static void stack(Context ctx) {
        var transformation = new Transformation("transformation", TransformationArgs.builder()
            .type("QUICKSTART")
            .paused(true)
            .schedule(TransformationScheduleArgs.builder()
                .scheduleType("TIME_OF_DAY")
                .timeOfDay("11:00")
                .build())
            .transformationConfig(TransformationTransformationConfigArgs.builder()
                .packageName("package_name")
                .connectionIds(                
                    "connection_id1",
                    "connection_id2")
                .excludedModels(                
                    "excluded_model1",
                    "excluded_model2")
                .build())
            .build(), CustomResourceOptions.builder()
                .provider(fivetran_provider)
                .build());

    }
}

    resources:
  transformation:
    type: fivetran:Transformation
    properties:
      type: QUICKSTART
      paused: true
      schedule:
        - scheduleType: TIME_OF_DAY
          timeOfDay: 11:00
      transformationConfig:
        - packageName: package_name
          connectionIds:
            - connection_id1
            - connection_id2
          excludedModels:
            - excluded_model1
            - excluded_model2
    options:
      provider: ${["fivetran-provider"]}

    S For Transformation Schedule Section

    import * as pulumi from "@pulumi/pulumi";

    import pulumi

    package main

import (
	"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
)

func main() {
	pulumi.Run(func(ctx *pulumi.Context) error {
		return nil
	})
}

    using System.Collections.Generic;
using System.Linq;
using Pulumi;

return await Deployment.RunAsync(() => 
{
});

    package generated_program;

import com.pulumi.Context;
import com.pulumi.Pulumi;
import com.pulumi.core.Output;
import java.util.List;
import java.util.ArrayList;
import java.util.Map;
import java.io.File;
import java.nio.file.Files;
import java.nio.file.Paths;

public class App {
    public static void main(String[] args) {
        Pulumi.run(App::stack);
    }

    public static void stack(Context ctx) {
    }
}

    {}

    import * as pulumi from "@pulumi/pulumi";

    import pulumi

    package main

import (
	"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
)

func main() {
	pulumi.Run(func(ctx *pulumi.Context) error {
		return nil
	})
}

    using System.Collections.Generic;
using System.Linq;
using Pulumi;

return await Deployment.RunAsync(() => 
{
});

    package generated_program;

import com.pulumi.Context;
import com.pulumi.Pulumi;
import com.pulumi.core.Output;
import java.util.List;
import java.util.ArrayList;
import java.util.Map;
import java.io.File;
import java.nio.file.Files;
import java.nio.file.Paths;

public class App {
    public static void main(String[] args) {
        Pulumi.run(App::stack);
    }

    public static void stack(Context ctx) {
    }
}

    {}

    import * as pulumi from "@pulumi/pulumi";

    import pulumi

    package main

import (
	"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
)

func main() {
	pulumi.Run(func(ctx *pulumi.Context) error {
		return nil
	})
}

    using System.Collections.Generic;
using System.Linq;
using Pulumi;

return await Deployment.RunAsync(() => 
{
});

    package generated_program;

import com.pulumi.Context;
import com.pulumi.Pulumi;
import com.pulumi.core.Output;
import java.util.List;
import java.util.ArrayList;
import java.util.Map;
import java.io.File;
import java.nio.file.Files;
import java.nio.file.Paths;

public class App {
    public static void main(String[] args) {
        Pulumi.run(App::stack);
    }

    public static void stack(Context ctx) {
    }
}

    {}

    import * as pulumi from "@pulumi/pulumi";

    import pulumi

    package main

import (
	"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
)

func main() {
	pulumi.Run(func(ctx *pulumi.Context) error {
		return nil
	})
}

    using System.Collections.Generic;
using System.Linq;
using Pulumi;

return await Deployment.RunAsync(() => 
{
});

    package generated_program;

import com.pulumi.Context;
import com.pulumi.Pulumi;
import com.pulumi.core.Output;
import java.util.List;
import java.util.ArrayList;
import java.util.Map;
import java.io.File;
import java.nio.file.Files;
import java.nio.file.Paths;

public class App {
    public static void main(String[] args) {
        Pulumi.run(App::stack);
    }

    public static void stack(Context ctx) {
    }
}

    {}

    Create Transformation Resource

    Resources are created with functions called constructors. To learn more about declaring and configuring resources, see Resources.

    Constructor syntax

    new Transformation(name: string, args?: TransformationArgs, opts?: CustomResourceOptions);
    @overload
def Transformation(resource_name: str,
                   args: Optional[TransformationArgs] = None,
                   opts: Optional[ResourceOptions] = None)

@overload
def Transformation(resource_name: str,
                   opts: Optional[ResourceOptions] = None,
                   paused: Optional[bool] = None,
                   schedule: Optional[TransformationScheduleArgs] = None,
                   transformation_config: Optional[TransformationTransformationConfigArgs] = None,
                   type: Optional[str] = None)
    func NewTransformation(ctx *Context, name string, args *TransformationArgs, opts ...ResourceOption) (*Transformation, error)
    public Transformation(string name, TransformationArgs? args = null, CustomResourceOptions? opts = null)
    public Transformation(String name, TransformationArgs args)
public Transformation(String name, TransformationArgs args, CustomResourceOptions options)

    type: fivetran:Transformation
properties: # The arguments to resource properties.
options: # Bag of options to control resource's behavior.

    Parameters

    name string
    The unique name of the resource.
    args TransformationArgs
    The arguments to resource properties.
    opts CustomResourceOptions
    Bag of options to control resource's behavior.
    resource_name str
    The unique name of the resource.
    args TransformationArgs
    The arguments to resource properties.
    opts ResourceOptions
    Bag of options to control resource's behavior.
    ctx Context
    Context object for the current deployment.
    name string
    The unique name of the resource.
    args TransformationArgs
    The arguments to resource properties.
    opts ResourceOption
    Bag of options to control resource's behavior.
    name string
    The unique name of the resource.
    args TransformationArgs
    The arguments to resource properties.
    opts CustomResourceOptions
    Bag of options to control resource's behavior.
    name String
    The unique name of the resource.
    args TransformationArgs
    The arguments to resource properties.
    options CustomResourceOptions
    Bag of options to control resource's behavior.

    Constructor example

    The following reference example uses placeholder values for all input properties.

    var transformationResource = new Fivetran.Transformation("transformationResource", new()
{
    Paused = false,
    Schedule = new Fivetran.Inputs.TransformationScheduleArgs
    {
        ConnectionIds = new[]
        {
            "string",
        },
        Crons = new[]
        {
            "string",
        },
        DaysOfWeeks = new[]
        {
            "string",
        },
        Interval = 0,
        ScheduleType = "string",
        SmartSyncing = false,
        TimeOfDay = "string",
    },
    TransformationConfig = new Fivetran.Inputs.TransformationTransformationConfigArgs
    {
        ConnectionIds = new[]
        {
            "string",
        },
        ExcludedModels = new[]
        {
            "string",
        },
        Name = "string",
        PackageName = "string",
        ProjectId = "string",
        Steps = new[]
        {
            new Fivetran.Inputs.TransformationTransformationConfigStepArgs
            {
                Command = "string",
                Name = "string",
            },
        },
        UpgradeAvailable = false,
    },
    Type = "string",
});

    example, err := fivetran.NewTransformation(ctx, "transformationResource", &fivetran.TransformationArgs{
Paused: pulumi.Bool(false),
Schedule: &.TransformationScheduleArgs{
ConnectionIds: pulumi.StringArray{
pulumi.String("string"),
},
Crons: pulumi.StringArray{
pulumi.String("string"),
},
DaysOfWeeks: pulumi.StringArray{
pulumi.String("string"),
},
Interval: pulumi.Float64(0),
ScheduleType: pulumi.String("string"),
SmartSyncing: pulumi.Bool(false),
TimeOfDay: pulumi.String("string"),
},
TransformationConfig: &.TransformationTransformationConfigArgs{
ConnectionIds: pulumi.StringArray{
pulumi.String("string"),
},
ExcludedModels: pulumi.StringArray{
pulumi.String("string"),
},
Name: pulumi.String("string"),
PackageName: pulumi.String("string"),
ProjectId: pulumi.String("string"),
Steps: .TransformationTransformationConfigStepArray{
&.TransformationTransformationConfigStepArgs{
Command: pulumi.String("string"),
Name: pulumi.String("string"),
},
},
UpgradeAvailable: pulumi.Bool(false),
},
Type: pulumi.String("string"),
})

    var transformationResource = new Transformation("transformationResource", TransformationArgs.builder()
    .paused(false)
    .schedule(TransformationScheduleArgs.builder()
        .connectionIds("string")
        .crons("string")
        .daysOfWeeks("string")
        .interval(0)
        .scheduleType("string")
        .smartSyncing(false)
        .timeOfDay("string")
        .build())
    .transformationConfig(TransformationTransformationConfigArgs.builder()
        .connectionIds("string")
        .excludedModels("string")
        .name("string")
        .packageName("string")
        .projectId("string")
        .steps(TransformationTransformationConfigStepArgs.builder()
            .command("string")
            .name("string")
            .build())
        .upgradeAvailable(false)
        .build())
    .type("string")
    .build());

    transformation_resource = fivetran.Transformation("transformationResource",
    paused=False,
    schedule={
        "connection_ids": ["string"],
        "crons": ["string"],
        "days_of_weeks": ["string"],
        "interval": 0,
        "schedule_type": "string",
        "smart_syncing": False,
        "time_of_day": "string",
    },
    transformation_config={
        "connection_ids": ["string"],
        "excluded_models": ["string"],
        "name": "string",
        "package_name": "string",
        "project_id": "string",
        "steps": [{
            "command": "string",
            "name": "string",
        }],
        "upgrade_available": False,
    },
    type="string")

    const transformationResource = new fivetran.Transformation("transformationResource", {
    paused: false,
    schedule: {
        connectionIds: ["string"],
        crons: ["string"],
        daysOfWeeks: ["string"],
        interval: 0,
        scheduleType: "string",
        smartSyncing: false,
        timeOfDay: "string",
    },
    transformationConfig: {
        connectionIds: ["string"],
        excludedModels: ["string"],
        name: "string",
        packageName: "string",
        projectId: "string",
        steps: [{
            command: "string",
            name: "string",
        }],
        upgradeAvailable: false,
    },
    type: "string",
});

    type: fivetran:Transformation
properties:
    paused: false
    schedule:
        connectionIds:
            - string
        crons:
            - string
        daysOfWeeks:
            - string
        interval: 0
        scheduleType: string
        smartSyncing: false
        timeOfDay: string
    transformationConfig:
        connectionIds:
            - string
        excludedModels:
            - string
        name: string
        packageName: string
        projectId: string
        steps:
            - command: string
              name: string
        upgradeAvailable: false
    type: string

    Transformation Resource Properties

    To learn more about resource properties and how to use them, see Inputs and Outputs in the Architecture and Concepts docs.

    Inputs

    In Python, inputs that are objects can be passed either as argument classes or as dictionary literals.

    The Transformation resource accepts the following input properties:

    Paused bool
    The field indicating whether the transformation will be set into the paused state. By default, the value is false.
    Schedule TransformationSchedule
    TransformationConfig TransformationTransformationConfig
    Type string
    Transformation type. The following values are supported: DBT_CORE, QUICKSTART.
    Paused bool
    The field indicating whether the transformation will be set into the paused state. By default, the value is false.
    Schedule TransformationScheduleArgs
    TransformationConfig TransformationTransformationConfigArgs
    Type string
    Transformation type. The following values are supported: DBT_CORE, QUICKSTART.
    paused Boolean
    The field indicating whether the transformation will be set into the paused state. By default, the value is false.
    schedule TransformationSchedule
    transformationConfig TransformationTransformationConfig
    type String
    Transformation type. The following values are supported: DBT_CORE, QUICKSTART.
    paused boolean
    The field indicating whether the transformation will be set into the paused state. By default, the value is false.
    schedule TransformationSchedule
    transformationConfig TransformationTransformationConfig
    type string
    Transformation type. The following values are supported: DBT_CORE, QUICKSTART.
    paused bool
    The field indicating whether the transformation will be set into the paused state. By default, the value is false.
    schedule TransformationScheduleArgs
    transformation_config TransformationTransformationConfigArgs
    type str
    Transformation type. The following values are supported: DBT_CORE, QUICKSTART.
    paused Boolean
    The field indicating whether the transformation will be set into the paused state. By default, the value is false.
    schedule Property Map
    transformationConfig Property Map
    type String
    Transformation type. The following values are supported: DBT_CORE, QUICKSTART.

    Outputs

    All input properties are implicitly available as output properties. Additionally, the Transformation resource produces the following output properties:

    CreatedAt string
    The timestamp of when the transformation was created in your account.
    CreatedById string
    The unique identifier for the User within the Fivetran system who created the transformation.
    Id string
    The provider-assigned unique ID for this managed resource.
    OutputModelNames List<string>
    Identifiers of related models.
    Status string
    Status of transformation Project (NOT_READY, READY, ERROR).
    CreatedAt string
    The timestamp of when the transformation was created in your account.
    CreatedById string
    The unique identifier for the User within the Fivetran system who created the transformation.
    Id string
    The provider-assigned unique ID for this managed resource.
    OutputModelNames []string
    Identifiers of related models.
    Status string
    Status of transformation Project (NOT_READY, READY, ERROR).
    createdAt String
    The timestamp of when the transformation was created in your account.
    createdById String
    The unique identifier for the User within the Fivetran system who created the transformation.
    id String
    The provider-assigned unique ID for this managed resource.
    outputModelNames List<String>
    Identifiers of related models.
    status String
    Status of transformation Project (NOT_READY, READY, ERROR).
    createdAt string
    The timestamp of when the transformation was created in your account.
    createdById string
    The unique identifier for the User within the Fivetran system who created the transformation.
    id string
    The provider-assigned unique ID for this managed resource.
    outputModelNames string[]
    Identifiers of related models.
    status string
    Status of transformation Project (NOT_READY, READY, ERROR).
    created_at str
    The timestamp of when the transformation was created in your account.
    created_by_id str
    The unique identifier for the User within the Fivetran system who created the transformation.
    id str
    The provider-assigned unique ID for this managed resource.
    output_model_names Sequence[str]
    Identifiers of related models.
    status str
    Status of transformation Project (NOT_READY, READY, ERROR).
    createdAt String
    The timestamp of when the transformation was created in your account.
    createdById String
    The unique identifier for the User within the Fivetran system who created the transformation.
    id String
    The provider-assigned unique ID for this managed resource.
    outputModelNames List<String>
    Identifiers of related models.
    status String
    Status of transformation Project (NOT_READY, READY, ERROR).

    Look up Existing Transformation Resource

    Get an existing Transformation resource’s state with the given name, ID, and optional extra properties used to qualify the lookup.

    public static get(name: string, id: Input<ID>, state?: TransformationState, opts?: CustomResourceOptions): Transformation
    @staticmethod
def get(resource_name: str,
        id: str,
        opts: Optional[ResourceOptions] = None,
        created_at: Optional[str] = None,
        created_by_id: Optional[str] = None,
        output_model_names: Optional[Sequence[str]] = None,
        paused: Optional[bool] = None,
        schedule: Optional[TransformationScheduleArgs] = None,
        status: Optional[str] = None,
        transformation_config: Optional[TransformationTransformationConfigArgs] = None,
        type: Optional[str] = None) -> Transformation
    func GetTransformation(ctx *Context, name string, id IDInput, state *TransformationState, opts ...ResourceOption) (*Transformation, error)
    public static Transformation Get(string name, Input<string> id, TransformationState? state, CustomResourceOptions? opts = null)
    public static Transformation get(String name, Output<String> id, TransformationState state, CustomResourceOptions options)
    resources:  _:    type: fivetran:Transformation    get:      id: ${id}
    name
    The unique name of the resulting resource.
    id
    The unique provider ID of the resource to lookup.
    state
    Any extra arguments used during the lookup.
    opts
    A bag of options that control this resource's behavior.
    resource_name
    The unique name of the resulting resource.
    id
    The unique provider ID of the resource to lookup.
    name
    The unique name of the resulting resource.
    id
    The unique provider ID of the resource to lookup.
    state
    Any extra arguments used during the lookup.
    opts
    A bag of options that control this resource's behavior.
    name
    The unique name of the resulting resource.
    id
    The unique provider ID of the resource to lookup.
    state
    Any extra arguments used during the lookup.
    opts
    A bag of options that control this resource's behavior.
    name
    The unique name of the resulting resource.
    id
    The unique provider ID of the resource to lookup.
    state
    Any extra arguments used during the lookup.
    opts
    A bag of options that control this resource's behavior.
    The following state arguments are supported:
    CreatedAt string
    The timestamp of when the transformation was created in your account.
    CreatedById string
    The unique identifier for the User within the Fivetran system who created the transformation.
    OutputModelNames List<string>
    Identifiers of related models.
    Paused bool
    The field indicating whether the transformation will be set into the paused state. By default, the value is false.
    Schedule TransformationSchedule
    Status string
    Status of transformation Project (NOT_READY, READY, ERROR).
    TransformationConfig TransformationTransformationConfig
    Type string
    Transformation type. The following values are supported: DBT_CORE, QUICKSTART.
    CreatedAt string
    The timestamp of when the transformation was created in your account.
    CreatedById string
    The unique identifier for the User within the Fivetran system who created the transformation.
    OutputModelNames []string
    Identifiers of related models.
    Paused bool
    The field indicating whether the transformation will be set into the paused state. By default, the value is false.
    Schedule TransformationScheduleArgs
    Status string
    Status of transformation Project (NOT_READY, READY, ERROR).
    TransformationConfig TransformationTransformationConfigArgs
    Type string
    Transformation type. The following values are supported: DBT_CORE, QUICKSTART.
    createdAt String
    The timestamp of when the transformation was created in your account.
    createdById String
    The unique identifier for the User within the Fivetran system who created the transformation.
    outputModelNames List<String>
    Identifiers of related models.
    paused Boolean
    The field indicating whether the transformation will be set into the paused state. By default, the value is false.
    schedule TransformationSchedule
    status String
    Status of transformation Project (NOT_READY, READY, ERROR).
    transformationConfig TransformationTransformationConfig
    type String
    Transformation type. The following values are supported: DBT_CORE, QUICKSTART.
    createdAt string
    The timestamp of when the transformation was created in your account.
    createdById string
    The unique identifier for the User within the Fivetran system who created the transformation.
    outputModelNames string[]
    Identifiers of related models.
    paused boolean
    The field indicating whether the transformation will be set into the paused state. By default, the value is false.
    schedule TransformationSchedule
    status string
    Status of transformation Project (NOT_READY, READY, ERROR).
    transformationConfig TransformationTransformationConfig
    type string
    Transformation type. The following values are supported: DBT_CORE, QUICKSTART.
    created_at str
    The timestamp of when the transformation was created in your account.
    created_by_id str
    The unique identifier for the User within the Fivetran system who created the transformation.
    output_model_names Sequence[str]
    Identifiers of related models.
    paused bool
    The field indicating whether the transformation will be set into the paused state. By default, the value is false.
    schedule TransformationScheduleArgs
    status str
    Status of transformation Project (NOT_READY, READY, ERROR).
    transformation_config TransformationTransformationConfigArgs
    type str
    Transformation type. The following values are supported: DBT_CORE, QUICKSTART.
    createdAt String
    The timestamp of when the transformation was created in your account.
    createdById String
    The unique identifier for the User within the Fivetran system who created the transformation.
    outputModelNames List<String>
    Identifiers of related models.
    paused Boolean
    The field indicating whether the transformation will be set into the paused state. By default, the value is false.
    schedule Property Map
    status String
    Status of transformation Project (NOT_READY, READY, ERROR).
    transformationConfig Property Map
    type String
    Transformation type. The following values are supported: DBT_CORE, QUICKSTART.

    Supporting Types

    TransformationSchedule, TransformationScheduleArgs

    ConnectionIds List<string>
    The list of the connection identifiers to be used for the integrated schedule. Not expected for QUICKSTART transformations
    Crons List<string>
    Cron schedule: list of CRON strings. Used for for CRON schedule type
    DaysOfWeeks List<string>
    The set of the days of the week the transformation should be launched on. The following values are supported: MONDAY, TUESDAY, WEDNESDAY, THURSDAY, FRIDAY, SATURDAY, SUNDAY. Used for for INTEGRATED schedule type
    Interval double
    The time interval in minutes between subsequent transformation runs. Used for for INTERVAL schedule type
    ScheduleType string
    The type of the schedule to run the Transformation on. The following values are supported: INTEGRATED, TIMEOFDAY, INTERVAL, CRON.
    SmartSyncing bool
    The boolean flag that enables the Smart Syncing schedule
    TimeOfDay string
    The time of the day the transformation should be launched at. Supported values are: "00:00", "01:00", "02:00", "03:00", "04:00", "05:00", "06:00", "07:00", "08:00", "09:00", "10:00", "11:00", "12:00", "13:00", "14:00", "15:00", "16:00", "17:00", "18:00", "19:00", "20:00", "21:00", "22:00", "23:00". Used for for TIMEOFDAY schedule type
    ConnectionIds []string
    The list of the connection identifiers to be used for the integrated schedule. Not expected for QUICKSTART transformations
    Crons []string
    Cron schedule: list of CRON strings. Used for for CRON schedule type
    DaysOfWeeks []string
    The set of the days of the week the transformation should be launched on. The following values are supported: MONDAY, TUESDAY, WEDNESDAY, THURSDAY, FRIDAY, SATURDAY, SUNDAY. Used for for INTEGRATED schedule type
    Interval float64
    The time interval in minutes between subsequent transformation runs. Used for for INTERVAL schedule type
    ScheduleType string
    The type of the schedule to run the Transformation on. The following values are supported: INTEGRATED, TIMEOFDAY, INTERVAL, CRON.
    SmartSyncing bool
    The boolean flag that enables the Smart Syncing schedule
    TimeOfDay string
    The time of the day the transformation should be launched at. Supported values are: "00:00", "01:00", "02:00", "03:00", "04:00", "05:00", "06:00", "07:00", "08:00", "09:00", "10:00", "11:00", "12:00", "13:00", "14:00", "15:00", "16:00", "17:00", "18:00", "19:00", "20:00", "21:00", "22:00", "23:00". Used for for TIMEOFDAY schedule type
    connectionIds List<String>
    The list of the connection identifiers to be used for the integrated schedule. Not expected for QUICKSTART transformations
    crons List<String>
    Cron schedule: list of CRON strings. Used for for CRON schedule type
    daysOfWeeks List<String>
    The set of the days of the week the transformation should be launched on. The following values are supported: MONDAY, TUESDAY, WEDNESDAY, THURSDAY, FRIDAY, SATURDAY, SUNDAY. Used for for INTEGRATED schedule type
    interval Double
    The time interval in minutes between subsequent transformation runs. Used for for INTERVAL schedule type
    scheduleType String
    The type of the schedule to run the Transformation on. The following values are supported: INTEGRATED, TIMEOFDAY, INTERVAL, CRON.
    smartSyncing Boolean
    The boolean flag that enables the Smart Syncing schedule
    timeOfDay String
    The time of the day the transformation should be launched at. Supported values are: "00:00", "01:00", "02:00", "03:00", "04:00", "05:00", "06:00", "07:00", "08:00", "09:00", "10:00", "11:00", "12:00", "13:00", "14:00", "15:00", "16:00", "17:00", "18:00", "19:00", "20:00", "21:00", "22:00", "23:00". Used for for TIMEOFDAY schedule type
    connectionIds string[]
    The list of the connection identifiers to be used for the integrated schedule. Not expected for QUICKSTART transformations
    crons string[]
    Cron schedule: list of CRON strings. Used for for CRON schedule type
    daysOfWeeks string[]
    The set of the days of the week the transformation should be launched on. The following values are supported: MONDAY, TUESDAY, WEDNESDAY, THURSDAY, FRIDAY, SATURDAY, SUNDAY. Used for for INTEGRATED schedule type
    interval number
    The time interval in minutes between subsequent transformation runs. Used for for INTERVAL schedule type
    scheduleType string
    The type of the schedule to run the Transformation on. The following values are supported: INTEGRATED, TIMEOFDAY, INTERVAL, CRON.
    smartSyncing boolean
    The boolean flag that enables the Smart Syncing schedule
    timeOfDay string
    The time of the day the transformation should be launched at. Supported values are: "00:00", "01:00", "02:00", "03:00", "04:00", "05:00", "06:00", "07:00", "08:00", "09:00", "10:00", "11:00", "12:00", "13:00", "14:00", "15:00", "16:00", "17:00", "18:00", "19:00", "20:00", "21:00", "22:00", "23:00". Used for for TIMEOFDAY schedule type
    connection_ids Sequence[str]
    The list of the connection identifiers to be used for the integrated schedule. Not expected for QUICKSTART transformations
    crons Sequence[str]
    Cron schedule: list of CRON strings. Used for for CRON schedule type
    days_of_weeks Sequence[str]
    The set of the days of the week the transformation should be launched on. The following values are supported: MONDAY, TUESDAY, WEDNESDAY, THURSDAY, FRIDAY, SATURDAY, SUNDAY. Used for for INTEGRATED schedule type
    interval float
    The time interval in minutes between subsequent transformation runs. Used for for INTERVAL schedule type
    schedule_type str
    The type of the schedule to run the Transformation on. The following values are supported: INTEGRATED, TIMEOFDAY, INTERVAL, CRON.
    smart_syncing bool
    The boolean flag that enables the Smart Syncing schedule
    time_of_day str
    The time of the day the transformation should be launched at. Supported values are: "00:00", "01:00", "02:00", "03:00", "04:00", "05:00", "06:00", "07:00", "08:00", "09:00", "10:00", "11:00", "12:00", "13:00", "14:00", "15:00", "16:00", "17:00", "18:00", "19:00", "20:00", "21:00", "22:00", "23:00". Used for for TIMEOFDAY schedule type
    connectionIds List<String>
    The list of the connection identifiers to be used for the integrated schedule. Not expected for QUICKSTART transformations
    crons List<String>
    Cron schedule: list of CRON strings. Used for for CRON schedule type
    daysOfWeeks List<String>
    The set of the days of the week the transformation should be launched on. The following values are supported: MONDAY, TUESDAY, WEDNESDAY, THURSDAY, FRIDAY, SATURDAY, SUNDAY. Used for for INTEGRATED schedule type
    interval Number
    The time interval in minutes between subsequent transformation runs. Used for for INTERVAL schedule type
    scheduleType String
    The type of the schedule to run the Transformation on. The following values are supported: INTEGRATED, TIMEOFDAY, INTERVAL, CRON.
    smartSyncing Boolean
    The boolean flag that enables the Smart Syncing schedule
    timeOfDay String
    The time of the day the transformation should be launched at. Supported values are: "00:00", "01:00", "02:00", "03:00", "04:00", "05:00", "06:00", "07:00", "08:00", "09:00", "10:00", "11:00", "12:00", "13:00", "14:00", "15:00", "16:00", "17:00", "18:00", "19:00", "20:00", "21:00", "22:00", "23:00". Used for for TIMEOFDAY schedule type

    TransformationTransformationConfig, TransformationTransformationConfigArgs

    ConnectionIds List<string>
    The list of the connection identifiers to be used for the integrated schedule. Also used to identify packagename automatically if packagename was not specified
    ExcludedModels List<string>
    The list of excluded output model names
    Name string
    The transformation name
    PackageName string
    The Quickstart transformation package name
    ProjectId string
    The unique identifier for the dbt Core project within the Fivetran system
    Steps List<TransformationTransformationConfigStep>
    UpgradeAvailable bool
    The boolean flag indicating that a newer version is available for the transformation package
    ConnectionIds []string
    The list of the connection identifiers to be used for the integrated schedule. Also used to identify packagename automatically if packagename was not specified
    ExcludedModels []string
    The list of excluded output model names
    Name string
    The transformation name
    PackageName string
    The Quickstart transformation package name
    ProjectId string
    The unique identifier for the dbt Core project within the Fivetran system
    Steps []TransformationTransformationConfigStep
    UpgradeAvailable bool
    The boolean flag indicating that a newer version is available for the transformation package
    connectionIds List<String>
    The list of the connection identifiers to be used for the integrated schedule. Also used to identify packagename automatically if packagename was not specified
    excludedModels List<String>
    The list of excluded output model names
    name String
    The transformation name
    packageName String
    The Quickstart transformation package name
    projectId String
    The unique identifier for the dbt Core project within the Fivetran system
    steps List<TransformationTransformationConfigStep>
    upgradeAvailable Boolean
    The boolean flag indicating that a newer version is available for the transformation package
    connectionIds string[]
    The list of the connection identifiers to be used for the integrated schedule. Also used to identify packagename automatically if packagename was not specified
    excludedModels string[]
    The list of excluded output model names
    name string
    The transformation name
    packageName string
    The Quickstart transformation package name
    projectId string
    The unique identifier for the dbt Core project within the Fivetran system
    steps TransformationTransformationConfigStep[]
    upgradeAvailable boolean
    The boolean flag indicating that a newer version is available for the transformation package
    connection_ids Sequence[str]
    The list of the connection identifiers to be used for the integrated schedule. Also used to identify packagename automatically if packagename was not specified
    excluded_models Sequence[str]
    The list of excluded output model names
    name str
    The transformation name
    package_name str
    The Quickstart transformation package name
    project_id str
    The unique identifier for the dbt Core project within the Fivetran system
    steps Sequence[TransformationTransformationConfigStep]
    upgrade_available bool
    The boolean flag indicating that a newer version is available for the transformation package
    connectionIds List<String>
    The list of the connection identifiers to be used for the integrated schedule. Also used to identify packagename automatically if packagename was not specified
    excludedModels List<String>
    The list of excluded output model names
    name String
    The transformation name
    packageName String
    The Quickstart transformation package name
    projectId String
    The unique identifier for the dbt Core project within the Fivetran system
    steps List<Property Map>
    upgradeAvailable Boolean
    The boolean flag indicating that a newer version is available for the transformation package

    TransformationTransformationConfigStep, TransformationTransformationConfigStepArgs

    Command string
    The dbt command in the transformation step
    Name string
    The step name
    Command string
    The dbt command in the transformation step
    Name string
    The step name
    command String
    The dbt command in the transformation step
    name String
    The step name
    command string
    The dbt command in the transformation step
    name string
    The step name
    command str
    The dbt command in the transformation step
    name str
    The step name
    command String
    The dbt command in the transformation step
    name String
    The step name

    Import

    1. To import an existing fivetran_transformation resource into your Terraform state, you need to get Transformation ID via API call GET https://api.fivetran.com/v1/transformations to retrieve available projects.

    2. Fetch transformation details for particular transformation-id using GET https://api.fivetran.com/v1/transformations/{transformation-id} to ensure that this is the transformation you want to import.

    3. Define an empty resource in your .tf configuration:

    hcl

    resource “fivetran_transformation” “my_imported_fivetran_transformation” {

    }

    1. Run the pulumi import command:
    $ pulumi import fivetran:index/transformation:Transformation my_imported_fivetran_transformation {Transformation ID}
    1. Use the terraform state show command to get the values from the state:

    terraform state show ‘fivetran_transformation.my_imported_fivetran_transformation’

    1. Copy the values and paste them to your .tf configuration.

    To learn more about importing existing cloud resources, see Importing resources.

    Package Details

    Repository
    fivetran fivetran/terraform-provider-fivetran
    License
    Notes
    This Pulumi package is based on the fivetran Terraform Provider.
    fivetran logo
    fivetran 1.6.0 published on Tuesday, Mar 25, 2025 by fivetran
    fivetran/terraform-provider-fivetran