rmi-sql
Use this skill for RMI-specific SQL design, including SRI analysis, route metadata parsing, bottleneck detection, and complex traffic metrics. This is the expert guide for writing high-quality queries against RMI BigQuery datasets.
Pinned to revision 2a1bf909002b, so it is the text this page describes rather than whatever the author pushed since.
Files
- skills/rmi-sql/SKILL.md
- skills/rmi-sql/assets/catalog/catalog.md
- skills/rmi-sql/assets/notebooks/BigQuery_Admin_Samples.ipynb
- skills/rmi-sql/assets/notebooks/Data_Engineer_Samples.ipynb
- skills/rmi-sql/assets/notebooks/Data_Scientist_Samples.ipynb
- skills/rmi-sql/assets/notebooks/RMI_Planner_Samples.ipynb
- skills/rmi-sql/assets/notebooks/Traffic_Operations_Manager_Samples.ipynb
- skills/rmi-sql/assets/notebooks/Urban_Planner_Samples.ipynb
- skills/rmi-sql/assets/queries/README.md
- skills/rmi-sql/assets/queries/bigquery_admin/bqa0_metadata_inventory.sql
- skills/rmi-sql/assets/queries/bigquery_admin/bqa1_scan_volume.sql
- skills/rmi-sql/assets/queries/bigquery_admin/bqa2_cost_attribution.sql
- skills/rmi-sql/assets/queries/bigquery_admin/bqa3_derived_resources.sql
- skills/rmi-sql/assets/queries/bigquery_admin/bqa4_query_patterns.sql
- skills/rmi-sql/assets/queries/bigquery_admin/bqa5_partition_pruning.sql
- skills/rmi-sql/assets/queries/bigquery_admin/bqa6_data_complexity_audit.sql
- skills/rmi-sql/assets/queries/data_engineer/de1_materialized_view.sql
- skills/rmi-sql/assets/queries/data_engineer/de2_data_cleaning.sql
- skills/rmi-sql/assets/queries/data_engineer/de3_sri_flattening.sql
- skills/rmi-sql/assets/queries/data_engineer/de4_attribute_extraction.sql
- skills/rmi-sql/assets/queries/data_engineer/de5_freshness_audit.sql
- skills/rmi-sql/assets/queries/data_engineer/de6_hourly_preaggregation.sql
- skills/rmi-sql/assets/queries/data_engineer/de7_routes_status_snapshot.sql
- skills/rmi-sql/assets/queries/data_scientist/ds10_corridor_seasonality_decomposition.sql
- skills/rmi-sql/assets/queries/data_scientist/ds1_outlier_detection.sql
- skills/rmi-sql/assets/queries/data_scientist/ds2_similarity_clustering.sql
- skills/rmi-sql/assets/queries/data_scientist/ds3_feature_engineering.sql
- skills/rmi-sql/assets/queries/data_scientist/ds4_route_integrity_audit.sql
- skills/rmi-sql/assets/queries/data_scientist/ds5_reliability_ranking.sql
- skills/rmi-sql/assets/queries/data_scientist/ds6_travel_time_forecasting.sql
- skills/rmi-sql/assets/queries/data_scientist/ds7_zero_shot_forecasting.sql
- skills/rmi-sql/assets/queries/data_scientist/ds8_change_point_detection.sql
- skills/rmi-sql/assets/queries/data_scientist/ds9_corridor_trend_decomposition.sql
- skills/rmi-sql/assets/queries/rmi_planner/rmip1_usage_projection.sql
- skills/rmi-sql/assets/queries/rmi_planner/rmip2_customer_roi.sql
- skills/rmi-sql/assets/queries/rmi_planner/rmip3_segment_estimation.sql
- skills/rmi-sql/assets/queries/rmi_planner/rmip4_area_boundary.sql
- skills/rmi-sql/assets/queries/traffic_operations_manager/tom1_peak_hour_delay.sql
- skills/rmi-sql/assets/queries/traffic_operations_manager/tom2_persistent_bottlenecks.sql
- skills/rmi-sql/assets/queries/traffic_operations_manager/tom3_operational_health.sql
- skills/rmi-sql/assets/queries/traffic_operations_manager/tom4_data_latency.sql
- skills/rmi-sql/assets/queries/traffic_operations_manager/tom5_significant_event_detection.sql
- skills/rmi-sql/assets/queries/traffic_operations_manager/tom6_dynamic_detour_detection.sql
- skills/rmi-sql/assets/queries/urban_planner/up1_corridor_trend.sql
- skills/rmi-sql/assets/queries/urban_planner/up2_impact_analysis.sql
- skills/rmi-sql/assets/queries/urban_planner/up3_monitoring_density.sql
- skills/rmi-sql/assets/queries/urban_planner/up4_weekend_vs_weekday.sql
- skills/rmi-sql/assets/queries/urban_planner/up5_geofenced_congestion.sql
- skills/rmi-sql/references/standards/COLUMN_DESCRIPTIONS.md
- skills/rmi-sql/references/standards/KNOWN_LIMITATIONS.md
- skills/rmi-sql/references/standards/METRICS.md
- skills/rmi-sql/references/standards/SAMPLE_DATASET_METRICS.md
- skills/rmi-sql/scripts/eval_report.py
- skills/rmi-sql/scripts/sync_notebooks.py
Every link opens the file at its source, pinned to the revision this page describes.