jacobcbeaudin commented on issue #73658: URL: https://github.com/apache/airflow/issues/73658#issuecomment-5818588446
Verified #63470 (`SnowflakeNotebookOperator`) against the PyPI-installed `apache-airflow-providers-snowflake==6.18.0rc1` with Airflow 3.1.8 and Python 3.11 (Astro Runtime 3.1-15, LocalExecutor), against a live Snowflake account with key-pair auth. Nothing was mocked. - `deferrable=False`: `EXECUTE NOTEBOOK` submitted through the SQL API, polled to completion, task succeeded. - `deferrable=True`: task deferred, the trigger polled to completion, task resumed and succeeded. - `notebook_parameters`: two templated string parameters reached the notebook in `sys.argv` (the notebook wrote them to a table, and I checked the rows). - Failure: a notebook that raises makes the task fail in both modes, with the notebook's error message in the task log. - Templated `notebook` and `snowflake_conn_id` rendered correctly. Works as expected ✅ Doc note for a possible follow-up (not a blocker): inside a Snowflake Notebook, `sys.argv[0]` is the first parameter (there is no script name), and with no parameters `sys.argv == ['']`. --- Drafted-by: Claude Code (Opus 5.5); reviewed by @jacobcbeaudin before posting -- 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]
