Uploaded image for project: 'Apache Hop (Retired)'
  1. Apache Hop (Retired)
  2. HOP-4495

Snowflake bulk loader doesn't format dates and timestamps correctly

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 2.1.0
    • BACKLOG, Migrated to GHI
    • Transforms
    • None

    Description

      The COPY INTO command only accepts a very specific format for Dates/Timestamps.

      See: https://docs.snowflake.com/en/sql-reference/parameters.html#label-timestamp-output-format

      It would as such be better to just format the dates in the temporary files to that format (For reference: yyyy-MM-dd HH:mm:ss.SSS)

      Attachments

        Activity

          People

            Unassigned Unassigned
            mcasters Matt Casters
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: