FAQ

This article covers common questions when using Omnata.

Inbound syncs

Granting inbound table access to other roles

If you would like to grant access to this table to other roles, you grant the OMNATA_ADMINISTRATOR role to the other role. Run the command:

grant application role OMNATA_SYNC_ENGINE.OMNATA_ADMINISTRATOR to role MY_OTHER_ROLE

Customizing the inbound table and view names

Omnata uses jinja to give you the flexibility to set custom names. See the custom naming section of inbound storage location article.

Modifying the inbound sync storage location to a database and schema outside of the app

See the section inbound storage location for privilege strategies and example grant statements.

Outbound syncs

When configuring a sync the source table being empty

You may have a row access policy in place. If so, your policy will need to return true when CURRENT_ROLE() = 'OMNATA_SYNC_ENGINE'

Record history retention

Omnata keeps a full record history of sync activity inside the app's internal tables. This is to enable record-level troubleshooting for syncs and runs. For large sync payloads, this duplicate copy of records can create a storage overhead and can increase sync post-processing times.

You can customize the retention period in days under Settings > Data Management > Record History Retention. In the case of long running sync runs, setting this parameter to Zero can cut overall sync run times by ~30%, however, you will only be able to view aggregated historical metrics for sync runs going forward.

Sync run timeout

If a sync or an object in a sync fails due to timeout, it can be the result of two possible timeout settings.

1. The timeout parameter on the individual sync. This is configured in the Deployment step of the sync creation wizard after setting the sync schedule; the default is 240min.

2. The STATEMENT_TIMEOUT_IN_SECONDS setting for the Snowflake account. This places an upper limit on the time a query can run for. The default is 2-days, but if this has been lowered, it will override the setting in the Omnata Sync application.