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:
For more information, see Dataprep Project Settings Page.
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:
BigQuery Execution
Logical and physical optimization of jobs
For more information, see BigQuery Running Environment.
For individual flows, all general and BigQuery optimizations must be enabled. For more information, see Flow Optimization Settings Dialog.