Hey folks, my team and I are trying out GoodData in a hackathon and we managed to connect to our demo snowflake warehouse, however I cannot figure out how to specify the date columns - the dates themselves are ms timestamps, and when I try to declare a date in the Data Map I cannot select the actual date column as the source column. Any tips?
i
Ivana Gasparekova
05/09/2024, 9:04 AM
Hey Amanda,
That is really cool, good luck at the hackathon!
Could you confirm that you are working with one of the supported Data Types , please?
Some general info about the Date/Time datasets can be found here.
a
Amanda Pogue
05/09/2024, 4:57 PM
Hey @Ivana Gasparekova the dates are timestamps in ms
i
Ivana Gasparekova
05/13/2024, 10:32 PM
Thank you for the confirmation. I was wondering how did you map this column in your logical data model.
In Snowflake, the data type can be defined as:
TIMESTAMP
TIMESTAMP_LTZ
TIMESTAMP_NTZ
TIMESTAMP_TZ
In GoodData, it should be converted to DATE data type. More details can be found here.