Incubator-superset: Adding new Query

[olokedeomotayo]

Good Morning,

I am new to Apache Superset and i have successfully connected MYSQL Db to Superset and the following was my set back;

1. Unable to Join to table together due to the fact that i can not locate where to add my query.
2. I tried using SQL LAB but my database is not LISTED.

Please any help on these.

Thank you.

[olokedeomotayo]

Good Morning,

I am new to Apache Superset and i have successfully connected MYSQL Db to Superset and the following was my set back;

Unable to Join to table together due to the fact that i can not locate where to add my query.
I tried using SQL LAB but my database is not LISTED.

Please any help on these.

Thank you.

[shyam2794]

@olokedeomotayo In the sources -> databases -> click on edit record -> check the expose in sql lab . You will be able to see your database in the SQL Lab .

[olokedeomotayo]

Thank You @shyam2794 this makes me view and work with my Database....

How do i now convert the SQL Script there to Dashboard?

Any Help Please

[shyam2794]

@olokedeomotayo In the Sql lab after writing your query -> click run query -> click visualise .

[olokedeomotayo]

Thank You once again. i would like you to take a look at the SQL Script below;
SELECT name AS name,
(tabSales Invoice Item.item_group) AS item_group,
(tabSales Invoice Item.item_name) AS item_name,
SUM(tabSales Invoice Item.amount) AS sum__amount
(tabSales Invoice Item'.customer_name) AS customer_name, SUM(tabSales Invoice.total) AS sum__total FROM (tabSales Invoice Item) LEFT JOINtabSales InvoiceONtabSales Invoice.name =tabSales Invoice Item`.name
WHERE creation >= '2016-09-10 00:00:00'
AND creation <= '2018-01-23 11:41:34'
GROUP BY name,
item_group,
item_name,
customer_name
ORDER BY sum__amount DESC
LIMIT 50000

the table is returning only for the first table ignoring the other table.

Any Help Also

[shyam2794]

You can have a look at this thread
https://github.com/apache/incubator-superset/issues/875

[olokedeomotayo]

Dear @alanmcruickshank i tried Inserting the Row just like you explained in Isues #875 but i seems not to be getting the correct results.
I have a two tables i want to join like that, i have a Column in one but not in the other table which i want to Insert into the Other table, how do i go about this any help Please.

[stale[bot]]

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions. For admin, please label this issue .pinned to prevent stale bot from closing the issue.

[Saranya411]

Hi All,

Can someone help me to connect Netezza from Superset. I'm new to superset and not sure how to connect Netezza from Superset