Snowflake stages and file formats with fully qualified names fail to validate

Matillion ETL
1

Since v1.47, METL should support fully qualified names for stages and file formats, so that they don’t have to reside in the target database. However, I can’t seem to get these to work. Regardless of whether I use database.schema.stage or some variation with double quotes, my component (an Azure Blob Storage Load component in this case) throws an error: Parameter Validation Failure: Stage - Unrecognised options.

Interestingly, looking at the queries sent to Snowflake, if I leave out the double quotes, Matillion seems to be enclosing the database name and schema name in quotes by itself, and then requesting the stages in the stated schema. That query actually succeeds on the Snowflake side… but Matillion still errors out. Any tips?

2

Hi @wieman

Thanks for your post, and welcome to the Matillion Community. I have taken away the information you have shared and will speak with our team about it.

Once I have an update, I will share back here with you.

Kind regards, Joe

3

Hi @wieman

I hope you had a nice weekend, the team have been looking into this and have been unable to replicate it at our end, if you could kindly raise a support case, the team will be able to take a closer look and help you resolve this.

You can do this here.

If you need anything else, please feel free to let me know.

Kind regards, Joe