Hey folks, my team and I are trying out GoodData i...
# gd-beginners
a
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
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
Hey @Ivana Gasparekova the dates are timestamps in ms
i
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.