Iow to define pool for impala in gallery connection

[Sweta1987]

Hi,

I am connecting to impala database in gallery connection and the query getting executed in impala default pool.

how can I define pool in the gallery connection?

Much appreciate your response.

[Amol_Telore]

Hey @Sweta1987 

In SQL editor window of Impala connection in Alteryx. Put below command before the SQL query that needs to be executed in selected pool. It should resolve your query.

SET REQUEST_POOL = 'pool_name'

[Sweta1987]

Thank you for the response.Really appreciate.Actually I was checking if we can have the property set at gallery connection instead of individual query to avoid changing all workflows. However when I append the same (SET REQUEST_POOL = 'pool_name') in gallery connection,it still hits the default pool.Hence, I wanted to verify how we can do it at gallery level.

We have hundreds of workflow accessing implala and it's challenging to change all of  them.

[Amol_Telore · Accepted solution]

Hey @Sweta1987 

You may try below steps to specify pool name in DSN configuration. 

1. Open Impala Connection DSN configuration
2. Click on Advanced Option 
   1. 
3. Click on Server Side Properties
   1. 
4. Click on Add Button
   1. 
5. Enter Pool Name property here
   1. 
6. Click Okay. Now you will be on server side properties window. Here deselect highlighted option.
   1. 

7. Now, Click Okay.

I do not have dedicated pools created in my DB hence I could not test it. But you may try this approach as it is used for setting server side properties only. Let me know if it solves your concern.
 

[Sweta1987]

Thanks again ...actually I figured out a solution in gallery connection .We need to append SSL_REQUEST_POOL='pool name' and it works