Sample Storage screen for a Custom Database Table:
Location
Fields | Description |
|---|---|
Target Location | The target location defines the path to the location for the table. |
Database Type | The database type for a connection 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 the default DDL. |
Index Create DDL Template | Optional. Specify the template for generating DDL to create Indexes on this table. Set to None to use the default DDL. |
Index Drop DDL Template | Optional. Specify the template for generating DDL to drop Indexes on this table. Set to None to use the default DDL. |
Other
Fields | Description |
|---|---|
Optional CREATE Clause | Database-specific-and-compliant DDL to append to the generated CREATE TABLE statement. |