crate / crate/dlt-cratedb

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

Open
#10 3 comments 0 reactions 0 assignees View on GitHub
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

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.