Test an Initialization Block's Query

Test the initialization block's initialization query to confirm that the connection pool is working properly, the query returns the expected values, and the values are correctly assigned to the variables that you defined.

It is best practice to create and use a dedicated connection pool for initialization blocks. See About Connection Pools for Initialization Blocks.

If an initialization block fails because of a particular connection pool, then no more initialization blocks using that connection pool are processed. Instead, the connection pool is blocked and subsequent initialization blocks for that connection pool are skipped.

1. On your home page, click Navigator and then click Semantic Models.
2. In the Semantic Models page, click a semantic model to open it.
3. Click Variables .
4. In the Variables pane, browse or search for the initialization block that you want to test and double-click it.
5. In the Initialization Block, click the Variables tab and then click Test Query.