Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Published by Scroll Versions from space DEV and version r088
Noprint


D s ed
rtrue
editionsgdpent,gdppro,gdpsta,gdpst,gdppr

D toc

Excerpt

D s product
productgdp
rtrue
 enables you to rapidly transform disparate datasets of any size into usable data for the entire enterprise. Ingest, explore, and transform your data through a leading-edge interface, reducing the time to prepare your data from weeks to minutes. 
D s product
productgdp
 is integrated with the Google Cloud Platform and operated by partner 
D s company
.

Applicable Product Editions

These setup instructions apply to the following editions of the product:

Info

NOTE: These product editions are licensed through the Google Marketplace from

D s company
. For more information on licensing or upgrading from
D s product
productgdp
, please see the Google Marketplace listing.


  • D s product
    productgdpent

  • D s product
    productgdppro
  • D s product
    productgdpsta

  • D s product
    productgdppr
  • D s product
    productgdpst

  • D s product
    productgdple

    Info

    NOTE: If you are an existing

    D s product
    productgdple
    customer, you can use the Marketplace to upgrade to one of the supported Marketplace editions or to enable your current product edition for a new project. You can also choose to continue using
    D s product
    productgdple
    .

For more information, see Product Editions.

For more information on available plans, see https://www.trifacta.com/pricing/cloud-dataprep/.

Support packages

D s ed
editionsgdpent,gdppro,gdppr,gdpst

D s company
 offers a range of support packages. For more information, please contact 
D s support
.

Prerequisites

Before you begin, please review the following prerequisites.

Info

NOTE: The name of the service account used by the product is provided by Google and cannot be modified.


Info

NOTE:  If domain restricted sharing has been enabled as a policy in your enterprise, you must add a trust policy for the

D s item
itemGSuite domain
. If you do not have the ID for this domain, it can be provided by
D s support
.

Set up a project

To use either product edition, you must have the following already set up in the Google Cloud Platform.

Info

NOTE: If you are upgrading from

D s product
productgdp
, you should already have these services enabled.

Create or set up a Google Cloud project. In the Cloud Console, on the project selector page, select or create a Cloud project.

Info

Note: If you don't plan to keep the resources that you create in this procedure, create a project instead of selecting an existing project. After you finish these steps, you can delete the project, removing all resources associated with the project.

Go to the project selector page

Enable billing on that project. Please verify that billing is enabled for your Google Cloud project. Learn how to confirm billing is enabled for your project.

Enable services: In your project, enable the following services:

  1. D s dataflow
  2. BigQuery 
  3. Cloud Storage APIs. See Enable the APIs.

Set up your storage bucket

On 

D s storage
, you must have a bucket set up for use with your project .


In the Cloud Console, navigate to the Cloud Storage Browser page. See https://console.cloud.google.com/storage/browser.

Click Create bucket.

In the Create bucket dialog, specify the following attributes:

  1. A unique bucket name. For more information on bucket name requirements, see https://cloud.google.com/storage/docs/bucket-naming#requirements.
  2. A storage class. See https://cloud.google.com/storage/docs/storage-classes.
  3. A location where bucket data will be stored.

Click Create.

Set up your staging bucket

By default, when you enable 

D s product
productgdp
 in a project, a
D s storage
 staging bucket for 
D s dataflow
 use is automatically created for you in a U.S. region. This staging bucket is used for staging assets for use on 
D s dataflow
 jobs and is required for use with the product. If you do have permissions to create a storage bucket in the U.S, you do not need to create a storage bucket for staging and can skip to the next section. 

Info

NOTE: If you do not have permissions to create a

D s storage
bucket in the U.S., you must your own staging bucket before enabling
D s product
productgdp
in your project. This name of this bucket must begin with the following text string: dataprep-staging- followed by an identifying value.

A bucket can be created from:

Google Console: https://cloud.google.com/storage/docs/creating-buckets

Google CLI: https://cloud.google.com/storage/docs/gsutil

The staging bucket can be changed:

  • During enablement of the product in a project. You can select a different staging bucket as needed. 
  • After the product has been enabled, individual users can configure the bucket to use for staging of their assets. See User Profile Page.

Whitelist the IP address range of the 
D s item
itemService

D s ed
rtrue
editionsgdpent,gdppro,gdppr

If you are connecting to relational sources, you must whitelist the IP address range of the 

D s item
itemservice
 for your database instances.  The IP address range of the 
D s item
itemservice
 are the following:

Info

NOTE: On the database server for each relational source type (Oracle, SQL Server, etc.), you must whitelist these IP addresses.


Code Block
34.68.114.64/28
Info

NOTE: Relational datasources must be available on a public IP address that is accessible from the product.

Tip

Tip: To verify that you have whitelisted the IP address range appropriately, you can create a connection of the relational connection type from inside the

D s webapp
. This step is described later.

For more information, please contact 

D s support
.

Purchase and enable through the Google Marketplace

After you have completed the above steps, please proceed through the Google Marketplace to complete your purchase. Your purchase covers:

  • Basic entitlement
  • Licensing for each Google Cloud projects
Info

NOTE: Changes to your billing information for a project have been known to cause forced cancellation of

D s product
in a project. If possible, please confirm that the billing information is properly set for the project before you enable the product on it. If you encounter a forced cancellation, please contact Google Support. For more information, see Enable or Disable Dataprep.

For more information, see https://console.cloud.google.com/marketplace/details/trifacta/cloud-dataprep-editions .

Setup

After the product has been licensed for your project, please complete the following steps for your account.

Required permissions

When 

D s product
 is enabled for your project, the Dataprep.user role is automatically assigned to each permitted user of the project. For basic access, no additional permissions are required.

Info

NOTE: Depending on the permissions scheme in your enterprise, you may need to enable additional permissions to access features of the product or services in the

D s platform
.

For more information, see Required Dataprep User Permissions.

Additional permissions

D s ed
editionsgdpent,gdppro,gdppr

Some product editions require special permissions to use the project. For more information, see Create IAM Role for Dataprep.

Enable in the project

Info

NOTE:

D s product
must be enabled in individual projects by the project owner.

  1. In the Google Cloud Console, select the project in which you wish to enable 
    D s product
    .
  2. Open the product. See https://console.cloud.google.com/dataprep.
  3. As the project owner, you must enable access to project data for Google and 
    D s company

Login

Each user of the project must do the following:

  1. In the Google Cloud Console, select the project in which you wish to enable 
    D s product
    .
  2. Open the product. See https://console.cloud.google.com/dataprep.
  3. Accept the terms of service. 
  4. Select a 
    D s storage
     bucket to use with the product. For more information, see Enable or Disable Dataprep.
  5. The
    D s webapp
     is displayed.
  6. The first time you login, you can immediately upload a dataset and begin transforming it. For more information, see Import Basics.
  7. On subsequent logins, the Home page is displayed:

D caption
Home page

Project settings

The project owner should review the settings for your project. See Dataprep Project Settings Page.

Set up directories

Each user must configure the directories on 

D s storage
 for use with the product. You can change the directories that are used for uploads, job runs, and temp storage. 

  1. In the left nav bar, select the User icon. 
  2. In the User menu, select Preferences.
  3. The User Profile page is displayed. 
  4. As needed, you can change the Upload, Job Run, and Temp directories in your bucket. To save your changes, click Done

For more information, see User Profile Page.

Test

If you have completed the above steps, you should verify operations.

Verify operations

Before inviting other users, you should run a simple job through the product. 

Excerpt Include
Verify Operations
Verify Operations
nopaneltrue

Verify IP address whitelisting

If you have whitelisted the 

D s item
itemservice
 IP addresses for your database server, you can create a connection to the database from inside the 
D s webapp
. If you are able to successfully read data into the application from your database, then the whitelist has been specified correctly.

Info

NOTE: The database to which you are connecting must be available from the

D s item
itemservice
over the public Internet.

For more information, see Connection Types.

Invite Users

You can invite other people to join your project at this time.

Info

NOTE: First-time users of the product should access 

D s product
 by invitation only. Do not provide direct URLs to first-time users.

For more information, see https://cloud.google.com/iam/docs/quickstart.

Example Flows

When a new workspace is created, the first user is provided a set of example flows. These flows are intended to teach by example and illustrate many recommended practices for building your own flows. For more information on example flows, see Workflow Basics.

Resources

The following resources can assist users in getting started with wrangling.

Tip

Tip: Check out the product walkthrough available through in-app chat! This walkthrough steps through each phase of ingesting, transforming, and generating results for your data.

For a quick start of 

D s product
 products, see Quickstart for Dataprep.

Check out the 

D s item
itemCommunity
https://community.trifacta.com

For a basic summary of each step of the wrangling process, see  Workflow Basics .

Access documentation: To access the full customer documentation, from the left nav bar, select Help menu > Documentation.

Additional Setup

Depending on your environment, the following additional configuration steps may be required.