Physical Modeling › Teradata Physical Property Editors › Create a New Teradata Profile

Create a New Teradata Profile

You can use the Profile editor to create a new profile that defines system parameters that a group of users can share in a Teradata physical model.

To define a Teradata profile

1. Click Profiles on the Database menu.

   The Profile Editor opens.

2. Select a profile and work with the following options:

   Note: Click New on the toolbar to create a new authorization.

   Name

   Specifies the name of the profile.

   Default Database

   Specifies the Teradata database that this profile belongs to.

   Generate

   Generates DDL for this object during Forward Engineering.

3. Complete the following fields on the General tab:

   Spool

   Specifies the number of bytes for the spool files.

   Temporary

   Specifies the number of storage bytes allocated for temporary tables.

   Cost profile (Teradata 12 Property Only)

   Specifies the cost profile.

4. Work with the other tabs in the editor to access additional design features, for example:
   • Specify and order the account names for a selected profile on the Accounts tab
   • Specify password options for a selected profile on the Password tab
5. (Optional) Click the Comment tab and enter any comments you want associated with the profile.
6. (Optional) Click the UDP tab to work with user-defined properties for the profile.
7. Click Close.

   The Profile Editor closes.

More information:

Specify and Order the Account IDs in a Teradata Profile

Specify Password Options of a Teradata Profile

Add a Comment in a Property Editor

Add a UDP in a Physical Property Editor