I’m planning to fetch the data from a table using “Snowflake select snap” while putting the condition of getting 1k records ONLY in WHERE clause however it is not getting any results.
I can put the entire query in “Snowflake execute snap” as well but wanting to do with Snowflake Select as of now. Any help is highly appreciable.
Thanks!
@rmedeiros Looks like it’s syntax issue (count not found). In your error pipeline you don’t need to explicitly map each and every attribute. Rather have one open/unlinked input view mapper and use pass through option. Just add one/two fields in mapper (name of error pipeline name/ execution time etc.) and use the pass through.
If you don’t want to change your logic then select null safe option in your mapper in error pipeline.
I’ll do it. Thanks!
Well, i tried turning on the Null Safe and Pass Through options. But some pipelines kept throwing this error on the Error Pipeline. Despite throwing this error, the error pipeline is kind of working, it saves an error log and creates a ticket, as intended, but the error log is an empty JSON, with only the empty brackets. Seems like no error info is being sent to the error pipeline.
@rmedeiros Is it possible to share your error pipeline ? you can remove your endpoint details before sharing.
