About DataChico

DataChico · 03-15-2022

We are trying to troubleshoot an issue where a query is executed in Looker and shows up as ‘running’ in the query page yet it has not even been sent to redshift. The query in question has been identified by the history_id and it shows that it took 40...

DataChico · 01-31-2022

Hi All! Does anyone have thoughts on the following use-case for incremental PDT’s?I have an incremental PDT that refreshes every 30 minutes with an increment_offset of 5 days. Is it possible to set a trigger so that this PDT rebuilds in its entirety ...

DataChico · 03-02-2022

@fabio1 This is very helpful but do you have an updated version for using the new ‘API Explorer’ functionality? The original API explorer that you link to is now deprecated. Thanks!

DataChico · 02-03-2022

@moebe Thanks for sharing your previous post - looks like you’ve spent quite a bit of time with this problem. I wonder if there is any automated way to add the 1 = 1 into the datagroup? There may be a way to do it using the API, but again, a workarou...

DataChico · 02-01-2022

The underlying data would change. For example a ‘location name’ could be changed by a client, and this should be applied to all data. I’ll test option 2 - will update the thread with results!

DataChico · 02-01-2022

@IanT Thanks for the response! I don’t think the first option would work because we have data that occasionally changes going back 10+ days - which is why we would want to do an entire rebuild every night.The second option is interesting. The PDT in ...

My Stats

CodyK's Bio

Badges DataChico Earned

Recent Activity

Troubleshoot specific query - why was it queued by Looker?

Incremental PDT's - rebuild entire table nightly

Re: Auditing User Attribute values with an API script

Re: Incremental PDT's - rebuild entire table nightly

Re: Incremental PDT's - rebuild entire table nightly

Re: Incremental PDT's - rebuild entire table nightly