Best answer

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

  • 31 August 2023
  • 5 replies
  • 128 views

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 

 

icon

Best answer by agileops 31 August 2023, 16:00

View original

5 replies

Userlevel 7
Badge +6

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! 😊

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

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

 

 

Userlevel 1
Badge +1

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,

Userlevel 7
Badge +14

@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.

 

Reply