Destination snowflake: remove raw table case-sensitivity
- 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.