Skip to content

TechArtists/data-dbt-firebase-analytics

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

21 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

This library works by default for one Firebase/Google Cloud Project:

"TA:SOURCES":

#   - {project_id: google_cloud_project_id,
#     analytics_dataset_id: schema_id,
#     events_table: events_table_prefix*,
#     crashlytics_dataset_id: crashlytics_dataset,
#     crashlytics_table: crashlytics_table_prefix*}

Adding more project_ids and multiple dataset_ids for specific datasets is also possible. A few additional steps are required for multiple sources to be added as sources.

  1. TA:SOURCES_READY must be set to false (default).
  2. add projects and datasets to the TA:SOURCES variable in your dbt project
  3. run the following command to generate sources for all projects: dbt run-operation -q generate_firebase_sources > models/firebase_sources.yml
  4. change TA:SOURCES_READY to true

"TA:SOURCES":

#   - {project_id: google_cloud_project_id,
#     analytics_dataset_id: schema_id,
#     events_table: events_table_prefix*,
#     crashlytics_dataset_id: crashlytics_dataset,
#     crashlytics_table: crashlytics_table_prefix*}
#   - {project_id: google_cloud_project_id2,
#     analytics_datasets_id: [schema_id,schema_id2],
#     events_table: events_table_prefix*,
#     crashlytics_dataset_id: crashlytics_dataset,
#     crashlytics_table: crashlytics_table_prefix*}

Resources:

  • Learn more about dbt in the docs
  • Check out Discourse for commonly asked questions and answers
  • Join the dbt community to learn from other analytics engineers
  • Find dbt events near you
  • Check out the blog for the latest news on dbt's development and best practices

TODO

  • why the DAU counts in app_health (aka _events) doesn't match the ones from raw. There's a dimension in there that's not fully disjunct, maybe make a _events_disjunct table as well