Meltano

Hello, please I would like to print the data I retrieved from SnowFlake to the Console, I wouldn't want to just dump it to as csv

Thanks, but please is there anyway I can retrieve only the content of the database let say the email and use it to sent a mail notification? I would want to use the retrieved mail from the snowflake database to send an email notification. Thank You

<@U06CBH319H9> check out <https://hub.meltano.com/loaders/target-apprise|https://hub.meltano.com/loaders/target-apprise>. You can extract your snowflake data and send notifications using apprise. I use it to send a slack notification per row in snowflake but it has a ton of notification options

Hello <@U06D0TMQ2U8> I have tried to pass the email I retrieved from the snowflake to a python email package but couldn't seem to get it working. Please any help?

Hey - what’s exactly have you tried so far?

I only tried to retrieve the data (emails) from snowflake, but I am finding it difficult to use the email. I am new to meltano

I rand this
*meltano --environment=test invoke tap-snowflake*

I'm trying to implement isolated testing with meltano

You should look into target apprise that I linked above. Then running “meltano run tap-snowflake target-apprise” you might be able to easily create a notification per record you’re seeing in your console

Otherwise you can write those emails to a CSV or something like that and write a custom script to send the notifications but apprise should simplify that for you!