Perhaps this isn't attributable to Metabase - but I also find the error messages when I run SQL through it to be utterly incomprehensible and they do not give me any real indication of what I've done wrong. It can also be extremely slow when downloading data from Metabase into a CSV file (sometimes then failing after ages of waiting), and even re-ordering columns within Metabase. This can be so frustrating, because I occasionally need some data urgently and this really impacts my productivity. It can be so slow sometimes - quite often I have to use it late at night when fewer colleagues are also accessing it and it seems to go much faster then. It's really good and makes using SQL easy. Finally, I like that it comes up with suggestions when I'm writing SQL about data columns and tables. I also use Metabase to run SQL scripts created by colleague's as part of our employee payment process - it works really well with google sheets for this. I also like that I can then download it as a CSV with ease. A sample setup is on github for you to play, and below are the instruction to reproduce the resutls on your machine. First you can select it from the drop down list of metabase database: Then run query on the newly defined csv files based database. It's integration with SQL is just fantastic, it makes it really easy for me to run a script to find virtually any data I need from our company's performance. Basically it simply sets up a custom datasource that can you use to access and query CSV files. Metabase is an amazing tool for storing vast quantities of data. I use Metabase to run SQL scripts to find data from our large database - which is itself stored in Metabase. And secondly, for me to collect any data I require from our company database in Metabase - with an SQL script, I can find everything I want and I cannot express with words how useful that is for me every day! I believe has efforts in building a metrics and self-service analytics layer (like Looker) but is not very well integrated with the product and seems very complicated to use.Īlso some of the features have bugs, but most of the time they are fixed very quickly.Ĭomments: It has two main functions for me - converting data entered into Google Sheets by colleagues into a suitable format for us to be able to upload it as payment data via an SQL script. If you can use SQL you can use Metabase to amazing results and give your company great BI.Īs an open-source product, Metabase is also constantly evolving: each update comes with new features that are useful for us. I also like the fact that it is a SQL first tool and doesn't require any specific knowledge to use. It also offer somewhat advanced features considering its simplicity (like email and slack integrations). I love that Metabase is open source and extremely easy to implement. It is difficult for us to move away from it because its very expensive competitors offer very little comparatively. It is not the most advanced tool avaliable, but it offers amazing value as an open source product. But I guess most people (including myself) would think of 'upload csv file via UI' when it comes to csv support. ![]() there is a csv driver 1 which allows you map a csv file on the metabase server, or providing a url of the csv. It was very easy to implement and we were able to offer great analytics quickly with it. We have used some of these posts to build our list of alternatives and similar projects. Registrations = self.filter_queryset(self.get_queryset())Ĭsv_response = HttpResponse(content_type='text/csv')Ĭsv_response = 'attachment filename="some_custom_name_ th'.format(order=)Īny ideas why this is happening? I am a newb.Comments: Metabase is omnipresent in our company: everybody uses it everyday for one thing or another here. I also tried to print csv_response out, but I'm getting a very strange string =?utf-8?b?YXR0YWNobWVudDsgZmlsZW5hbWU9Iuivvueoi+aKpeWQjeaDheWGtV8yMDE5MTEyODA3NDI0Ny5jc3Yi?= ![]() I want to download a csv file with custom filename in a django project, but somehow the downloaded filename just display as "download.csv" instead of using the value of filename in Content-Disposition.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |