Skip to main content

Configure Running Environments

This section provides overview information on how to configure the running environments accessible from your deployment of the Trifacta Application.

Arunning environmentis the set of services that are used to execute a job.

  • A job can include tasks to do the following:

    • Ingest data

    • Transform data

    • Profile data

    • Sample data

    • Generate results

  • A running environment can be hosted on the Trifacta node or across a cluster that is connected to the product.

Trifacta Photon

Hosted on the Trifacta node, Trifacta Photon is an in-memory running environment designed for high performance on small- to medium-sized jobs.

Note

This feature may not be available in all product editions. For more information on available features, see Compare Editions.

Note

Trifacta Photon lives in the Alteryx VPC. These jobs are not executed in a customer VPC. Data is streamed to the Alteryx VPC for transformation and is not stored within the VPC.

Note

You cannot cancel jobs that have been launched on Trifacta Photon.

Configuration:

Trifacta Photon may require enablement in your project or workspace:

Dataflow

Dataflow is a fully managed, serverless data processing service that is hosted in the Google Cloud Platform. Managed by Google, this service is enabled by default when you enable Dataprep by Trifacta in any of your Google Cloud Platform projects.

Configuration:

  • Access to the Dataflow service is governed through permissions in the IAM roles for users. Access is enabled by default. For more information, see Required Dataprep User Permissions.

  • Jobs are run on Dataflow using service accounts. The default Compute Engine service account deployed to your project has sufficient permissions to run Dataflow jobs. For more information, see Google Service Account Management.

BigQuery

Note

This feature may not be available in all product editions. For more information on available features, see Compare Editions.

BigQuery is a cloud-based data warehouse platform that is fully integrated into the Google Cloud Platform. BigQuery supports a standard SQL dialect for querying datasets and tables and enables the writing of results back from the product. For more information, see https://cloud.google.com/products/bigquery/.

For datasets and outputs that are hosted in BigQuery, you can configure the Trifacta Application to perform the transformation steps of your job in BigQuery. In this manner, no data needs to be transferred to and from the data warehouse, and performance should be significantly better.

Tip

Jobs must be enabled for execution in BigQuery for each flow. For more information, see Flow Optimization Settings Dialog.

Limitations:

Note

BigQuery is not a running environment that you explicitly select or specify as part of a job. If all of the requirements are met, then the job is executed in BigQuery when you selectDataflow. For more information on limitations, see Overview of Job Execution.

Configuration:

  • A project owner must enable the following features in the project:

  • For individual flows, all general and BigQuery optimizations must be enabled. For more information, see Flow Optimization Settings Dialog.

In this section: