Skip to main content
Answer

Slack Messages appearing as blank when I'm running it on an hourly basis but appears when I'm testing

  • August 31, 2023
  • 5 replies
  • 335 views

pandemic_p

Hi there, 

 

I’m looking to have automated messaging on Slack from some of our data tables. The message appears when I’m testing the data, but when I run it automatically on an hourly basis, the message appears as blank. 

 

Here is my slack automation 

 

Best answer by agileops

Hi @pandemic_p ,

It seems like when data isn’t coming out from Snowflake, Slack message will be blank. 

Do you know why data isn’t coming out from Snowflake?

Cheers,

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

5 replies

ken.a
Forum|alt.badge.img+6
  • Zapier Staff
  • August 31, 2023

Hi there @pandemic_p,

Welcome to the Community! 🎉

Before we dive deeper, could you please send a screenshot of the Zap run that shows the “DATA IN” and “DATA OUT” section of the Zap run in your Zap history?

Please don't include personal information in the screenshot, or be sure blur out any personal information.

Thanks! 😊


pandemic_p
  • Author
  • Beginner
  • August 31, 2023

Do you mean showing the details in the snowflake or text in formatter? I can’t send the SQL without including personal info


pandemic_p
  • Author
  • Beginner
  • August 31, 2023

This is where the data isn’t coming out from (Snowflake) 

 

 


agileops
Forum|alt.badge.img+1
  • Zapier Solution Partner
  • Answer
  • August 31, 2023

Hi @pandemic_p ,

It seems like when data isn’t coming out from Snowflake, Slack message will be blank. 

Do you know why data isn’t coming out from Snowflake?

Cheers,


Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • August 31, 2023

@pandemic_p 

If there is no rows returned from Snowflake, you may want to add a Filter step to prevent the Slack Channel Message from being sent.