Migrate Snowflake example DAGs to new design

[potiuk]

There is a new design of system tests that was introduced by the AIP-47.

All current example dags need to be migrated and converted into system tests, so they can be run in the CI process automatically before releases.

This is an aggregated issue for all example DAGs related to Snowflake provider. It is created to track progress of their migration.

List of paths to example DAGs:

• airflow/providers/snowflake/example_dags/example_snowflake.py

[joppevos]

@potiuk I would like to give it a try. You can assign me.

[potiuk]

cool! example to base it on are in #22311