akalitenya

4 ms·

1.
by akalitenya 8y ago
Bigquery exists only in Google Cloud. This is a columnar database like Redshift. It is not designed for fast processing small queries that are necessary to support the operation of any application. Its main feature is that it can scale the
2.
by akalitenya 8y ago
Mprove does it the way the Looker did it before: CREATE TEMPORARY FUNCTION mprove_array_sum(ar ARRAY<STRING>) AS ((SELECT SUM(CAST(REGEXP_EXTRACT(val, '\\|\\|(\\-?\\d+(?:.\\d+)?)$') AS FLOAT64)) FROM UNNEST(ar) as val
3.
by akalitenya 8y ago
@segah Good point. Based on your consulting experience, can you tell if there have been any cases when your clients chose another Business Intelligence tool instead of Looker, what are these tools and what are the reasons?
4.
by akalitenya 8y ago
LookML supports different databases as sources. Sometimes Looker adds its own LookML parameters for database - which makes it difficult to read the documentation. For analysts who work with SQL queries, any wrapper on a language seems compl
5.
by akalitenya 8y ago
Thank you, I plan to add more videos on the page.
6.
by akalitenya 8y ago
Thank you, I sent you an email. I am open to any suggestions - akalitenya@mprove.io.
7.
by akalitenya 8y ago
The MySQL image specified in the docker-compose file you mentioned. It is used for the internal data of the Mprove application (users, projects, members, etc.). Each user action in the web client (angular) can initiate several queries to th
8.
by akalitenya 8y ago
Yes, look at this page - https://mprove.io/docs/blockml/fields/measure . You need to specify measure "type" and "sql_key" that will be used to avoid counting duplicates.
9.
by akalitenya 8y ago
Mprove creates permanent derived tables in BigQuery if the user wants it. But you can't use BigQuery for OLTP.
10.
by akalitenya 8y ago
Source code is open. Anyone can deploy Mprove to his server and use it for free.
11.
by akalitenya 8y ago
Yes it should, there is special "unnest" parameter for fields in BlockML reference - https://mprove.io/docs/blockml/fields/dimension
12.
by akalitenya 8y ago
> Some of the Old LookML syntax is an exact copy. I met the online Looker demo a few years ago when I was looking for a business intelligence tool for another project. Looker has a closed source code, so I did not see what algorithm is u
13.
by akalitenya 8y ago
thanks, i just fixed it
14.
Show HN: Open-Source Business Intelligence for BigQuery – Looker Alternative(mprove.io)
95 points by akalitenya 8y ago|44 comments
15.
by akalitenya 10y ago
do you plan to opensource all of Stitch integrations?