Does Matillion have regional date settings?

Matillion ETL
1

We are based in OZ and pulling data from an API like so:

 

12/04/2022 7:58:10 AM

 

When Matillion pumps this into an undefined Snowflake table it assigns the Timestamp datatype and gives it a value thusly:

 

2022-12-04 07:58:10.000

 

This would be correct for US based dates but Down Under we use DD/MM/YYYY which should be 2022-04-12 07:58:10.000.

 

Is there a regional setting in Matillion we should look at or (this just occurred to me) is it a problem in Snowflake?

 

Thanks!

2

I also noticed that if the dates are in OZ format then Matillion will assign the field a varchar datatype. So there is definitely some setting we need to let Matillion know we are using Australian date format.

3

Any suggestions? Is the regional setting of the Matillion server instance what is used to determine date formats?

In this case it would be cool if we could control the regional settings at the project level or something like that... since I have no access to the server in this case.