Azure load component - metadata fields into stage table
How can the metadata fields that are selected in the Azure load component be inserted into the table? I have searched the knowledge Base and on the snowflake documentation and haven’t found a solution.
1 Community Answers
Arawan Gajajiva —
Hi Jacob -
The key to using the metadata fields in the Azure Blob Storage Load component is to specify a Snowflake Stage when using this component. You will notice a property called “Stage”, which by default is [Custom]. This default behavior loads the data from the Blob Storage Location directly into Snowflake. If you have created any Snowflake stages in your Snowflake datawarehouse, you will be able to choose one from the dropdown for that “Stage” property. You need to use a Snowflake managed stage because that Metadata information is only available when loading data from a Snowflake managed stage, as noted here.