Where communities thrive


  • Join over 1.5M+ people
  • Join over 100K+ communities
  • Free without limits
  • Create your own community
People
Repo info
Activity
    eladeyal-intel
    @eladeyal-intel
    @ratulotron I don't really understand your proposed method of operation . If you want you can specify more details.
    Steven Meyer
    @RMMSecurity
    @ratulotron You can use BigQuery with Metabase, and I second using views. In fact once you create some commonly used views then you can sync the schema with metabase manually to pick those up sooner and make sure you classify which data types each field is. (Since metabase isn't great about classifying those automatically)
    Logan Attwood
    @lattwood
    PR fixed, who would I poke for review?
    Logan Attwood
    @lattwood
    @camsaul not sure about how to best align the fn args
    image.png
    Ratul Minhaz
    @ratulotron

    @eladeyal-intel I admit the solution I ended up with is a hackish solution and I personally don't like it. But this is exactly what my other peers at the DE team did with Redash, so I was suggested to do this in case no other solution was found.

    What I did is wrote a method that would take the query that we get in the back end when sent from the Native Query box, and put the query in a nested query that limits the row count.

    (defn custom-query-limit [query-map]
      (if (= (:type query-map) "native")
        (let [query (get-in query-map [:native :query])]
          (assoc-in query-map
                    [:native :query]
                    (str "select * from (" query ") as t limit 100")))
        query-map))

    this is the method I wrote.

    Pedro Carriço
    @pedrocarrico
    Hi all, is it possible to bump metabase's logging to see more details on what queries its doing?
    Jukka Hassinen
    @jhassine_twitter
    Hi, does somebody know if it’s possible to create chained filters with Metabase? By chaining I mean, choosing first filter, which sets the second filter and so on.
    Maz Ameli
    @mazameli
    @jhassine_twitter not currently possible, but being tracked in this issue: metabase/metabase#5540
    Jukka Hassinen
    @jhassine_twitter
    @mazameli thanks for the info
    Ratul Minhaz
    @ratulotron
    Hi people. I am facing a strange problem. When I try to deploy Metabase image that I built to kubernetes cluster, migrations fail and the container shuts down. I checked the DATABASECHANGELOGLOCK table and there is only one entry:
    +----+--------+---------------------+-------------------------+
    | ID | LOCKED | LOCKGRANTED | LOCKEDBY |
    +----+--------+---------------------+-------------------------+
    | 1 | 0 | NULL | NULL |
    +----+--------+---------------------+-------------------------+
    LOCKEDBY and LOCKGRANTED isn't supposed to be null, right?
    Allan Simon
    @allan-simon_gitlab
    Hello first thanks for providing metabase as opensource,
    I'm currently using it with bigquery and I've met a limitation with "RECORD" fields , as they will be displayed like this {"v":"java.lang.Object@4b6c9f0e"}]}},{"v":"Sample log text"}]}
    instead of a beautiful json-like representation
    my understanding after digging a bit in the code , is that it comes from here :
     "RECORD" (constantly identity)
    (i'm never written any clojure code, but I guess it means basically "don't do anything fancy, just cast it as string the default way" )
    Allan Simon
    @allan-simon_gitlab

    my question is : "is it something as easy as replace this line by

    "RECORD"  (constantly json/write-str)

    ? (or maybe a little bit more complicated custom function)
    if so would it make sense that I try my hands on it ?

    Allan Simon
    @allan-simon_gitlab
    maybe json/generate-string from chesire ?
    Logan Attwood
    @lattwood
    When's the next release going to be?
    epicgeek
    @epicGeek
    Hi guys, I'm doing data migration from H2 to MySQL. However the exception is duplicated entry key 'email' in table 'core_user'.How am I supposed to do ?
    Mário Filipe Pinhal
    @mfpinhal
    Hey everyone, do you know if there is any way to disable password login in metabase, any trick, any hidden config? (refs. metabase/metabase#3136)
    Tom Robinson
    @tlrobinson
    Hey everyone, we're excited to share a preview of next version of Metabase which has a more powerful graphical query builder that allows you to create joins, do post-aggregation filtering, or multiple stages of aggregating, and more. We'd love to get your feedback. More details on the here: https://metabase.com/blog/a-query-for-your-thoughts/index.html
    eshnil
    @eshnil
    @tlrobinson Congrats (and thank you!) :clap: Any progress on metabase/metabase#3846 ?
    eshnil
    @eshnil
    @tlrobinson @mazameli @camsaul I spotted a typo in a variable name: col_cound instead of col_count:
    https://github.com/metabase/metabase/blob/master/frontend/src/metabase/pulse/components/PulseEditCards.jsx#L25
    eshnil
    @eshnil

    I keep getting this error while running lein repl:

    Error encountered performing task 'repl' with profile(s): 'base,system,user,provided,dev,include-all-drivers'
    REPL server launch timed out

    Increasing the timeout in project.clj didn't help. Any ideas?

    Thomas Sesselmann
    @TomSesselmann_twitter
    Hi guys, I work for a Sydney based startup and we're looking to use Metabase as a dashboard and analytics platform for our customers. Just wanted to say thanks for the hard work you've put in developing such a great project and I hope we can contribute something back to the community as we develop some of our features 🙂
    https://pfprobotics.com
    epicgeek
    @epicGeek
    Hi , developers.My metabase sometimes crashed for OOM, how do I solve it permanently ?
    Here is the log
    com.mchange.v2.cfg.DelayedLogItem [ level -> FINE, text -> "The configuration file for resource identifier 'hocon:/reference,/application,/c3p0,/' could not be found. Skipping.", exception -> null]
    Exception in thread "MVStore background writer nio:/opt/metabase.db.mv.db" java.lang.OutOfMemoryError: GC overhead limit exceeded
    Exception in thread "Timer-1" Exception in thread "com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#1" java.lang.OutOfMemoryError: GC overhead limit exceeded
    java.lang.OutOfMemoryError: GC overhead limit exceeded
    Exception in thread "Task-Thread-for-com.mchange.v2.async.ThreadPerTaskAsynchronousRunner@2c4de012" java.lang.OutOfMemoryError: GC overhead limit exceeded
    Exception in thread "MVStore background writer nio:/opt/metabase.db.mv.db" java.lang.OutOfMemoryError: GC overhead limit exceeded
    Exception in thread "com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#2" java.lang.OutOfMemoryError: GC overhead limit exceeded
    Exception in thread "Timer-9" java.lang.OutOfMemoryError: GC overhead limit exceeded
    Exception in thread "com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#0" java.lang.OutOfMemoryError: GC overhead limit exceeded
    Exception in thread "com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#1" java.lang.OutOfMemoryError: GC overhead limit exceeded
    Exception in thread "com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#1" java.lang.OutOfMemoryError: GC overhead limit exceeded
    Exception in thread "Timer-2" Exception in thread "Timer-4" java.lang.OutOfMemoryError: GC overhead limit exceeded
    java.lang.OutOfMemoryError: GC overhead limit exceeded
    Exception in thread "MetabaseScheduler_QuartzSchedulerThread" java.lang.OutOfMemoryError: GC overhead limit exceeded
    Exception in thread "com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#2" java.lang.OutOfMemoryError: GC overhead limit exceeded
    Exception in thread "com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#1" java.lang.OutOfMemoryError: GC overhead limit exceeded
    Exception in thread "com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#2" java.lang.OutOfMemoryError: GC overhead limit exceeded
    Exception in thread "Timer-21" java.lang.OutOfMemoryError: GC overhead limit exceeded
    Exception in thread "Timer-7" java.lang.OutOfMemoryError: GC overhead limit exceeded
    Exception in thread "Timer-3" Exception in thread "Timer-6" java.lang.OutOfMemoryError: Java heap space
    java.lang.OutOfMemoryError: Java heap space
    Exception in thread "Task-Thread-for-com.mchange.v2.async.ThreadPerTaskAsynchronousRunner@74a3158a" Exception in thread "Task-Thread-for-com.mchange.v2.async.ThreadPerTaskAsynchronousRunner@5b985af8" Exception in thread "Task-Thread-for-com.mchange.v2.async.ThreadPerTaskAsynchronousRunner@1ed54612" java.lang.OutOfMemoryError: Java heap space
    Exception in thread "com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#2" java.lang.OutOfMemoryError: Java heap space
    java.lang.OutOfMemoryError: Java heap space
    java.lang.OutOfMemoryError: Java heap space
    Exception in thread "com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#0" java.lang.OutOfMemoryError: Java heap space
    Theo Bohnen
    @tbohnen
    Hey Guys, just wanted to check if we can make metabase_files a private channel, if not, is there a specific reason not to and would you be open to me creating a PR?
    Jukka Hassinen
    @jhassine_twitter
    How have people handled to printing to PDF of dashboards? It’s possible to use to browsers export to PDF but the widgets are not optimal size and the page breaks. I assume those would not be too hard to fix in the code but are there some valid solutions/workarounds already?
    eshnil
    @eshnil

    Hey everyone, we've added a few enhancements to how Pulses work in Metabase for our customers:

    • Allow more than 20 rows and 10 columns in pulses (customize via environment variables)
    • CronExpression-based flexible pulse scheduling (as frequent as every 5 minutes)
    • Allow hourly email pulses

    If your org would be interested in these, please write to team@polyglot.network :pray:

    Nilesh
    @nileshtrivedi

    Anyone else getting this error in latest master?

    ERROR pulse.render :: Pulse card render error
    clojure.lang.ExceptionInfo: Output of renderable-interval__34337 does not match schema: 
    
           {:interval-start missing-required-key, :interval missing-required-key, :this-interval-name missing-required-key, :last-interval-name missing-required-key, :ns-str disallowed-key, :msg disallowed-key, :args disallowed-key}  
    
     {:type :schema.core/error, :schema {:interval-start org.joda.time.DateMidnight, :interval org.joda.time.base.BaseSingleFieldPeriod, :this-interval-name metabase.util.i18n.UserLocalizedString, :last-interval-name metabase.util.i18n.UserLocalizedString}, :value "Last month", :error {:interval-start missing-required-key, :interval missing-required-key, :this-interval-name missing-required-key, :last-interval-name missing-required-key, :ns-str disallowed-key, :msg disallowed-key, :args disallowed-key}}
        at metabase.pulse.render.datetime$eval34338$renderable_interval__34337__34348.invoke(datetime.clj:74)

    I filed a bug report for this: metabase/metabase#10326

    Nilesh
    @nileshtrivedi
    Anyone looking into this ^ at all? master branch is seriously broken.
    Tom Robinson
    @tlrobinson
    @nileshtrivedi yes i think @camsaul is looking into it
    Nilesh
    @nileshtrivedi
    Fixed in master. Thanks @camsaul :pray:
    Cameron Barre
    @cjbarre

    Hi everyone!

    I'm working on #3368 (DynamoDB Driver) and I've made it to the describe-table extension. Dynamo is schema-less and it looks like the DescribeTable API method will only return the primary key attribute and the sort key attribute (if there is one). I took a look at the Mongo driver and it seems to sample the data in the target "table" to estimate which fields are in play to populate the TableMetadataField(s).

    I know there are other schema-less databases with metabase support, does the core team have any conventions for this situation?

    Another point to consider is how often describe-table is called by metabase (I'm not familiar enough yet to know), but in this case frequent sampling could rack up unintended costs (reads) for the user, and then determining how much data to sample on a potentially unlimited amount of data is another concern, if that approach is the one to take.

    Any guidance here?

    Thanks :smiley:

    Félix C. Morency
    @fmorency

    Hey there. I'm testing preview2 with some CSV files I imported in MongoDB and can't seem to be able to perform join operation. Is this intended behavior (some DB suports it and some don't)?

    I have two tables with the same ID in both.

    Félix C. Morency
    @fmorency

    We are currently evaluating Metabase to use at our company. I already wrote to your support about some advanced stats (ANOVA, T-Test, Tukey, etc) and Victoria encouraged me to log issues in the GH tracker.

    I would love to start discussing such feature and potential contribution.

    Philip Durbin
    @pdurbin
    You already created some issues? I'm not a Metabase developer. I'm just curious. I just looked and didn't see anything about advanced stats. :)
    Félix C. Morency
    @fmorency
    Not yet. We are currently preparing toy datasets, case and corresponding results.
    Tom Robinson
    @tlrobinson
    @fmorency Unfortunately we only currently support joins for SQL databases
    @camsaul can you take a look at @cjbarre's question
    Félix C. Morency
    @fmorency
    @tlrobinson That's what I thought. Thanks a lot.
    Helder Rossa
    @kimus
    hi, after upgrading to 0.33 some of my queries (answers) stopped working and return no results. After investigating (converting no native). The converted query has a error:
    [
      {
        "$project": {
          "orderdate~~~month": {
            "$let": {
              "vars": { "column": "$orderdate" },
              "in": {
                "___date": {
                  "$dateToString": { "format": "%Y-%m", "date": "$$column" }
                }
              }
            }
          },
          "orderdate~~~year": {
            "$let": {
              "vars": { "column": "$orderdate" },
              "in": {
                "___date": {
                  "$dateToString": { "format": "%Y", "date": "$$column" }
                }
              }
            }
          }
        }
      },
      { "$match": { "orderdate~~~year": { "$eq": { "___date": "2019-01-01" } } } },
    
    ... other stuff removed ...

    the $match shoud be:

    { "$match": { "orderdate~~~year": { "$eq": { "___date": "2019" } } } },

    there's a miss match between format and filter.