Airbnb's Caravel - the perfect complement to Snowplow?

[Robert Kingston]

Hi guys,

Airbnb recently open-sourced their BI tool, Caravel. It runs on top of Python / Flask / SQLAlchemy / NVD3:

https://github.com/airbnb/caravel

Note: It doesn't work with Redshift ... yet. However, they're currently working on adding support for Redshift's schema here (right now they're about to merge this pull request):

https://github.com/airbnb/caravel/pull/249

As you can see - very fresh.  Anyway, just thought you guys might find this worth following - we're certainly excited by this.

Cheers,

Rob

[tobias...@justwatch.com]

Hi,

thanks for sharing this, I thought about setting this up too. It looks really promising and I thought it would work out of the box, because they support postgres. But than I wait for the PR to be merged.

[Christophe Bogaert]

Thanks for sharing Rob! This looks promising.

Christophe

Snowplow Analytics

The Roma Building, 32-38 Scrutton Street, London EC2A 4RQ, United Kingdom
+44 (0) 203 589 6116
+44 (0) 7598 006 851

On Mon, Apr 4, 2016 at 4:51 AM, <tobias...@justwatch.com> wrote:

Hi,

thanks for sharing this, I thought about setting this up too. It looks really promising and I thought it would work out of the box, because they support postgres. But than I wait for the PR to be merged.

--
You received this message because you are subscribed to the Google Groups "Snowplow" group.
To unsubscribe from this group and stop receiving emails from it, send an email to snowplow-use...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Robert Kingston]

No probs guys.

If you want to start using it now before Redshift/PostgreSQL are fully supported. I suggest you create a user with the same username as the schema you want to query from. That will set the search path properly: http://docs.aws.amazon.com/redshift/latest/dg/r_search_path.html

Secondly, you may like to use the redshift+psycopg2 flavour/engine: https://pypi.python.org/pypi/redshift-sqlalchemy

[tobias...@justwatch.com]

It was merged today, so I guess I wait for the next version and than try it out with full support.