Apache Calcite VS Looker

Apache Calcite Reviews

Looker Reviews

Apache Calcite mentions (12)

• Data diffs: Algorithms for explaining what changed in a dataset (2022)

  > Make diff work on more than just SQLite. Another way of doing this that I've been wanting to do for a while is to implement the DIFF operator in Apache Calcite[0]. Using Calcite, DIFF could be implemented as rewrite rules to generate the appropriate SQL to be directly executed against the database or the DIFF operator can be implemented outside of the database (which the original paper shows is more efficient).... - Source: Hacker News / 9 months ago

• How to manipulate SQL string programmatically?

  Use a SQL Parser like sqlglot or Apache Calcite to compile user's query into an AST. Source: about 1 year ago

• Parsing SQL

  One parser I think deserves a mention is the one from Apache Calcite[0]. Calcite does more than parsing, there are a number of users who pick up Calcite just for the parser. While the default parser attempts to adhere strictly to the SQL standard, of interest is also the Babel parser, which aims to be as permissive as possible in accepting different dialects of SQL. Disclaimer: I am on the PMC of Apache Calcite,... - Source: Hacker News / over 1 year ago

• Semantic Diff for SQL

  Apache Calcite can do this, though it's not a beginner-friendly task: https://calcite.apache.org/. - Source: Hacker News / almost 2 years ago

• OctoSQL allows you to join data from different sources using SQL

  You should look at Apache Calcite[0]. Like OctoSQL, you can join data from different data sources. It's also relatively easy to add your own data sources ("adapters" in Calcite lingo) and rules to efficiently query those sources. Calcite already has adapters that do things like read from HTML tables over HTTP, files on your file system, running processes, etc. This is in addition to connecting to a bunch of... - Source: Hacker News / almost 2 years ago

Looker mentions (14)

• edit home page to add folder section

  Then in the "foldername" you can have 5 folders, each one for each of the groups. This means that when group1 enters looker.com, his default page will be the "foldername", which contains group1folder (he cannot see the rest of the folders if you have set the permissions correctly for each folder). Source: about 1 year ago

• Stars, tables, and activities: How do we model the real world?

  Even if you want to make Wide Tables, combining fact and dimensions is often the easiest way to create them, so why not make them available? Looker, for example, is well suited to dimensional models because it takes care of the joins that can make Kimball warehouses hard to navigate for business users. - Source: dev.to / over 1 year ago

• dbt for Data Quality Testing & Alerting at FINN

  We take daily snapshots of test results, aggregate them, and send Looker dashboards to the appropriate teams. - Source: dev.to / about 2 years ago

• I'm a dev ID 10 T please help me

  Dashboard: I like to use Datastudio because it's easy (just like using google sheets), but you can also try out Looker. Source: over 2 years ago

• The Data Stack Journey: Lessons from Architecting Stacks at Heroku and Mattermost

  For Growth and larger, I would recommend Looker. The only reason I wouldn't recommend it for the smaller company stages is that the cost is much higher than alternatives such as Metabase. With Looker, you define your data model in LookML, which Looker then uses to provide a drag-and-drop interface for end-users that enables them to build their own visualizations without needing to write SQL. This lets your... - Source: dev.to / over 2 years ago