Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

[core] schema overhaul #18

Closed
11 tasks done
rudolfix opened this issue Jun 15, 2022 · 0 comments · Fixed by #38
Closed
11 tasks done

[core] schema overhaul #18

rudolfix opened this issue Jun 15, 2022 · 0 comments · Fixed by #38
Assignees
@rudolfix

Comments

@rudolfix
Copy link
Collaborator

rudolfix commented Jun 15, 2022 •
edited
Loading

we should overhaul the existing schema to support the following

  • add precision and scale to applicable types -> moved to [core] add precision and scale to applicable types #39
  • allow to add descriptions to tables and columns
  • review all hints and remove/add -> postponed
  • allow to exclude fields and tables
  • allow to seal table schemas to changes are ignored -> [core] allow to seal table and schemas #40
  • configure unpacker: which fields are propagated to child tables, ??
  • configure loader: write disposition ([loader] implement replace table write disposition #17 )
  • methods to normalize names and generate paths should be pluggable and available in the schema
  • return child - parent relationships from normalizer and store in schema
  • all filters, pref types and hints without re: prefix are treated as regexes ^...$ for easy specification of filters without knowledge of regexes
  • renames the autogenerated fields and tables: adds consistent _dlt prefix
@rudolfix rudolfix self-assigned this Jun 15, 2022
@rudolfix rudolfix changed the title [singer] schema overhaul [core] schema overhaul Jun 15, 2022
@rudolfix rudolfix mentioned this issue Jun 23, 2022
Closed
12 tasks
@rudolfix rudolfix mentioned this issue Jun 27, 2022
Merged
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@rudolfix rudolfix

Labels
None yet
Projects
None yet
Milestone
No milestone
Development

Successfully merging a pull request may close this issue.

schema format overhaul dlt-hub/dlt
1 participant
@rudolfix