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().

[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.