Sample Storage screen for a Custom Database Table:

Location

Fields

Description

Target Location

The target location that defines the path to the location for the table.

Database Type

The database type for a connection that is used for target data warehouse tables.

Create DDL Template

Optional. Specify the template to use for generating DDL for this table. Set to None to use default DDL.

Index Create DDL Template

Optional. Specify the template to use for generating DDL to create Indexes on this table. Set to None to use default DDL.

Index Drop DDL Template

Optional. Specify the template to use for generating DDL to drop Indexes on this table. Set to None to use default DDL.

Other

Fields

Description

Optional CREATE Clause

Database-specific-and-compliant DDL to append to the generated CREATE TABLE statement.


  • No labels