View Template Parameters

The following are the available view template parameters.

• DataCaster views are updateable by default. Set template parameter is_updateable to specify whether a view being created in updateable. This parameter applies only when creating a view. It can be set for a specific view, or for all views in a database by default. This can be overridden in the session creating the view. For example,

  view_is_updateable=true

• DataCaster supports materialized refreshed views. The following parameter is needed only when creating views with the Java API. Set the template parameter view_auto_refresh to determine if a materialized view should be refreshed autmatically. This parameter applies when creating a view. It can be set for a specific view, or for all views in a database by default. This can be overridden in the session creating the view. For example,

  view_auto_refresh=true

• The following parameter is needed only when creating views with the Java API. Use the following template parameter to determine whether to use synchronous or periodic refresh for materialized views with automatic refresh. This parameter applies when creating a view. It can be set for a specific view, or for all views in a database by default. This can be overridden in the session creating the view. The values supported are SYNC (the default) and PERIODIC only. For example,

  view_refresh_type=SYNC

• This parameter is needed only when creating views with the Java API. Use the following template parameter to set the periodic refresh interval (in seconds) for materialized views with automatic periodic refresh. The default value is 900 seconds. This parameter applies when creating a view. It can be set for a specific view, or for all views in a database by default. This can be overridden in the session creating the view. For example,

  view_refresh_interval=900