REPLACE job: `CREATE TABLE "testdrive_staging"."exchange_latest" (like "testdrive"."exchange_latest" INCLUDING ALL);`
- Dominant language
- Python
- Stars
- 0
- Forks
- 1
- PR merge metrics
- No merged PRs in 30d
Description
## Problem
After crate-workbench/dlt-cratedb#9, dlt issues this query when using the replace strategy, but fails on CrateDB.
```sql
CREATE TABLE "testdrive_staging"."exchange_latest" (LIKE "testdrive"."exchange_latest" INCLUDING ALL);
```
```text
SQLParseException[line 1:53: no viable alternative at input 'CREATE TABLE "testdrive_staging"."exchange_latest" (like']
```
Contributor guide
No contributing guide indexed for this repository
Research direction
Start by tracing the replace strategy in the dlt CrateDB destination adapter that emits the shown CREATE TABLE ... LIKE ... INCLUDING ALL query, then check the relevant CrateDB SQL support. Done means a replace-strategy load no longer fails on this query and the behavior has regression coverage.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- python, sql
- Domain
- data-engineering, databases
- Issue type
- Bug
- Difficulty
- 3/5
- Estimated time
- 1-2 days
- Activity status
- Quiet
- Clarity
- Mostly clear
- Newbie friendliness
- 56/100