Can I use MySQL JSON in Superset? #29280
Unanswered
Erimus-Koo
asked this question in
Q&A / Help
Replies: 1 comment
-
And I found that Superset separated my data into several rows, e.g. My table has 100 rows, but in the above screenshot, there are 196 rows. |
Beta Was this translation helpful? Give feedback.
0 replies
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
-
I'm new here and often use MongoDB, but I am less familiar with SQL.
Currently, I have a key "tag" with array contents in my SQL database. In fact, I have many columns similar to "tag". I've tried using JSON in MySQL, but I don't know how it can work in Superset.
I've thought about flattening the "tag" column, but there are too many values in the array-type columns, so flattening all of them might not be a good idea. I've also considered creating another table using "tag" as the primary key and storing the user IDs, but I'm still not sure which approach would be better.
Any advice would be appreciated.
Beta Was this translation helpful? Give feedback.
All reactions