I have exactly same behavior: it doesn't work in notebook (no error message, the success message instead), it does work in sql editor.

Apparently streaming tables work only with serverless warehouses.