Deployment Options (Project)

Description

The Deployment Options property is available in Project Settings.

You can configure different deployment options.

Format

The Deployment Options is a List of multiple values.

It is possible to select several values.

The possible values are:

• Generate Drop Table Statements:
  • If selected, the Drop Table statements will be generated
  • In a development mode, it is better to generate the Drop Table statements to delete the existing tables before deploying a new version
  • In production, you usually uncheck this option to keep the existing data in your tables 
• Generate Drop Load Control Schema:
  • Option available only for Snowflake Generators
  • If selected, the Drop Schema statement will be generated for the Load Control one only
  • In a development mode, it is better to delete the existing Load Control before deploying a new version
  • In production, you usually uncheck this option to keep the existing data in the Load Control tables

Example:

Default Value

The default value is:

• Snowflake Generators:

  • Generate Drop Table Statements and Generate Drop Load Control Schema

• Other Generators:
  • Generate Drop Table Statements