Documentation request: Add Docs for Snowpipe

[ernestoongaro]

There's great Snowpipe support but seems to only exist for anyone that can read the source code https://github.com/dbt-labs/dbt-external-tables/tree/0.8.7/macros/plugins/snowflake/snowpipe

[github-actions]

This issue has been marked as Stale because it has been open for 180 days with no activity. If you would like the issue to remain open, please comment on the issue or else it will be closed in 7 days.