This is a javascript library/api wrapper. However useful, it's not a 'L'anguage.
Mixpanel: Introducing JQL, a query language to analyze and learn from data
11–20 of 23 posts
Re: Mixpanel: Introducing JQL, a query language to analyze and learn from data
#12Seems like this is in response to competitors offering raw access to the data. e.g. https://amplitude.com/sql-queries https://segment.com/redshift etc
> Mixpanel lets you pull your data out at any time https://mixpanel.com/docs/api-documentation/data-export-api
Similar but very different. Segment and Amplitude manage the ETL and database for you. No development or maintenace required on your end.
Re: Mixpanel: Introducing JQL, a query language to analyze and learn from data
#13function main() {
while(true) {
// it's great feature but i'm not sure that javascript is the right language. just because sql is not the best way to run analytic queries such as funnel and retention, it doesn't mean that we need a replacement. you basically expect all data analysts to learn javascript instead of sql.
}
}
Re: Mixpanel: Introducing JQL, a query language to analyze and learn from data
#14Seems like this is in response to competitors offering raw access to the data. e.g. https://amplitude.com/sql-queries https://segment.com/redshift etc
> Mixpanel lets you pull your data out at any time https://mixpanel.com/docs/api-documentation/data-export-api
My company (Fivetran YC W2013) will sync your mixpanel data to Redshift, Postgres, or Snowflake using the mixpanel API.
Re: Mixpanel: Introducing JQL, a query language to analyze and learn from data
#15Just the other day I looked at a team member and said, "You know what would be great? A Mixpanel API so I can just pull out the data I need on a regular basis and put in on a dashboard so we are always looking at the same metrics"
BAM.
Re: Mixpanel: Introducing JQL, a query language to analyze and learn from data
#16Earlier quoted context omitted.
> Mixpanel lets you pull your data out at any time https://mixpanel.com/docs/api-documentation/data-export-api
My company (Fivetran YC W2013) will sync your mixpanel data to Redshift, Postgres, or Snowflake using the mixpanel API.
It's not something I need at the moment, but happy to take a look. Thanks!
Re: Mixpanel: Introducing JQL, a query language to analyze and learn from data
#17Earlier quoted context omitted.
> Mixpanel lets you pull your data out at any time https://mixpanel.com/docs/api-documentation/data-export-api
Similar but very different. Segment and Amplitude manage the ETL and database for you. No development or maintenace required on your end.
Granted, but when we're talking about access to raw data then that's actually what I want.
Re: Mixpanel: Introducing JQL, a query language to analyze and learn from data
#18Just the other day I looked at a team member and said, "You know what would be great? A Mixpanel API so I can just pull out the data I need on a regular basis and put in on a dashboard so we are always looking at the same metrics" BAM.
If you want an SQL like interface for Mixpabel data as well as other data sources, you might find Treasure Data useful. Here is a step by step guide that I wrote: https://blog.treasuredata.com/blog/2015/11/17/mixpanel-expor...
(Disclaimer: I work for Treasure Data. That said, there's also an open source way to do this with Embulk + many common SQL databases. See https://github.com/embulk)
Re: Mixpanel: Introducing JQL, a query language to analyze and learn from data
#19Seems a little outdated to stick with ES5, particularly in the examples.
Re: Mixpanel: Introducing JQL, a query language to analyze and learn from data
#20Seems a little outdated to stick with ES5, particularly in the examples.
A lot of es2015 syntax does work, such as arrow functions. Under the hood it's a recent v8