GitHub user set92 added a comment to the discussion: Snowflake provider (SnowflakeSqlApiOperator) - Not exposing query results with multiple queries
In general, I would like to have a better integration between Snowflake <-> Airflow. Most of all for debugging purposes. For example, in Snowflake you can't see the query results of queries that are not your own. So, it would be nice to have it in Airflow. I feel the UX for that would be a plugin that can connects to Snowsight, or have a panel like [Astro showed for their guides in 3.1](https://www.astronomer.io/blog/introducing-apache-airflow-3-1/). But I'm not going to daydream with it, and since I don't want to use >AF3, I was thinking I could get the query ids to at least do some counts on them, having at the end of all atomic blocks some `select $variables` outputting how many rows I have modified on the DML queries. >From my POV, those queries ids should be available as a parameter for anyone >to use them as they like. Having them in the XCOM? I suppose it makes sense >since right now is outputting the parent_id, but with it, you would need to >call to Snowflake again to know the childs IDs, so I'm trying to avoid this >query. GitHub link: https://github.com/apache/airflow/discussions/58689#discussioncomment-15078891 ---- This is an automatically sent email for [email protected]. To unsubscribe, please send an email to: [email protected]
