Create Record type from SQL View

Just choose database as the source but don't enable data sync.

docs.appian.com/.../configure-record-data-source.html 

Thanks. I just disabled the related feature and it worked. But how it will refresh without sync if new data enters into view table?

Non-synced records are what I call real-time records. They are not in the cache. So a real-time record that is backed by a view is queried as it is accessed. So, write to the base tables using either write records or write to datastore or.... As long as the base tables are updated (and the view is not materialized on a schedule) it will get the latest data.

Non-synced records are what I call real-time records. They are not in the cache. So a real-time record that is backed by a view is queried as it is accessed. So, write to the base tables using either write records or write to datastore or.... As long as the base tables are updated (and the view is not materialized on a schedule) it will get the latest data.