Query metadata of external tables

[RalfKow]

Describe the feature

There would be metadata columns added to the external table

Describe alternatives you've considered

Not using external tables and creating a table.

Additional context

I would love to use dbt external table but I need the file name because it contains valuable information that I need further down the pipelin

Who will this benefit?

Every use case that needs metadata

[dataders]

which data platform are you using?

[RalfKow]

I'm using Snowflake with external stages on Azure blobstorage

[srjefers]

If that is possible, I would like to be able to query metadata comming from the stage, METADATA$FILENAME or MEDATADATA$FILE_ROW_NUMBER, also is there a way that we can use custom column or that we can set a hardcoded value into the column? I mean something such like the current_date().