@/all Final version of Cubes 2.0 goals: https://gist.github.com/Stiivi/3dd87f0ba920d2cae49e45d210bb0265
That fix gets past the config error, list now works, however denormoralize is now failing with " File "/home/mdmetrix-dev/.local/lib/python2.7/site-packages/cubes/sql/store.py", line 362, in create_denormalized_view
insp = reflection.Inspector.from_engine(engine)
NameError: global name 'engine' is not defined" cannot spend anymore time on it today, but may be able to come back to it towards the end of the week.
insp = reflection.Inspector.from_engine(engine)
NameError: global name 'engine' is not defined" cannot spend anymore time on it today, but may be able to come back to it towards the end of the week.
Stil very early work.
But I'm working on quick integration paths between Pandas, CSV, SQL, Django and Cubes/CubesViewer, also integration with Jupyter Notebook
I'd like to view cubes through superset https://github.com/airbnb/superset has anyone tried this yet?
import bubbles
src_url = 'postgresql://primarysite:primarysite@localhost/primarysite'
dest_url = 'postgresql://primarysite:primarysite@localhost/slicer_db'
stores = {'source': bubbles.open_store('sql', src_url),
'target': bubbles.open_store('sql', dest_url), }
pl = bubbles.pipeline.Pipeline(stores=stores)
pl.source('source', 'core_site')
pl.create('target', 'core_site')
pl.run()
this creates a table as
CREATE TABLE core_site
(
id integer,
name character varying(255),
...)
(
id integer,
name character varying(255),
...)
without any indexes
are you starting with this ETL now? is it for work or hobby?
for now it is research into the tooling
I had a look at bubbles, metl (very short at petl and pygraml and bonobo)
I think I will use bubbles for the proof of concept and then have a second look at the above other tools#
proof of concept means: I am building a analytics db with cubes and use bubbles to get some initial data into it
when i run "slicer serve slicer.ini" i ge below error
- Restarting with stat
File "C:\Users\krishna\AppData\Local\Programs\Python\Python36\Scripts\slicer.exe", line 1
SyntaxError: Non-UTF-8 code starting with '\x90' in file C:\Users\krishna\AppData\Local\Programs\Python\Python36\Scripts\slicer.exe on line 1, but no encoding declared; see http://python.org/dev/peps/pep-0263/ for details
Plz help
Anyone still active about cubes? I need help!
e.g. i want to calculate the difference between subsequent rows via a window function:
{
'name': 'revenue_change',
'expression': "(lead(coalesce(sum(pl.revenue), 0)::integer, 1, 0) OVER (ORDER BY month_end DESC) - coalesce(sum(pl.revenue), 0)) AS delta"
}
I don't know if there is some standard for that at any level. In the OLAP materials I've read that need is not usually even mentioned, or is left up to the reporting/visualization tool. Also afaik standards like MDX don't contemplate that explicitly, besides allowing subqueries.
and a cube defined as