Querying Virtual Dataset/Tables

[lenlobo]

Hi,

so I have a connection to a Postgres database, and in SQL Lab, I have a query which results in a dataset which I save ( this gets saved as a virtual table/dataset). I create charts according to this virtual table and everything seems fine.

Now,
I wanted to create another virtual table based on this virtual table or atleast query it in SQL Lab.

Is it possible to do so?

[dosubot[bot]]

Hello @lenlobo! I'm here to help you with any bugs, questions, or contributions. Let me know how I can assist you!

Yes, it is possible to create another virtual table based on an existing virtual table or query it in SQL Lab when connected to a Postgres database. In SQL Lab, you can write SQL queries to join multiple tables as long as your database account has access to them. Additionally, Apache Superset allows for the creation of new tables and views based on queries through the allow_ctas (CREATE TABLE AS) and allow_cvas (CREATE VIEW AS) settings ^[1].

To continue talking to Dosu, mention @dosu.

[Yash-alternativepath]

@lenlobo Did this approach work for you? Or did you find any other solution? If yes, could you please share it?

[lenlobo]

Nope, I ended up creating an aggregated table in Clickhouse for quick reads to Superset. Raw data in PG, aggregate it daily to Clickhouse and then display on Superset.

[Yash-alternativepath]

@lenlobo Does RLS work for you in SQL Lab when querying real (physical) tables?
When i create widget it shows the filtered data but on sql lab it shows all data present in it.
So can we achieve filtering in sql Lab too?

[lenlobo]

I'm not sure, I just used SQL Lab for data exploration and debugging when needed

…

On Thu, 1 May 2025, 12:37 am Yash-alternativepath, ***@***.***> wrote: @lenlobo <https://github.com/lenlobo> Does RLS work for you in SQL Lab when querying real (physical) tables? When i create widget it shows the filtered data but on sql lab it shows all data present in it. So can we achieve filtering in sql Lab too? — Reply to this email directly, view it on GitHub <#30529 (reply in thread)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/ALC3YC3LRGMNV6HXUCBWAED24FGBLAVCNFSM6AAAAABPNQ4NKGVHI2DSMVQWIX3LMV43URDJONRXK43TNFXW4Q3PNVWWK3TUHMYTEOJZHEZTGMA> . You are receiving this because you were mentioned.Message ID: ***@***.***>