Group: Database
Name | Description |
|---|---|
AWSPerformCOPYFromS3 | Indicates whether COPY command will be issued when importing records |
AWSRedshiftDistributionStyle | If set, DISTSTYLE is used for all RPI-generated tables. Values are 0=AUTO, 1=EVEN, 2=KEY, ALL=3 |
AWSRetainCOPYGeneratedFilesInS3 | Indicates whether files (*.gz) generated for COPY bulk import will be retained |
AWSSourceS3BucketName | Fully qualified name of AWS S3 external content provider and bucket name to use |
AzureSQLDWDistributionType | If set, offer history tables will be created either ROUND_ROBIN=0 or HASH=1 |
AzureSQLDWDropStatisticsOnTempTables | If set, statistics will be dropped on all temp tables created |
DatabaseInsertBatchLimit | Insert batch size limit used by specific databases when inserting and updating rows |
DatabaseSpecificRetryableErrorEnabled | Controls if query execution can be retried when 'Invalid object name' database error has occurred |
DB2RunStatsEnabled | If set, enables RUNSTATS on all generated tables and indexes |
DisableDatabaseObjectQualification | Indicates whether to fully qualify database object names |
GoogleBigQueryUseInformationSchema | If set, the INFORMATION_SCHEMA will be used to retrieve tables and views |
OracleAudienceTempTablesIndexDisabled | If set, disables indexing on all audience temp tables |
OracleDegreeOfParallelism | Indicates the DOP for single database or cluster configurations |
OracleDMLSessionParallelismEnabled | If set, enables DML session parallelism |
OracleOptimizerDynamicSamplingLevel | Overrides the level [0 - 8] of optimizer_dynamic_sampling configuration at a session level |
OracleRunTableStats | If set, run statistics on tables |
OracleTempTablesParallelismEnabled | If set, enables parallelism on all temporary tables |
OracleTempTablesPKConstraintDisabled | If set, disables the primary key constraint on all Dataflow_XXX temp tables |
OracleUseDirectPathInsert | If set, direct-path hint will be appended into INSERT-SELECT queries on all audience temp tables |
OracleUseHashEnabled | If set, enables USE_HASH hint on all sub-queries |
PostgresUseReplicaIdentity | If set, REPLICA IDENTITY is used to create all RPI-generated audience tables |
SQLServerDisableRowLockHint | If set, ROWLOCK will be disabled from INSERT, DELETE and UPDATE queries on all RPI-generated tables |
SQLServerIndexTempTables | Controls if indexes are created on temporary audience tables |
SQLServerUseColumnStoreIndexTempTables | Controls if clustered column store indexes are created on temporary audience tables |
SQLServerUseCountBig | If set, queries will use the Count_Big statement instead of Count |
SQLServerUseCreateTableInsert | If set, CREATE TABLE and INSERT is used to create all RPI-generated audience tables |
SQLServerUseIdentityTempTables | If set, identity is used to generate unique id for temporary audience tables |
SQLServerUseSelectIntoOverUpdate | If set, SELECT INTO query is used to update records from a temporary audience table |
SQLServerUseTabLockHint | If set, TABLOCK hint will be appended into INSERT-INTO queries on all RPI-generated temporary tables |
SQLServerUseTempFlagTables | Uses intermediate tables in SQL Server when creating attribute flag fields |
SQLServerUseWildcardCount | If set, queries will use the COUNT(*). Otherwise, queries will use the COUNT({primary key}) |
TeradataIndexTempTables | Controls if indexes are created on temporary audience Teradata tables |
TeradataUsePrimaryIndex | If set, PRIMARY INDEX is used for all RPI-generated tables. Otherwise, PRIMARY KEY will be used |
TeradataUseTableCharacterSet | RPI-generated tables character set; 1 = UNICODE, 2 = LATIN, or 0 = Don't specify the constraint |
YellowbrickDistributionType | If set, DISTRIBUTE is used for all RPI-generated tables. Values are 0=COLUMN, 1=REPLICATE, 2=RANDOM |