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

Asset tagging #3541

Open
evansiroky opened this issue Nov 12, 2024 · 2 comments
Open

Asset tagging #3541

evansiroky opened this issue Nov 12, 2024 · 2 comments
Assignees
Labels
infrastructure Maintenance of infrastructure supporting the data warehouse. Product owner is @evansiroky

Comments

@evansiroky
Copy link
Member

User story / feature request

As an owner of the Caltrans data warehouse/cloud environment,
I would like for there to be a tagging system that exists,
So that I can properly account for all the things in our data warehouse/cloud environment.

Acceptance Criteria

A plan for tagging virtual assets is developed and implemented.

Notes

This is partially to help comply with the needed items in the CDT review of our cloud system.

@evansiroky evansiroky added the infrastructure Maintenance of infrastructure supporting the data warehouse. Product owner is @evansiroky label Nov 13, 2024
@erikamov erikamov self-assigned this Jan 29, 2025
erikamov added a commit that referenced this issue Jan 30, 2025
@erikamov
Copy link
Contributor

erikamov commented Jan 30, 2025

@evansiroky Based on the structure of the data models, I could create the following Labels.
What do you think?

domain:

  • seeds
  • external
  • staging
  • intermediate
  • mart

dataset:

  • audit
  • benefits (benefits and amplitude datasets)
  • gtfs (gtfs and rt datasets)
  • gtfs_quality
  • gtfs_schedule_latest
  • ntd
  • ntd_annual_reporting
  • ntd_ridership
  • ntd_safety_and_security
  • ntd_validation
  • payments
  • state_geoportal
  • transit_database
  • transit_database_latest

Visualizing models in BigQuery it would show on the labels like in the image bellow:

Image

erikamov added a commit that referenced this issue Jan 30, 2025
erikamov added a commit that referenced this issue Jan 31, 2025
@evansiroky
Copy link
Member Author

@evansiroky Based on the structure of the data models, I could create the following Labels. What do you think?

domain:

  • seeds
  • external
  • staging
  • intermediate
  • mart

dataset:

  • audit
  • benefits (benefits and amplitude datasets)
  • gtfs (gtfs and rt datasets)
  • gtfs_quality
  • gtfs_schedule_latest
  • ntd
  • ntd_annual_reporting
  • ntd_ridership
  • ntd_safety_and_security
  • ntd_validation
  • payments
  • state_geoportal
  • transit_database
  • transit_database_latest

Visualizing models in BigQuery it would show on the labels like in the image bellow:

Image

@erikamov makes sense to me!

erikamov added a commit that referenced this issue Feb 4, 2025
erikamov added a commit that referenced this issue Feb 4, 2025
@erikamov erikamov mentioned this issue Feb 4, 2025
6 tasks
erikamov added a commit that referenced this issue Feb 5, 2025
erikamov added a commit that referenced this issue Feb 5, 2025
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
infrastructure Maintenance of infrastructure supporting the data warehouse. Product owner is @evansiroky
Projects
None yet
Development

No branches or pull requests

2 participants