Skip to main content

Connection Basics

In the Designer Cloud Powered by Trifacta platform, you can quickly connect to default datastores and import your file- or table-based datasets for use in the Trifacta Application. As needed, you can create connections to other datastores to which you have access and import from them.

Basic Import Process

There are multiple ways to import data into the Designer Cloud Powered by Trifacta platform, but the most direct way is to import through the Library, where all imported datasets are stored. In the Trifacta Application, click the Library icon in the left nav bar.

CS-ConnectAndImportData-LibraryPage.png

Figure: Library Page

Import Data

The Library displays all of the datasets to which you have access. To begin, click Import Data.

CS-ConnectAndImportData-ImportDataPage.png

Figure: Import Data Page

When you import data, you are selecting a connection to use, which allows you to begin navigating the connected datastore. When you locate the file or table assets, you select it for import.

Note

When you import a dataset, you are creating a reference to that source dataset. Data is not actually imported until the Designer Cloud Powered by Trifacta platform needs to use the data for job execution. Source data is never modified.

Default Connections

Designer Cloud Powered by Trifacta Enterprise Edition provides pre-configured connections to storage. Depending on your environment, you may be able to immediately access data through the following datastores, which are represented by icons in the Import Data page:

icon

Connection

Description

CS-ConnectAndImportData-icon-Upload.png

Upload

Upload a file from your local desktop.

Tip

You can always upload a file from your local desktop for immediate use in the application. Details are below.

CS-ConnectAndImportData-icon-ImportFile.png

File-based storage

The Designer Cloud Powered by Trifacta platform provides a connection to a primary file-based storage system. Also known as the base storage layer, this storage can be used for hosting datasets for import.

Uploaded files are stored on the base storage layer, as well as dataset samples.

CS-ConnectAndImportData-icon-ImportTable.png

Table-based storage

Your environment may be provided access to a table-based datastore, such as BigQuery or Redshift. From these datastores, you can select the tables or views to which you have access for import as datasets in the Designer Cloud Powered by Trifacta platform.

CS-ConnectAndImportData-icon-NewConnection.png

Other storage

You can create connections to other file- or table-based storage systems. See below for details.