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

Update User Filters on older data sources #16

Closed
mcoles opened this issue Nov 21, 2019 · 2 comments
Closed

Update User Filters on older data sources #16

mcoles opened this issue Nov 21, 2019 · 2 comments
Assignees
Labels
enhancement New feature or request

Comments

@mcoles
Copy link
Contributor

mcoles commented Nov 21, 2019

We created some new features for data sources in later 02 version sets that were never added to the old 01 version set. Add new permissions strings to it and edit the User Filter calc appropriately.

@mcoles mcoles added the enhancement New feature or request label Nov 21, 2019
@mcoles mcoles self-assigned this Nov 21, 2019
@mcoles mcoles changed the title Update User Filters on TS Background Tasks 01 Update User Filters on older data sources Nov 22, 2019
@mcoles
Copy link
Contributor Author

mcoles commented Nov 23, 2019

TS Events uses an old-school method, so both 02 and 01 version sets need to be updated. I'm a bit concerned that performance will tank, however, even if the field goes unused, since we'll have to join a bunch of CustomSQL into it...I suppose I'll add them in, then test live query and extract speed differences.

mcoles added a commit that referenced this issue Nov 26, 2019
Stripped "/sheets" from Item Repository URL when the item is a view #12
Forced values for all LUID fields to lowercase #8
Hid new fields #9
Added additional Site fields for consistency #10
Added Project Owner information #15
Refactored perms / user filter field for 01 version #16
mcoles added a commit that referenced this issue Nov 26, 2019
Updated User Filter methodology to be consistent with newer versions #16
Forced values for all LUID fields to lowercase #8
Hid new fields #9
Added additional Site fields for consistency #10
mcoles added a commit that referenced this issue Nov 26, 2019
Forced values for all LUID fields to lowercase #8
Hid new fields #9
Added additional Site fields for consistency #10
Refactored permission data and User Filter for consistency with 02 version #16
Add data source project owner info #18
@mcoles
Copy link
Contributor Author

mcoles commented Dec 18, 2019

Updating this for posterity: This took a long time for TS Events, because it required joining a crapload more tables to an already spiderwebby connection structure. I was concerned what this might do to performance, so at first I tried converting it to a UNION structure rather than doing a million joins. This actually TANKED performance. So I resigned myself to joining all the additional project, user, and system_user tables to all four of the branches in the connection, and did testing against the prior version.

Live connections are very slow to render, but not worse than the prior version:

image

Extract refreshes also seemed not to suffer much:

image

So, yay

mcoles added a commit that referenced this issue Dec 20, 2019
Forced values for all LUID fields to lowercase #8
Hid new fields #9
Added additional Site fields for consistency #10
Updated User Filter for consistency with ther data sources #16
Remove "/sheets" from Repository URL fields in TS Events #12
mcoles added a commit that referenced this issue Dec 20, 2019
Hid new fields #9
Forced values for all LUID fields to lowercase #8
Added additional Site fields for consistency #10
Updated User Filter for consistency with other data sources #16
Fixed Site Role calculation for Viewer role #17
mcoles added a commit that referenced this issue Dec 20, 2019
Add Tableau Server Protocol parameter / fix root hyperlink URL (no number)
Added Version field #14
Forced values for all LUID fields to lowercase #8
Updated User Filter for consistency with other data sources #16
Add a starter sheet to TS Web Requests #2
Clarify "vud" action type in TS Web Requests enhancement #1
@mcoles mcoles closed this as completed Jan 27, 2020
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