Unable to create table from csv/parquet file #44
Description
I'm trying to create db from csv/parquet
MacOS: 15.4.1
Model: M1 Max
RAM: 64 GB
# load csv data
wget https://web.stanford.edu/class/archive/cs/cs109/cs109.1166/stuff/titanic.csvTrying to create database based on https://anyquery.dev/connection-guide/datasette/
# regular select works
anyquery
# inside shell
select * from read_csv('titanic.csv');
# works fine# create table
anyquery q dataset
CREATE TABLE dataset AS SELECT * FROM read_csv('titanic.csv');
VACUUM;> after -> CREATE TABLE dataset AS SELECT * FROM read_csv('titanic.csv');
no such table: read_csv
> after -> VACUUM;
+
+
0 results
What I'm missing?
P.S. Thanks for awesome tool!