Comments (4)
re:dash uses two databases: one that it queries (which at the moment can be either be Redshift or PostgreSQL) and another one where it stores its metadata (like queries and query results), that at the moment can only be PostgreSQL (but later we will add support for MySQL too).
tables.sql
creates the metadata tables and was written for PostgreSQL. It can be adjusted to work on Redshift, but you will have better performance if you keep the metadata in pg.
from redash.
Btw, if you need any help with setting re:dash up, don't hesitate contacting me directly -- arik at everything.me.
from redash.
That's fine. I was confused by the line in your README:
"PostgreSQL is used both as the operatinal database for the system, but also as the data store that is being queried. To be exact, we built this system to use on top of Amazon's Redshift, which supports the PG driver. But it's quite simple to add support for other datastores, and we do plan to do so."
I assumed that if the data being visualised was in Redshift, then the operational database would be held there too. I am going to have another go at installing it.
I'll have a go at installing with these comments in mind and let you know if I have any problems.
from redash.
Note that: CONNECTION_STRING
in the settings file refers to the database you query (Redshift) while INTERNAL_DB_CONNECTION_STRING
and the django configuration block refer to operational db (the pg one; both the connection string and django config are for the same DB).
from redash.
Related Issues (20)
- Uncaught promise error in Edit Visualization Dialog Modal
- date parameter configuration in redash self hosting. HOT 3
- Redash does not connect to Microsoft SQL Azure HOT 2
- queury in queue issue
- SchedulerWorker doesn't refresh query HOT 1
- Redash can't refresh mongodb schema unless all collections are granted HOT 2
- How to customize data label in redash HOT 1
- Query Results Error When I Join Multitable
- How can I disable/hide filters in an embedded dashboard? HOT 1
- Problem with asset location server.css after setup on Ubuntu HOT 1
- Slack as Alert destination: URLs in messages posted to Slack are not clickable links HOT 1
- Downgrading then upgrading redash schemas doesn't work HOT 6
- DynamoDB Support (regression issue) HOT 2
- numberFormat and thousandsSep HOT 6
- How to add counter visualization clickable its is possible ? HOT 2
- Feature request: an installation script for Fedora! HOT 1
- Front end data type display exception HOT 7
- puppeteer issue with Apple Silicon chips HOT 19
- Data Source "Redshift (with IAM User/Role)" does not support Redshift Serverless HOT 2
- Redash adds `/redash` prefix if a string starts with `/api` HOT 2
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from redash.