Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

[BUG] Snowflake Query Results trigger does not emit on prop configuration #11811

Closed
andrewjschuang opened this issue May 3, 2024 · 1 comment · Fixed by #11828
Closed

[BUG] Snowflake Query Results trigger does not emit on prop configuration #11811

andrewjschuang opened this issue May 3, 2024 · 1 comment · Fixed by #11828
Assignees
@jcortes
Labels
bug Something isn't working triaged For maintainers: This issue has been triaged by a Pipedream employee
Projects
Component (Source and Action) Backlog

Comments

@andrewjschuang
Copy link
Collaborator

Describe the bug
Snowflake - Query Results trigger

When the Emit Individual prop is set to false, the trigger logs show the warning:

Pipedream detected that component was still running code. Make sure you await all promises.

Not sure what’s the exact issue, but I suspect it's when it emits the rowStream object.

Sample SQL Query:

select count(*) as workflow_run_count from collection where date_trunc(hour, execution_timestamp) >= DATEADD(HOUR,-3,sysdate());

May be related to the specific SQL query above, other queries should be tested.

Additional context
Reported by a user.
@andrewjschuang andrewjschuang added the bug Something isn't working label May 3, 2024
@andrewjschuang andrewjschuang added this to To Do in Component (Source and Action) Backlog via automation May 3, 2024
@dylburger dylburger added the triaged For maintainers: This issue has been triaged by a Pipedream employee label May 3, 2024
@andrewjschuang andrewjschuang moved this from To Do to Prioritized in Component (Source and Action) Backlog May 3, 2024
@jcortes jcortes self-assigned this May 6, 2024
@jcortes jcortes moved this from Prioritized to Doing in Component (Source and Action) Backlog May 6, 2024
@jcortes jcortes mentioned this issue May 6, 2024
Merged
@jcortes jcortes moved this from Doing to Ready for PR review in Component (Source and Action) Backlog May 6, 2024
@luancazarine luancazarine moved this from Ready for PR review to In Review in Component (Source and Action) Backlog May 6, 2024
@luancazarine luancazarine moved this from In Review to Ready for QA in Component (Source and Action) Backlog May 6, 2024
@vunguyenhung vunguyenhung moved this from Ready for QA to In QA in Component (Source and Action) Backlog May 7, 2024
@vunguyenhung vunguyenhung moved this from In QA to Ready for QA in Component (Source and Action) Backlog May 7, 2024
@vunguyenhung vunguyenhung moved this from Ready for QA to Ready for release in Component (Source and Action) Backlog May 7, 2024
@vunguyenhung vunguyenhung moved this from Ready for release to In QA in Component (Source and Action) Backlog May 7, 2024
@vunguyenhung vunguyenhung moved this from In QA to Ready for release in Component (Source and Action) Backlog May 7, 2024
@vunguyenhung
Copy link
Collaborator

Hi everyone, all test cases are passed! Ready for release!

Test report
https://vunguyenhung.notion.site/BUG-Snowflake-Query-Results-trigger-does-not-emit-on-prop-configuration-54f279b45c574d838e7080c1e2a9b3c3

Component (Source and Action) Backlog automation moved this from Ready for release to Done May 7, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@jcortes jcortes

Labels
bug Something isn't working triaged For maintainers: This issue has been triaged by a Pipedream employee
Projects
Component (Source and Action) Backlog
  
Done
Milestone
No milestone
Development

Successfully merging a pull request may close this issue.

[BUG] Snowflake Query Results trigger does not emit on prop configuration jcortes/pipedream
4 participants
@dylburger @jcortes @andrewjschuang @vunguyenhung