Skip to main content

Connection Types

You can create the following types of connections from the Dataprep by Trifacta platform. You can use the given links to create connection.

Create Connection

  1. Click Connections in the left nav bar.

  2. In the Connections page, click Create.


Search: Enter a search string in the search bar to locate connections of interest.


Search scans the selected category. For broadest search results, select the All types tab.


You can create connections to datasources hosted on Cloud SQL. Search for Cloud SQL for the available connection types, or select the Cloud SQL version of the connection type of interest. Required configuration information is very similar.

Early Preview: Early Preview connections are read-only connection types that get you connected to your data, so that you can begin exploring and importing as soon as possible. For more information, see Early Preview Connection Types.

I'm interested: Click I'm interested to upvote adding the connection type to the Trifacta Application. Help chart the future direction of connectivity!

For more information, see Create Connection Window.

Connection Categories

In the Create Connection window, connections are organized according to the following categories.


Connect to data storage for your web-based applications.

REST API connectivity:

Build connections to API endpoints that can be accessed by the Trifacta Application. For more information, see REST API Connections.


These connections enable you to access data in your CRM or ERP systems.


General relational connectivity:

Relational connectivity is available for the following product editions:


Availability of individual connection types may vary. Please see the documentation for the specific connection type for details.


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

These connections pertain to relational database sources.


Unless otherwise noted, authentication to a relational connection requires basic authentication (username/password) credentials.

If you are connecting the Dataprep by Trifacta platform to any relational source of data, such as Oracle, you must add the Alteryx Service to your whitelist for those resources.


Relational datasources must be available on a public IP address that is accessible to the Dataprep by Trifacta platform.

For more information, see Whitelist Platform Service.


Click the Cloud SQL version of a connection type to create a connection to your Cloud SQL instance of the selected database.


You can create connections to the listed file-based datastores or to other API-based storage.


You can create connections to the datastores for popular marketing solutions.

Connections to Base Storage Layer

Connections of these type are automatically created for you.

Cloud Storage

Enable: Automatically enabled. For more information, see Google Cloud Storage Access.

Create New Connection: n/a

Default Connections

These connections are automatically enabled and configured with the product.


Enable: Automatically enabled.

Create New Connection: n/a


Enable: Automatically enabled. For more information, see BigQuery Connections.

Create New Connection: n/a