search

splitgraph / seafowl

Analytical database for data-driven Web applications 🪶
https://seafowl.io
Apache License 2.0
397 stars 9 forks source link

Add ability to drop external tables #323

Closed mildbyte closed 1 year ago

mildbyte commented 1 year ago

Currently, it's impossible to drop staging external tables (they don't take any space but still hang out in the information_schema):

./examples/clients/node/seafowl-client.js "CREATE EXTERNAL TABLE tmp_pageeupqfplykfky7 STORED AS PARQUET LOCATION 'https://d37ci6vzurychx.cloudfront.net/trip-data/yellow_tripdata_2022-01.parquet';"
code: 200

./examples/clients/node/seafowl-client.js "DROP TABLE staging.tmp_pageeupqfplykfky7"
Error: 400: Error during planning: '"staging.tmp_pageeupqfplykfky7"' is a read-only table
    at IncomingMessage.<anonymous> (/Users/neumark/git/seafowl/examples/clients/node/seafowl-client.js:121:31)
    at IncomingMessage.emit (node:events:526:28)
    at emitCloseNT (node:internal/streams/destroy:138:10)
    at processTicksAndRejections (node:internal/process/task_queues:82:21)
gruuya commented 1 year ago

Closed by #326