Page tree

Trifacta Dataprep



Contents:

If you licensed Dataprep by Trifacta before Oct. 14, 2020, you are using the Dataprep by Trifacta Legacy product edition. On October 14, 2022, this product edition will be decommissioned by Google and will be no longer available for use. Current customers of this product edition are encouraged to transition to one of the product editions hosted by Trifacta. See Product Editions.

   

Contents:


This section covers the following areas around general connectivity of Dataprep by Trifacta®.

Additional configuration may be required for individual connection types. For more information, see Connection Types.


Feature Availability: This feature is available in the following editions:

  • Dataprep by Trifacta® Enterprise Edition
  • Dataprep by Trifacta Professional Edition
  • Dataprep by Trifacta Premium

Enable

Before you begin, you must enable the Trifacta Service within your database infrastructure. For more information, see Whitelist Platform Service.

Custom SQL Query

As needed, users can create custom SQL queries to import datasets through their relational connections. This capability enables more specificity to your imported data and can be used to limit the volume of data that is transferred, which improves import performance. For more information, see Create Dataset with SQL.

Configure SSH Tunnel Connectivity

As needed, you can configure SSH tunneling between the Trifacta application and your cloud-based database infrastructure. SSH tunneling provides a more secure method of connecting to your databases.

NOTE: SSH tunneling is enabled on a per-connection basis. If enabled for a connection type, the SSH options appear under the Advanced options in the connection window.

Relational Long Loading

When you are importing a dataset, the import process can be tracked through the Import Data page and the Library page, and you can continue working in other areas of the application while the data is imported.

Type inference

By default, Dataprep by Trifacta attempts to infer the data type from schematized sources during import. In some cases, you may wish to disable type inference, which can be applied through the following mechanisms:


Enable OAuth 2.0 Connectivity

Some supported relational datastores support authentication using OAuth 2.0.

  • For each system to which you want to connect, you must create a client app in the target system. For more information, see Enable OAuth 2.0 Authentication.
  • For a target system for which you have created a client app, you must create at least one client in the Trifacta application. For more information, see Create OAuth2 Client.

Configure for Cloud SQL

Feature Availability: This feature is available in the following editions:

  • Dataprep by Trifacta® Enterprise Edition
  • Dataprep by Trifacta Professional Edition
  • Dataprep by Trifacta Premium

If your relational databases are hosted within Cloud SQL, additional configuration may be required. See Configure Connectivity for Cloud SQL.

This page has no comments.