- 14 Aug 2022
- 1 Minute to read
- Updated on 14 Aug 2022
- 1 Minute to read
- Sisense version L2022.5 or newer.
- Requires an Intermediate Storage with Write permission:
- Supported Storage: Amazon S3 for Redshift and Snowflake CDWH
- Amazon S3 Storage with Write permissions to a bucket
- Configure the intermediate storage, which is required for Build to Destination as a temporary storage before transferring it to the CDWH.
To set up the storage, see Amazon S3 documentation.
For example, Amazon S3 Buckets should be added, or add the required permissions for Sisense to create buckets. See Amazon S3 Setup Example.
- Requires a CDWH for Data Model Management and as Query layer for Live connectivity
- Supported Destinations: Snowflake, Redshift
- Prepare a CDWH Destination, the Destination database for the Build process and eventually the Source for the Dashboard and queries sent to the B2D model.
- For these purposes will define two connections to work with, a Reader and a Writer. This is required for security reasons and in order to utilize costs:
- Reader - is For executing Read queries, for example, queries that are being sent from the Dashboards
- Writer - For executing the write and manipulate related queries as part of the build process
- This separation is required to Govern the Users permissions to perform actions on the CDWH
- To allow the flexibility to choose the Warehouse to perform which task (Read or Write). A common strategy is for Write and Data Manipulation purposes to choose a small warehouse, while for the Reader and Query tasks choose a larger Warehouse
- Required configurations on the CDWH:
- Create or use an existing Database. For reference “MY_DB”
- Create or use an existing Warehouse. For reference “MY_WAREHOUSE”
- Create or use an existing User for write tasks. For reference “MY_WRITER_USER” with:
- Permissions to Add/Remove Schemas in Database “MY_DB”
- Permissions to perform all commands (DDL, DML, DCL, TCL, DQL) on Database “MY_DB” in generated Schemas
- Create or Use an existing User for read tasks. For reference “MY_VIEWER_USER” with Permissions to Query Database “MY_DB”
- On how to apply the above on each Database, please refer to the relevant CDWH documentation. See Snowflake Code and Setup Example.
Was this article helpful?
Thank you for your feedback! Our team will get back to you
How can we improve this article?
Character limit : 500