Hey everyone, I've noticed some recurring challeng...
# community-support
j
Hey everyone, I've noticed some recurring challenges with the slow post hook (related to uploading artifacts) and certain databases hitting limit errors (Namely SAS types). You might recall discussions in this channel about these issues. ✨ A Temporary fix had been Identified: ✨ • Performing a full refresh on elementary seems to alleviate the problem. However, this is a temporary band-aid, not a long-term solution, since it fully refreshes the models, which isn't ideal for frequent repetition. šŸ“š Exploring the Docs: šŸ“š • I've dug into the documentation and found an alternative approach: running the artifact models (
dbt run --select elementary.edr.dbt_artifacts
). This method is schedule-friendly and appears to be an effective workaround - potentially addressing human error? It's recommended to run if the post hooks are disabled but this issue is with the post-hooks so quite rightly folk might not thinks it's required. šŸ¤” Seeking Deeper Understanding: šŸ¤” • While this fix seems to work, I'm curious about the underlying reasons. Why does running these models resolve the issue in the post hook? I have a few theories, but I'd love to hear your insights or confirmations for a clearer understanding and peace of mind. 😊 Looking forward to your thoughts and insights! TY