prepsmith/eic-redash

Make Your Company Data Driven. Connect to any data source, easily visualize and share your data.

Redash is our take on freeing the data within our company in a way that will better fit our culture and usage patterns.

Prior to Redash, we tried to use traditional BI suites and discovered a set of bloated, technically challenged and slow tools/flows. What we were looking for was a more hacker'ish way to look at data, so we built one.

Redash was built to allow fast and easy access to billions of records, that we process and collect using Amazon Redshift ("petabyte scale data warehouse" that "speaks" PostgreSQL). Today Redash has support for querying multiple databases, including: Redshift, Google BigQuery, PostgreSQL, MySQL, Graphite, Presto, Google Spreadsheets, Cloudera Impala, Hive and custom scripts.

Redash consists of two parts:

1. Query Editor: think of JS Fiddle for SQL queries. It's your way to share data in the organization in an open way, by sharing both the dataset and the query that generated it. This way everyone can peer review not only the resulting dataset but also the process that generated it. Also it's possible to fork it and generate new datasets and reach new insights.
2. Dashboards/Visualizations: once you have a dataset, you can create different visualizations out of it, and then combine several visualizations into a single dashboard. Currently it supports charts, pivot table and cohorts.

Demo

You can try out the demo instance: http://demo.redash.io/ (login with any Google account).

Getting Started

• Setting up Redash instance (includes links to ready made AWS/GCE images).
• Documentation.

Getting Help

• Issues: https://github.com/getredash/redash/issues
• Discussion Forum: https://discuss.redash.io/
• Slack: http://slack.redash.io/
• Gitter (chat): https://gitter.im/getredash/redash

Reporting Bugs and Contributing Code

• Want to report a bug or request a feature? Please open an issue.
• Want to help us build Redash? Fork the project, edit in a dev environment, and make a pull request. We need all the help we can get!

License

BSD-2-Clause.

eic-redash's Issues

create integration with circle ci

As the title says

Issuer content is missing

saml response from redash is

<?xml version='1.0' encoding='UTF-8'?>
<samlp:AuthnRequest xmlns:saml="urn:oasis:names:tc:SAML:2.0:assertion" xmlns:samlp="urn:oasis:names:tc:SAML:2.0:protocol" AssertionConsumerServiceURL="http://localhost:5000/saml/callback" Destination="https://login.staging.prepsmith.com/saml/auth" ID="id-1nIklwdRC8rDFZjMn" IssueInstant="2018-01-11T09:19:19Z" ProtocolBinding="urn:oasis:names:tc:SAML:2.0:bindings:HTTP-POST" Version="2.0">
  <saml:Issuer Format="urn:oasis:names:tc:SAML:2.0:nameid-format:entity" />
  <samlp:NameIDPolicy AllowCreate="false" Format="urn:oasis:names:tc:SAML:2.0:nameid-format:transient" />
</samlp:AuthnRequest>

content of saml:Issuer is missing, it could be SAML Entity ID in the setting, but I can't change it.

I have to hack saml-idp Prepsmith/saml_idp@842e196

need to figure out where to set keys

In general we need to verify the response from iam-api saml server, to do verification, we need to use public key to verify it, but I can't find where to set the key.

So I have to hack pysaml2 to skip it. Prepsmith/pysaml2@301168a

redash current datetime looks weird

redash can't verify the saml response when it checks saml response datetime.

it will say "2018-48-11T23:47:52Z" is not before "2018-01-11T23-47:57Z"

I have to hack saml-idp saml-idp/saml_idp@cf08294

Add data source to REDASH

add the following data source

• eic_analytics_staging
• RBAC
• eic-studytour-api

saml response does not use correct namespace

redash generates saml response as

<?xml version='1.0' encoding='UTF-8'?>
<ns0:AuthnRequest xmlns:ns0="urn:oasis:names:tc:SAML:2.0:protocol" xmlns:ns1="urn:oasis:names:tc:SAML:2.0:assertion" AssertionConsumerServiceURL="http://localhost:5000/saml/callback" Destination="https://login.staging.prepsmith.com/saml/auth" ID="id-RapIvGTjnjimF8r8J" IssueInstant="2018-01-10T06:22:03Z" ProtocolBinding="urn:oasis:names:tc:SAML:2.0:bindings:HTTP-POST" Version="2.0">
  <ns1:Issuer Format="urn:oasis:names:tc:SAML:2.0:nameid-format:entity" />
  <ns0:NameIDPolicy AllowCreate="false" Format="urn:oasis:names:tc:SAML:2.0:nameid-format:transient" />
</ns0:AuthnRequest>

but it should use saml instead of ns1 and samlp instead of ns0

I have to hack pysaml2 Prepsmith/pysaml2@d7a543e