Implemented

Allow fetching TIMESTAMP_NTZ data type from Snowflake Connection.

Votes
Sashank Goparaju
Rank
Userlevel 2
Badge +2

Hi Team,

As per current product setup and support article: https://support.gainsight.com/Gainsight_NXT/Connectors_(Horizon_Experience)/Sightline_Integrations/DB_Based_Connectors/Snowflake_Connector, Gainsight does not support fetching TIMESTAMP_NTZ data type from Snowflake (Attached screenshot from support article).

 

We have a use case where we are looking to import a field from Snowflake with the Datatype of Timestamp_NTZ. Can we please consider this? Also, please let us know if we have any workarounds until this gets implemented

1 Attachment

6 replies

benwanlessmenlo
Rank
Userlevel 2
Badge +1

It looks like in Connectors 2.0 I was able to fetch a datatype Timestamp_NTZ field and load it to a Gainsight date-time field on an object.

Perhaps the help article just needs to be updated?

 

Best,

Ben Wanless

Sashank Goparaju
Rank
Userlevel 2
Badge +2

Hi @benwanlessmenlo, Thanks for the reply.

I will check with my internal teams and get back to you with an update on the Doc update.

Appreciate your patience.

Thanks
Sashank.

Sashank Goparaju
Rank
Userlevel 2
Badge +2

Hi @benwanlessmenlo,

Appreciate your patience here.

 

We have an update from our internal teams. We now support NTZ timestamp in Snowflake and also the documentation is updated. We removed the note that was previously mentioned saying that we don’t support the datatype Timestamp_NTZ fields. 

Please see the image attached and review the updated article. (If you aren’t seeing the update made on the article, please remove the browser cache and then access the article again)

https://support.gainsight.com/Gainsight_NXT/Connectors_(Horizon_Experience)/Sightline_Integrations/DB_Based_Connectors/Snowflake_Connector#Overview

Thanks and Regards,
Sashank Goparaju.

1 Attachment
benwanlessmenlo
Rank
Userlevel 2
Badge +1

Thank you @Sashank Goparaju !

Ritesh Sharma
Rank
Userlevel 3

We have updated the document now. TIMESTAMP_NTZ datatype can now be fetched in Snowflake connector

anirbandutta
Userlevel 6

Fab job guys, thanks for closing the loop here!

It's an opportunity for engagement

Reply


Terms & ConditionsCookie settings