airbytehq / airbytehq/airbyte

Destination snowflake: remove raw table case-sensitivity

Aperta
#30,101 6 commenti 5 reazioni 0 assegnatari Vedi su GitHub
connectors/destination/snowflake frozen team/destinations
Lingua principale
Python
Stelle
22.1k
Fork
5.3k
Metriche di merge delle PR
Metriche PR in attesa

Descrizione

follow-on to https://github.com/airbytehq/airbyte/issues/30010

raw tables are still case-sensitive, i.e. must be queried as `select * from "airbyte_internal"."foo_raw__stream_bar"`. we... probably should make those also case-insensitive, i.e. queryable as `select * from airbyte_internal.foo_raw__stream_bar`?

this is a bit trickier because we can't just do a soft reset, we'll need to actually do an alter table or `create table ... select` sort of thing.

for now, there's a relatively easy workaround to just create views on whatever raw tables:
```sql
create schema airbyte_internal;
create view airbyte_internal.foo_raw__stream_bar as
select
"_airbyte_raw_id" as _airbyte_raw_id,
"_airbyte_extracted_at" as _airbyte_extracted_at,
"_airbyte_loaded_at" as _airbyte_loaded_at,
"_airbyte_data" as _airbyte_data
from "airbyte_internal"."foo_raw__stream_bar"
```

Guida per i contributori

Apri la guida per i contributori

Valutazione

Questa issue non è ancora stata valutata.

Ricevi le nuove issue nella tua casella

Un breve riepilogo di issue GitHub adatte ai principianti.