search

edp963 / davinci

Davinci is a DVsaaS (Data Visualization as a Service) Platform
https://edp963.github.io/davinci
Apache License 2.0
4.91k stars 1.82k forks source link

multiple datasets?? #2270

Closed chinobing closed 3 years ago

chinobing commented 3 years ago

Is that possible to merge or join mutiple datasets by a keyword from different databases(mysql)?

scottsut commented 3 years ago

https://github.com/edp963/moonbox is used for that.

chinobing commented 3 years ago

https://github.com/edp963/moonbox is used for that.

can i achieve the same purpose without using extra tool like moonbox cuz my davinci is runing under docker

im coming from metabase. what i really want is using "join" function with two datasets as metabase does

scottsut commented 3 years ago

Metabase does not seem to support joining tables across multiple databases.

https://www.metabase.com/docs/latest/faq/using-metabase/how-do-i-answer-questions-when-data-is-in-multiple-databases.html

If you mean join tables in one database, SQL can do anything.

scottsut commented 3 years ago

For MySQL, you can create a source to connect to an instance instead of a specific database. Then you can use database_name.table_name in SQL to join another database tables.

chinobing commented 3 years ago

thx

chinobing commented 3 years ago

yoyo, just realized you are working on datart too. i want to deploy datart under docker-compose . but the docker-compose.yml of datart doesnt detail the email setup and chrome. can i just copy the one from davinci to datart?

scottsut commented 3 years ago

yoyo, just realized you are working on datart too. i want to deploy datart under docker-compose . but the docker-compose.yml of datart doesnt detail the email setup and chrome. can i just copy the one from davinci to datart?

Thank for the interest!

davinci and datart are two completely different projects, docker-compose.yml cannot be mixed. datart does not need to configure server details in docker-compose.yml, just edit it directly in config folder, and docker can work synchronously.

chinobing commented 3 years ago

Thanks for the useful info. Have a nice day bro

Get Outlook for iOShttps://aka.ms/o0ukef

From: scott @.> Sent: Thursday, November 4, 2021 6:21:39 PM To: edp963/davinci @.> Cc: Bing Wong @.>; State change @.> Subject: Re: [edp963/davinci] multiple datasets?? (Issue #2270)

yoyo, just realized you are working on datart too. i want to deploy datart under docker-compose . but the docker-compose.yml of datart doesnt detail the email setup and chrome. can i just copy the one from davinci to datart?

Thank for the interest!

davinci and datart are two completely different projects, docker-compose.yml cannot be mixed. datart does not need to configure server details in docker-compose.yml, just edit it directly in config folder, and docker can work synchronously.

— You are receiving this because you modified the open/close state. Reply to this email directly, view it on GitHubhttps://github.com/edp963/davinci/issues/2270#issuecomment-960624219, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AGTQCLHQNME3BMPGUHUBOVTUKJNDHANCNFSM5HKUI52A.