FAQ
This article covers common questions when using Omnata.
Inbound storage location configuration
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:
Modifying the inbound storage location to a database and schema outside of the app
This is required if you would like to enable Snowflake features that are not available in app-databases; such as Hybrid tables, changing tracking and others.
In the sync's Controls tab, expand Storage Location and choose Modify:
Customize the location, and enter a database and schemas that you own (outside of the app database):
Grant the following privileges (substituting for the actual database/schemas you choose):
After doing this, you should clear the sync state in order to have the streams start from the beginning again. Go to Controls tab > Sync State expander.
After the next sync run, you should be able to take ownership of the tables that the sync engine creates and enable change tracking. Ensure that you grant all privileges on each table back to the application:
Last updated