It would be great if I could save the results of a SQL query as a new table | Voters

It would be great if I could save the results of a SQL query as a new table

Bud

I suppose here this might look like a view or materialized view, but would be awesome if I could save the results from the Query Editor as a table within the repo.

June 15, 2021

Madelaine Boyd

So that I can more fully understand, why do you specifically want a table instead of a view? Do you want to edit or insert particular values?

Bud

Madelaine Boyd: I suppose no preference as to how its stored on the backend. Test case here was: loaded in a CSV, wanted to clean up some of the datatypes and add a couple columns, and save off that work within the repo. No real preference on how its stored, insofar as its accessible via 3rd party connections (thus maybe longer term provide the option for materialized view/table vs standard view?

Jonathan Mortensen

Bud: You can use "Save View" button on the query results (see attached). You can also use

CREATE VIEW AS

syntax in the query editor

Madelaine Boyd

Jonathan Mortensen: If I understand Bud correctly, Bud specifically requests a Materialized View, not a View.

Photo Viewer