Unable to Convert 'DATE' Column to Date Type from Snowflake Data Source

Hello,

I have a dataset connected from Snowflake called “daily,” which includes a field named “DATE” that Quicksight recognizes as a Date type. I recently added a new column to this dataset, let’s call it “Daily_2.” However, when I connect to “Daily_2,” Quicksight imports the “DATE” field as a string. I’m unable to view the data preview, and it also doesn’t allow me to change the field type to Date. Do you have any solutions for this issue?

Captura de pantalla 2024-08-14 121529

hi @Ernesto_PM

Welcome to QuickSight Community and thank you for posting a question!

the error message says timeout error. would you be able to check on Snowflake log to see what query was sent from QuickSight and to look into the details?

kind regards,
Wakana

1 Like

Hi @Ernesto_PM,
It’s been awhile since we last heard from you. Are you still encountering the same issue from your original topic or were you able to find a work around?

If we do not hear back within the next 3 business days, I’ll go ahead and close out this topic.

Thank you!

Hi @Ernesto_PM,
Since we haven’t heard back, I’ll go ahead and close out this topic. However, if you have any additional questions, feel free to create a new topic in the community and link this discussion for any relevant information that may be needed.

Thank you!