I want to create temporary data to test out my BI solution. I only need a few rows of data. How can I create a table in the Panoply platform and add data to that new table?
Enter the following queries from the Analyze page or from an external workbench.
create table x (field1 int, field2 text)
This will create the table.
insert into x values (1, 'foo')
This will insert data into the table.