On Thu, 2020-01-30 at 15:08 -0500, Reid Thompson wrote: > is what I am attempting in the subject line possible? > > I have a storage schema defined (dbpg) from which I can > use schema dbpg; select * from table x; > and get the contents of table x. > > I have a storage schema defined s3 from which I can > use schema s3; show files in s3.dummy; select * from s3.dummy; > and get a listing of files, and select content of files from; > > I would like to be able to select content from the postgresql tables and > write them to parque files in the s3 filesystem. Is there a way to do > that? > > Can I do it with the s3 storage plugin, or do I have to configure the > dfs plugin to access my s3 stoarge? > > Thanks, > reid
I think i have figured this out. I had to create a writable matching workspace (dummy) in the storage plugin for where I wanted to create the table(parquet files). And I had to prepend the pgdb schema to the select statement.. show schemas now lists s3.dummy as a schema. create table s3.dummy.`postgresql_table` as select * from pgdb.postgresql.table;
