search

llooker / blocks_redshift_admin

MIT License
19 stars 86 forks source link

Rebuild redshift_queries table less frequently. #30

Closed kyledemeule closed 6 years ago

kyledemeule commented 6 years ago

Hi @fabio-looker - thanks for the block! It's been very helpful when working with our redshift cluster + looker.

We're wondering if this particular table needs to be rebuilt this frequently? The current sql_trigger_value will update every minute, causing this table to be built every 5 minutes on our instance. We're not sure if this is necessary, especially with redshift_plan_steps and redshift_query_execution being built around once a day. Interested in your thoughts, thanks!

fabio-looker commented 6 years ago

@kyledemeule Thank you so much for catching this and submitting the pull request. It seems we originally had it once per day and someone inadvertently deleted an important bit of logic. Thanks again!

kyledemeule commented 6 years ago

Thanks for the quick reply @fabio-looker !