Improve snowflake_stages (Data Source) to detect external/internal stages

[TerjeRusska]

Is your feature request related to a problem? Please describe.
Previous issue that relates to the request: #772

It is not possible combine snowflake_stage_grant (Resource) with snowflake_stages (Data Source) by looping through the resources since USAGE only applies to external stages, READ | WRITE only applies to internal stages.

https://docs.snowflake.com/en/sql-reference/sql/grant-privilege#usage-notes

Describe the solution you'd like

Add the following attributes to the nested schema for stages in snowflake_stages (Data Source):

• type

show stages in account;

Describe alternatives you've considered

Currently have to manually split the stages

Additional context

[sfc-gh-swinkler]

Yes this makes sense, and I agree we should do this. Could you please file a support ticket with your Snowflake account representative on this issue? It helps a lot in getting prioritization for this.