Hi, yes, in Superset as with any other dashboard solution you are better off with denormalized flat tables. You would want to build a data warehouse and add most of the calculations in your column tables. It’s just easier, but there are also performance concerns that point in that direction(i.e. avoiding joins).
Alessio Sent from my iPhone > On 29. Jul 2018, at 00:06, Hank Calzaretta <[email protected]> wrote: > > Hi, > > Superset exploits SQLAlchemy to handle the database specifics. Both > SQLAlchemy and Superset are 100% Python thus a DBI module in addition to a > Dialect module need to be put in place. The various database > vendors/developers provide a SQLAlchemy Dialect module to handle the SQL > syntax characteristics unique to that database. Some databases provide their > own DBI module while others use the open source 'pyodbc' DBI module. You can > check the SQLAlchemy documentation to see what database dialects are included. > > In Superset, when you create a datasource, you provide a SQLAlchemy URI which > looks something like this for PostgreSQL. > > postgres://user:[email protected]/looker_test > > The URI for the database we are creating looks like this: > > ocientdb+pyodbc://looker:XXXXXXXXXX@OcientLkr > > This says to use the 'ocientdb' Dialect combined with the 'pyodbc' DBI. > > So if you are using a popular database like MSSQL, MySQL, Postgres etc. it is > fairly easy to connect Superset to a database. > > Hank Calzaretta > > > > www.ocient.com > > 630-957-8802 > > [email protected] > > 100 North Riverside Plaza, Suite 800 > > Chicago, IL 60606 > > > From: sunkara raja <[email protected]> > Sent: Thursday, July 26, 2018 6:26:24 AM > To: [email protected] > Subject: DWH combining with Superset > > Hi, > > I am new to BI tools, so i want to know how to integrate different Data > Bases for Visualization in Superset. > > Do we have to build Data Ware House and use Superset or can we directly Use > Superset. > > Thanks
