Filter for datetime value returns "Cannot compile Column object until its 'name' is assigned."

[stephanclaus]

A clear and concise description of what the bug is.

How to reproduce the bug

1. Build a chart on a data set that contains a datetime column
2. Add this chart to a dashboard
3. add a dashboard filter on the datetime column
4. apply the filter
5. See error

Expected results

the chart is filtered by the value

Actual results

An error is raised:

Cannot compile Column object until its 'name' is assigned.

This may be triggered by:
Issue 1011 - Superset encountered an unexpected error.

Screenshots

Environment

(please complete the following information):

• Chrome Version 108.0.5359.124 (Official Build) (x86_64)
• superset version: 2.0.0
• connecting to snowflake database

Checklist

Make sure to follow these steps before submitting your issue - thank you!

• I have checked the superset logs for python stacktraces and included it here as text if there are any.
• I have reproduced the issue with at least the latest released version of superset.
• I have checked the issue tracker for the same issue and I haven't found one similar.

Additional context

Superset 2.0.0 and snowflake/sqlalchemy seems to have more problems with date time handling. The same approach is working fine if the filter column is a date field.

[michael-s-molina]

@geido @kgabryje This may be related to the bug we were investigating with drill to detail and Snowflake.

[zhaoyongjie]

Hi @stephanclaus, I can't reproduce this issue when I use orders table of the TPCH in the Snowflakes. Could you add more details for our reproduce it?

Test environment:

• Latest master branch
• orders table of TPCH
• Snowflakes
• Add time range filter in the Native filter
• Right-click on the Chart to select a column to drill detail

[stephanclaus]

Hi, so the column you are using the the order_date column? Is this a datetime data type actually?

[zhaoyongjie]

yes, it does. o_orderdate is a DateTime column in standard TPCH.

[stephanclaus]

okay, so it is in the standard TPCH, but not in Snowflake:

So I think your test case is invalid.

[villebro]

Closed by #22872