Hello, I would like to import the zipped and unzipped files I use data transfer but it does not take the variables my database is BigQuery

Matillion ETL
5

Hi @tatus_parker​

Were you able to resolve this?

@Bryan​ hi! I am working with Matillion 1.50 for Snowflake and having a similar issue than Tatus.

It seems that the Data Transfer component do not allow variables; I've tried several ways of sending the variable (File Iterator, Grid Iterator, Table Iterator) with the same result:

  1. I click the three dots to get into the Source URL config, browse to my bucket and folder and insert the variable there, then click OK
  2. The variable gets dropped, when you see the config in the properties panel
  3. When I run it, I can see the variable correct in the iteration, but I get an error on the Data Transfer component; as it doesn't point to the file, because it doesn't seem to be using the variable.

I tried to implement the logic in this post https://matillioncommunity.discourse.group/t/is-it-possible-to-transfer-files-using-a-file-pattern-in-data-transfer-component-or-any-other-component/1167

But I'm thinking there is a bug with this Matillion version on Snowflake

@Bryan​ have you got it working on your side with your Matillion on Snowflake? and if so, which version are you on?

0694G00000Eu6sdQAB_0D74G000007j72CSAQ
0694G00000Eu6sdQAB_0D74G000007j72CSAQ979×555 111 KB