Name is required.
Email address is required.
Invalid email address
Answer is required.
Exceeding max length of 5KB

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

Matillion Agent  

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.

Hope this helps!
Arawan

Post Your Community Answer

To add an answer please login