Roles & Permissions

In Optimove Data Share, users might find the need to apply advanced functions and data operations to achieve their goals. These might include setting up your own views, create custom service connections and apply data unloading methods to extract the data to other storage solutions where in-house teams and tech stack are natively working.

Please note that this documents describes the permission level that is provided when using the Reader Account option. If you are using a Direct Share to your Snowflake account, this is not applicable and your own R&P policy applies.

By default, users are permitted with a general PUBLIC role, which is limited to read functionalities only. As your integration with the shared data deepens, you might find the need to customize views and set up your environment in a way that serves additional needs and use cases.

For this purpose, users may want to be granted with READER_ACCOUNT_DBA role, which extends the permitted functionalities over the existing set of permissions in PUBLIC role.

What Can READER_ACCOUNT_DBA do?

Once enabled, users with this role can:

How To Request Access?

The READER_ACCOUNT_DBA role is not enabled by default.

To enable:

• Contact Optimove Support with your relevant Reader Account details.
  • Reader Account DB name
  • Username / email
• Request to enable READER_ACCOUNT_DBA for your reader account tenant.

4️⃣ Practical SQL Examples

🔹 Create a database:

CREATE DATABASE my_custom_db;

🔹 Create a view on shared data:

CREATE OR REPLACE VIEW my_custom_db.my_schema.my_view AS
SELECT *
FROM shared_db.bi.vw_campaign_results_v1_3
WHERE execution_date >= CURRENT_DATE - 7;

Snowflake Documentation References

🔗 Understanding Reader Accounts

🔗 CREATE DATABASE

🔗 CREATE VIEW

Summary

By enabling the READER_ACCOUNT_DBA role:

✅ You unlock powerful self-service capabilities.

✅ You can integrate, transform, and consume data on your own terms.

✅ You gain flexibility to create a tailored analytics workspace on top of Optimove Data Share.