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.

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

Support Entity-Attribute-Value Tables #4

Open
totalhack opened this issue Mar 20, 2023 · 0 comments
Open

Support Entity-Attribute-Value Tables #4

totalhack opened this issue Mar 20, 2023 · 0 comments
Labels
enhancement New feature or request

Comments

@totalhack
Copy link
Owner

Currently using entity-attribute-value tables (see example image) requires creating views for each attribute and putting those views in your warehouse config as individual dimension tables. It would be nice if zillion had a new "attribute" table type that could automatically adjust the warehouse definition based on the attributes that are supported.

image

To support this we'd need to:

  1. Adjust core.py:TableTypes to support a new type
  2. Adjust configs.py to support a new table type in the config
  3. Review/adjust Datasource.find_neighbor_tables to make sure attribute tables can join as needed
  4. (Hard part) Review/adjust the logic that builds tables and joins that can meet the required grain -- this will need special logic to look at attribute tables since they store their attributes as rows instead of columns.
@totalhack totalhack added the enhancement New feature or request label Mar 20, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
enhancement New feature or request
Projects
None yet
Development

No branches or pull requests

1 participant