REPLACE job: `CREATE TABLE "testdrive_staging"."exchange_latest" (like "testdrive"."exchange_latest" INCLUDING ALL);`

[amotl]

Problem

After #9, dlt issues this query when using the replace strategy, but fails on CrateDB.

CREATE TABLE "testdrive_staging"."exchange_latest" (LIKE "testdrive"."exchange_latest" INCLUDING ALL);

SQLParseException[line 1:53: no viable alternative at input 'CREATE TABLE "testdrive_staging"."exchange_latest" (like']

[amotl]

There is CrateDB's CREATE TABLE AS statement, but it will not just create the schema, but also copy the data.

@hlcianfagna, @hammerhead: Do you know a workaround for this problem, i.e. I would like to "just clone" a schema from another table, but not fill data, like EVAL(SHOW CREATE TABLE "testdrive"."exchange_latest"), but with a renaming action.

[amotl]

The MSSQL dialect inspired us to add a query constraint which never matches, to suppress transferring data. 🌞

CREATE TABLE "testdrive_staging"."exchange_latest" AS SELECT * FROM "testdrive"."exchange_latest" WHERE 1 = 0;

[amotl]

An update was merged into CrateDB on Mar 18. We may want to try it by phasing out the relevant workaround.

• CREATE TABLE ... LIKE ... crate#18109