Question: Does anyone has the syntax to read the csv data from IICS to Snowflake.

Error:
TT\_11019 There is an error in the port [Record\_Date]: The default value for the port is set to: ERROR(Transformation error: IUpdateStrategyNode4).

csv Data: 3/16/2021 12:42:00 PM
3/16/2021 11:27:00 PM

snowflake format: RECORD\_DATE TIMESTAMP\_NTZ(9)

I tried these format but none of them works for me:

to\_date(Record\_Date,'MM/DD/YYYY HH:MI:SS AM')
to\_date(Record\_Date,'MM/DD/YYYY HH:MI:SS')
to\_date(Record\_Date,'MM/DD/YYYY HH12:MI:SS')
to\_date(Record\_Date,'MM/DD/YYYY HH12:MI:SS AM')
TO\_DATE(REG\_REPLACE(Record\_Date, '( AM| PM)', ''), 'MM/DD/YYYY HH24:MI:SS')
TO\_DATE(TO\_CHAR(TO\_DATE(REG\_REPLACE(Record\_Date, '( AM| PM)', '')), 'MM/DD/YYYY HH24:MI:SS'))

to\_date(Record\_Date,'MM/DD/YYYY HH24:MI:SS')

thank you in advance.

Answer: 
[It's](https://webpack.js.org/plugins/terser-webpack-plugin/) fix my problem

> 
> If you are using webpack v5 or above you do not need to install this plugin. Webpack v5 comes with the latest terser-webpack-plugin out of the box. Using Webpack v4, you have to install terser-webpack-plugin v4.
> 
> 
>
I had similar problem and solved it. May be you have overlapping while build up project. To solve this I've changed length of hash subsitution in file names in my Webpack config file. I had

```js
output: {
  filename: 'assets/[name]_[contenthash:5].js'
}

```

where `contenthash` was 5 length. It's not enough! I had been suggested to change to 8 symbols of hash length

```js
output: {
  filename: 'assets/[name]_[contenthash:8].js'
}

```

and this solved my problem.

Discussion with Webpack community about it: <https://github.com/webpack/webpack/discussions/16513>

About Webpack output config param and subsitutions: <https://webpack.js.org/configuration/output/#outputfilename>