set92 commented on issue #58619: URL: https://github.com/apache/airflow/issues/58619#issuecomment-3572252152
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. -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
