superset icon indicating copy to clipboard operation
superset copied to clipboard

Unable to set a dataset column's datetime format

Open prb219 opened this issue 1 year ago • 1 comments

Bug description

Superset version in use: 2.1.0

We are trying to mark a temporal column in a dataset as 'epoch_s'. However, when we select edit dataset > columns we don't really see a drop down option next to the column name to make this change. Can someone please look into it ? Do we need some permissions to be able to see this option ?

Current behavior:

  • No drop down menu seen next to the column name

Screenshot 2024-02-08 at 3 48 13 PM

How to reproduce the bug

  1. Go to any dataset
  2. Select edit dataset > columns

Screenshots/recordings

No response

Superset version

master / latest-dev

Python version

3.9

Node version

16

Browser

Firefox

Additional context

No response

Checklist

  • [X] I have searched Superset docs and Slack and didn't find a solution to my problem.
  • [X] I have searched the GitHub issue tracker and didn't find a similar bug report.
  • [X] I have checked Superset's logs for errors and if I found a relevant Python stacktrace, I included it here as text in the "additional context" section.

prb219 avatar Feb 08 '24 23:02 prb219

Just confirming... your description says you're running master/latest and it also says 2.1.0. Which is the case? This doesn't seem to be a problem in 3.x, and we no longer support 2.x, so I'm tempted to close this.

rusackas avatar Feb 09 '24 19:02 rusackas

@rusackas We are using 2.1.0 version. Would really appreciate if you could guide on this issue as it is blocking us.

prb219 avatar Feb 15 '24 00:02 prb219

You should indeed be able to toggle the little disclosure triangle to see the form to edit things like label which I believe is what you're after. image

Then it'll show up in controls as such. image

If you don't see that, you might have a permissions issue. Your role might not have the "Can Edit Dataset" permission, or something along those lines.

rusackas avatar Feb 15 '24 02:02 rusackas

Closing this as 2.x versions are not supported anymore. Feel free to continue the conversation in case @rusackas's suggestion does not resolve your problem. I hope it does 🤞🏼

michael-s-molina avatar Feb 15 '24 16:02 michael-s-molina

Hi @rusackas Thank you for your response. I am not seeing the disclosure triangle as you correctly mentioned and I think it is a permission issue too. I have the following permissions enabled for this admin user which is all the options i see for Dataset in https://github.com/apache/superset/blob/master/RESOURCES/STANDARD_ROLES.md

Permissions currently assigned: can read on Dataset can write on Dataset menu access on Datasets can export on Dataset can duplicate on Dataset can get or create dataset on Dataset

prb219 avatar Feb 15 '24 18:02 prb219

Are you still running Superset 2.x?

rusackas avatar Feb 15 '24 18:02 rusackas

Yes, running 2.1.0. Strangely I remember this option was available when we first on boarded to 2.1.0 as we had to create some new datasets which takes time column in epoch.

prb219 avatar Feb 15 '24 18:02 prb219

@rusackas Any suggestions here ? It would be very helpful If I could get some guidance on the permission that affects this particular functionality.

prb219 avatar Feb 16 '24 20:02 prb219

Not really sure... I'm curious if this is still an issue in 3.0/3.1, but if it IS a permissions issue, it probably will be.

rusackas avatar Feb 21 '24 20:02 rusackas