Druid integration

Hi! I'm trying to connect to druid but there is no data in metabase.
The connection to druid broker in a setup stage was successful and I know that my druid has 1 table but I can't see this data in metabase.

Thanks for answer in advance!

Hi @Palamariuk
Read this: https://www.metabase.com/docs/latest/troubleshooting-guide/sync-fingerprint-scan.html
Post "Diagnostic Info" from Admin > Troubleshooting
And post logs during sync from Admin > Troubleshooting > Logs

Thanks. I've solved my problem in admin panel (it just needed to resync database).
But I faced with other problem: when I write a native query to create filterable dashboard based on druid dataset, there is an error:

Unrecognized token 'select': was expecting (JSON String, Number, Array, Object or token 'null', 'true' or 'false') at [Source: (StringReader); line: 1, column: 7]

I notice that other people had the same error but I don't find any answer how to fix this.
Is there any other way to create charts that can be filtered?

@Palamariuk Metabase only support Native query, not SQL on Druid. Use GUI to create a question and then you can view the "SQL" for the question:
https://www.metabase.com/docs/latest/users-guide/custom-questions.html#viewing-the-sql-that-powers-your-question

I turned my question into a query, but got a druid native query that looks like this:

{"intervals":["1900-01-01/2100-01-01"],"granularity":"all","context":{"timeout":60000,"queryId":"52bf1e98-6e73-4e11-bd74-3f60316f0a43"},"queryType":"scan","limit":1048576,"dataSource":"player_statistics_aggregated","filter":{"type":"selector","dimension":"player_id","value":34600},"columns":["games","duels","own_goals","passes_accuracy_avg","shots","passes","played_minutes","player_id","shots_on_goal","key_passes","won_duels_percentage","rating_avg","__time"]}

Now I have no clue how to insert any variable in this query.

@Palamariuk Variables are currently not supported on Druid:
https://github.com/metabase/metabase/issues/9184 - upvote by clicking :+1: on the first post