How do I use variables to populate the filename to Snowflake table when loading files?

[wayne.richard]

When I try to use the Azure BLOB Storage Load component to update a Snowflake table with a Grid variable. I get the following error:

SQL compilation error: error line 1 at position 67

invalid identifier '""'

 

The error appears to be caused by the field list being blank. Here is the SQL that is failing:

Here is a snapshot of my configuration for the component as well as how I am assigning the grid variable:

Any assistance would be greatly appreciated. Thanks!

[AnudeepK]

You can use a select query for the copy command , which includes File metadata columns (metadata$filename etc) in your select command.