To investigate: Is DDL working correctly?

[matthewmturner]

I have the following DDL in my .datafusionrc but the tables are not being created in the correct schema (the table name is "staging.min_aggs" instead of creating "min_aggs" in "staging" schema. I dont yet know whether my DDL is wrong or if this is a dft issue - i am just creating this to make sure i dont forget about it.

CREATE SCHEMA staging;
CREATE SCHEMA production;

CREATE EXTERNAL TABLE staging.min_aggs STORED AS PARQUET LOCATION 'ny2://sip/aggregates/minute_by_ticker_monthly_v2/year_month=2015-08/data.01.parquet';
CREATE EXTERNAL TABLE staging.trades_v2 STORED AS PARQUET LOCATION 'ny2://sip/trades_v2/date=2024-08-30/2024-08-30.01.parquet';

CREATE EXTERNAL TABLE "production".min_aggs STORED AS PARQUET LOCATION 'ny5://sip/aggregates/minute_by_ticker_monthly/year_month=2015-08/data.01.parquet';

CREATE TABLE wide AS VALUES (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20);

[matthewmturner]

Note to self, add tests for this.