Path	Lines of Code
cloudbuild.yaml	28
dashboards/geospatial/bigquery_geospatial_visualization.ipynb	986
dashboards/system_tables/sql/current_assignments.sql	34
dashboards/system_tables/sql/daily_commitments.sql	42
dashboards/system_tables/sql/daily_utilization.sql	18
dashboards/system_tables/sql/hourly_utilization.sql	20
dashboards/system_tables/sql/job_analyzer_slow.sql	121
dashboards/system_tables/sql/job_comparison_statistics.sql	24
dashboards/system_tables/sql/job_concurrency_comparison_slow.sql	174
dashboards/system_tables/sql/job_error.sql	11
dashboards/system_tables/sql/job_execution.sql	18
dashboards/system_tables/sql/reservation_utilization_month.sql	59
dashboards/system_tables/sql/reservation_utilization_week.sql	64
performance_testing/jmeter/cancel_running_jobs.py	16
performance_testing/jmeter/http_sampler_results.sql	16
performance_testing/jmeter/jdbc_sampler_results.sql	3
release/terraform/cloudbuild.yaml	12
release/terraform/main.tf	171
release/terraform/variables.tf	49
scripts/billing/sql/daily_compute_cores_average.sql	13
scripts/billing/sql/daily_compute_discount.sql	11
scripts/billing/sql/daily_compute_usage_and_costs_by_vm_shape.sql	16
scripts/billing/sql/daily_compute_usage_cud_sud_coverage.sql	123
scripts/billing/sql/daily_compute_usage_hours.sql	19
scripts/billing/sql/monthly_costs_by_project.sql	8
scripts/billing/sql/monthly_costs_credits.sql	8
scripts/billing/sql/monthly_cud_sud_savings.sql	49
scripts/billing/sql/monthly_invoice_costs_credits.sql	9
scripts/billing/sql/previous_day_costs_by_project.sql	7
scripts/billing/sql/previous_day_costs_by_service.sql	8
scripts/billing/sql/previous_month_costs_by_label.sql	16
scripts/billing/sql/previous_month_costs_by_service.sql	11
scripts/billing/sql/previous_month_costs_by_service_label.sql	20
scripts/billing/sql/total_costs_by_label_value.sql	9
scripts/billing/sql/total_costs_by_sku_label.sql	6
scripts/optimization/actively_read_tables_with_partitioning_clustering_info.sql	95
scripts/optimization/anti-pattern-recognittion-tool-scripts/anti_pattern_recoginition_tool_tables.sql	24
scripts/optimization/anti-pattern-recognittion-tool-scripts/update_queries_by_hash_w_anti_patterns.sql	6
scripts/optimization/assured_workloads_compliant/actively_read_tables_with_partitioning_clustering_info.sql	84
scripts/optimization/assured_workloads_compliant/table_read_patterns.sql	32
scripts/optimization/daily_project_analysis.sql	67
scripts/optimization/daily_reservation_analysis.sql	75
scripts/optimization/frequent_daily_table_dml.sql	26
scripts/optimization/hourly_slot_consumption_by_labels.sql	118
scripts/optimization/hourly_slot_consumption_by_query_hash.sql	119
scripts/optimization/queries_grouped_by_hash_org.sql	48
scripts/optimization/queries_grouped_by_hash_project.sql	49
scripts/optimization/queries_grouped_by_labels.sql	39
scripts/optimization/queries_grouped_by_script.sql	59
scripts/optimization/query_performance_insights.sql	27
scripts/optimization/storage_billing_model_savings_ddl.sql	116
scripts/optimization/table_read_patterns.sql	162
scripts/optimization/table_read_patterns_by_query_hash.sql	69
scripts/optimization/tables_without_partitioning_or_clustering.sql	73
scripts/optimization/viewable_queries_grouped_by_hash.sql	132
scripts/optimization/views_with_nonoptimal_join_condition.sql	46
stored_procedures/workflow_settings.yaml	1
tools/automatic_query_fixer/src/main/java/com/google/cloud/bigquery/utils/queryfixer/AutomaticQueryFixer.java	98
tools/automatic_query_fixer/src/main/java/com/google/cloud/bigquery/utils/queryfixer/BigQueryParserFactory.java	59
tools/automatic_query_fixer/src/main/java/com/google/cloud/bigquery/utils/queryfixer/QueryFixerMain.java	53
tools/automatic_query_fixer/src/main/java/com/google/cloud/bigquery/utils/queryfixer/QueryPositionConverter.java	60
tools/automatic_query_fixer/src/main/java/com/google/cloud/bigquery/utils/queryfixer/cmd/AutoModeInteraction.java	65
tools/automatic_query_fixer/src/main/java/com/google/cloud/bigquery/utils/queryfixer/cmd/CommandLineInteraction.java	87
tools/automatic_query_fixer/src/main/java/com/google/cloud/bigquery/utils/queryfixer/cmd/QueryFixerOptions.java	121
tools/automatic_query_fixer/src/main/java/com/google/cloud/bigquery/utils/queryfixer/cmd/SuggestionModeInteraction.java	25
tools/automatic_query_fixer/src/main/java/com/google/cloud/bigquery/utils/queryfixer/cmd/UserAssistedModeInteraction.java	38
tools/automatic_query_fixer/src/main/java/com/google/cloud/bigquery/utils/queryfixer/entity/FixOption.java	7
tools/automatic_query_fixer/src/main/java/com/google/cloud/bigquery/utils/queryfixer/entity/FixResult.java	61
tools/automatic_query_fixer/src/main/java/com/google/cloud/bigquery/utils/queryfixer/entity/IToken.java	16
tools/automatic_query_fixer/src/main/java/com/google/cloud/bigquery/utils/queryfixer/entity/Position.java	10
tools/automatic_query_fixer/src/main/java/com/google/cloud/bigquery/utils/queryfixer/entity/StringView.java	18
tools/automatic_query_fixer/src/main/java/com/google/cloud/bigquery/utils/queryfixer/entity/TokenImpl.java	35
tools/automatic_query_fixer/src/main/java/com/google/cloud/bigquery/utils/queryfixer/entity/ZetaSqlToken.java	77
tools/automatic_query_fixer/src/main/java/com/google/cloud/bigquery/utils/queryfixer/errors/BigQuerySemanticError.java	8
tools/automatic_query_fixer/src/main/java/com/google/cloud/bigquery/utils/queryfixer/errors/BigQuerySqlError.java	19
tools/automatic_query_fixer/src/main/java/com/google/cloud/bigquery/utils/queryfixer/errors/BigQuerySyntaxError.java	8
tools/automatic_query_fixer/src/main/java/com/google/cloud/bigquery/utils/queryfixer/errors/ColumnNotGroupedError.java	13
tools/automatic_query_fixer/src/main/java/com/google/cloud/bigquery/utils/queryfixer/errors/DuplicateColumnsError.java	11
tools/automatic_query_fixer/src/main/java/com/google/cloud/bigquery/utils/queryfixer/errors/ExpectKeywordButGotOthersError.java	14
tools/automatic_query_fixer/src/main/java/com/google/cloud/bigquery/utils/queryfixer/errors/FunctionNotFoundError.java	24
tools/automatic_query_fixer/src/main/java/com/google/cloud/bigquery/utils/queryfixer/errors/IllegalInputCharacterError.java	13
tools/automatic_query_fixer/src/main/java/com/google/cloud/bigquery/utils/queryfixer/errors/NoMatchingSignatureError.java	103
tools/automatic_query_fixer/src/main/java/com/google/cloud/bigquery/utils/queryfixer/errors/SqlErrorFactory.java	148
tools/automatic_query_fixer/src/main/java/com/google/cloud/bigquery/utils/queryfixer/errors/TableNotFoundError.java	12
tools/automatic_query_fixer/src/main/java/com/google/cloud/bigquery/utils/queryfixer/errors/UnexpectedKeywordError.java	13
tools/automatic_query_fixer/src/main/java/com/google/cloud/bigquery/utils/queryfixer/errors/UnrecognizedColumnError.java	24
tools/automatic_query_fixer/src/main/java/com/google/cloud/bigquery/utils/queryfixer/exception/ParserCreationException.java	6
tools/automatic_query_fixer/src/main/java/com/google/cloud/bigquery/utils/queryfixer/fixer/ColumnNotGroupedFixer.java	29
tools/automatic_query_fixer/src/main/java/com/google/cloud/bigquery/utils/queryfixer/fixer/DuplicateColumnsFixer.java	26
tools/automatic_query_fixer/src/main/java/com/google/cloud/bigquery/utils/queryfixer/fixer/ExpectKeywordButGotOthersFixer.java	53
tools/automatic_query_fixer/src/main/java/com/google/cloud/bigquery/utils/queryfixer/fixer/FixerFactory.java	49
tools/automatic_query_fixer/src/main/java/com/google/cloud/bigquery/utils/queryfixer/fixer/FunctionFixer.java	109
tools/automatic_query_fixer/src/main/java/com/google/cloud/bigquery/utils/queryfixer/fixer/FunctionNotFoundFixer.java	31
tools/automatic_query_fixer/src/main/java/com/google/cloud/bigquery/utils/queryfixer/fixer/IFixer.java	5
tools/automatic_query_fixer/src/main/java/com/google/cloud/bigquery/utils/queryfixer/fixer/IllegalInputCharacterFixer.java	34
tools/automatic_query_fixer/src/main/java/com/google/cloud/bigquery/utils/queryfixer/fixer/NearbyTokenFixer.java	111
tools/automatic_query_fixer/src/main/java/com/google/cloud/bigquery/utils/queryfixer/fixer/NoMatchingSignatureFixer.java	99
tools/automatic_query_fixer/src/main/java/com/google/cloud/bigquery/utils/queryfixer/fixer/TableNotFoundFixer.java	105
tools/automatic_query_fixer/src/main/java/com/google/cloud/bigquery/utils/queryfixer/fixer/TypeCast.java	55
tools/automatic_query_fixer/src/main/java/com/google/cloud/bigquery/utils/queryfixer/fixer/UnexpectedKeywordFixer.java	31
tools/automatic_query_fixer/src/main/java/com/google/cloud/bigquery/utils/queryfixer/fixer/UnrecognizedColumnFixer.java	31
tools/automatic_query_fixer/src/main/java/com/google/cloud/bigquery/utils/queryfixer/service/BigQueryService.java	42
tools/automatic_query_fixer/src/main/java/com/google/cloud/bigquery/utils/queryfixer/tokenizer/CalciteTokenizer.java	25
tools/automatic_query_fixer/src/main/java/com/google/cloud/bigquery/utils/queryfixer/tokenizer/QueryTokenProcessor.java	47
tools/automatic_query_fixer/src/main/java/com/google/cloud/bigquery/utils/queryfixer/tokenizer/Tokenizer.java	6
tools/automatic_query_fixer/src/main/java/com/google/cloud/bigquery/utils/queryfixer/tokenizer/ZetaSqlTokenizer.java	17
tools/automatic_query_fixer/src/main/java/com/google/cloud/bigquery/utils/queryfixer/util/ByteOffsetTranslator.java	42
tools/automatic_query_fixer/src/main/java/com/google/cloud/bigquery/utils/queryfixer/util/PatternMatcher.java	49
tools/automatic_query_fixer/src/main/java/com/google/cloud/bigquery/utils/queryfixer/util/StringUtil.java	87
tools/cloud_functions/bq_table_snapshots/bq_backup_create_snapshots/main.py	56
tools/cloud_functions/bq_table_snapshots/bq_backup_fetch_tables_names/main.py	40
tools/cloud_functions/bq_table_snapshots/terraform/backend.tf	6
tools/cloud_functions/bq_table_snapshots/terraform/function.tf	88
tools/cloud_functions/bq_table_snapshots/terraform/main.tf	4
tools/cloud_functions/bq_table_snapshots/terraform/terraform.tfvars	6
tools/cloud_functions/bq_table_snapshots/terraform/variables.tf	38
tools/cloud_functions/gcs_event_based_ingest/__init__.py	1
tools/cloud_functions/gcs_event_based_ingest/backfill.py	126
tools/cloud_functions/gcs_event_based_ingest/cloudbuild.yaml	137
tools/cloud_functions/gcs_event_based_ingest/gcs_ocn_bq_ingest/__init__.py	1
tools/cloud_functions/gcs_event_based_ingest/gcs_ocn_bq_ingest/common/__init__.py	1
tools/cloud_functions/gcs_event_based_ingest/gcs_ocn_bq_ingest/common/constants.py	75
tools/cloud_functions/gcs_event_based_ingest/gcs_ocn_bq_ingest/common/exceptions.py	15
tools/cloud_functions/gcs_event_based_ingest/gcs_ocn_bq_ingest/common/logging.py	49
tools/cloud_functions/gcs_event_based_ingest/gcs_ocn_bq_ingest/common/ordering.py	320
tools/cloud_functions/gcs_event_based_ingest/gcs_ocn_bq_ingest/common/utils.py	676
tools/cloud_functions/gcs_event_based_ingest/gcs_ocn_bq_ingest/main.py	127
tools/cloud_functions/gcs_event_based_ingest/terraform_module/gcs_ocn_bq_ingest_function/main.tf	110
tools/cloud_functions/gcs_event_based_ingest/terraform_module/gcs_ocn_bq_ingest_function/outputs.tf	11
tools/cloud_functions/gcs_event_based_ingest/terraform_module/gcs_ocn_bq_ingest_function/variables.tf	50
tools/cloud_functions/gcs_event_based_ingest/terraform_module/gcs_ocn_bq_ingest_function/versions.tf	23
tools/custom_java_jdbc_client/src/main/java/com/example/BQSimbaExample.java	65
tools/custom_java_jdbc_client/src/main/java/com/example/OAuthUserConfig.java	95
tools/custom_java_jdbc_client/src/main/java/com/example/OAuthUserType.java	12
tools/legacy_sql_tranlsation_helper/patternScan.py	98
tools/legacy_sql_tranlsation_helper/readSQLToString.py	7
tools/legacy_sql_tranlsation_helper/sample_sql/sample1.sql	8
tools/legacy_sql_tranlsation_helper/sample_sql/sample2.sql	2
tools/legacy_sql_tranlsation_helper/sample_sql/sample3.sql	6
tools/legacy_sql_tranlsation_helper/sample_sql/sample4.sql	7
tools/legacy_sql_tranlsation_helper/translatorCommaJoin.py	110
tools/protobuf_export/Main.java	44
tools/protobuf_export/index.js	49
tools/protobuf_export/main.go	68
tools/protobuf_export/main.py	14
tools/protobuf_export/protos/dummy.proto	5
tools/query_breakdown/src/main/java/com/google/bigquery/CalciteParser.java	29
tools/query_breakdown/src/main/java/com/google/bigquery/InputReader.java	106
tools/query_breakdown/src/main/java/com/google/bigquery/LocationTracker.java	113
tools/query_breakdown/src/main/java/com/google/bigquery/Main.java	163
tools/query_breakdown/src/main/java/com/google/bigquery/Node.java	80
tools/query_breakdown/src/main/java/com/google/bigquery/Pair.java	26
tools/query_breakdown/src/main/java/com/google/bigquery/Parser.java	4
tools/query_breakdown/src/main/java/com/google/bigquery/QueryBreakdown.java	189
tools/query_breakdown/src/main/java/com/google/bigquery/ReplacedComponent.java	37
tools/query_breakdown/src/main/java/com/google/bigquery/ReplacementLogic.java	35
tools/query_verification/src/main/java/com/google/bigquery/BigQueryManager.java	251
tools/query_verification/src/main/java/com/google/bigquery/BigQuerySchemaJsonDeserializer.java	29
tools/query_verification/src/main/java/com/google/bigquery/DataWarehouseManager.java	6
tools/query_verification/src/main/java/com/google/bigquery/Main.java	138
tools/query_verification/src/main/java/com/google/bigquery/QueryErrors.java	13
tools/query_verification/src/main/java/com/google/bigquery/QueryJobResults.java	16
tools/query_verification/src/main/java/com/google/bigquery/QueryVerificationData.java	12
tools/query_verification/src/main/java/com/google/bigquery/QueryVerificationQuery.java	10
tools/query_verification/src/main/java/com/google/bigquery/QueryVerificationSchema.java	26
tools/query_verification/src/main/java/com/google/bigquery/QueryVerifier.java	160
tools/query_verification/src/main/java/com/google/bigquery/ResultDifferences.java	11
tools/query_verification/src/main/java/com/google/bigquery/TeradataManager.java	247
tools/sql_extraction/build.gradle.kts	86
tools/sql_extraction/settings.gradle.kts	1
tools/sql_extraction/src/main/kotlin/Cli.kt	104
tools/sql_extraction/src/main/kotlin/ConfidenceRater.kt	92
tools/sql_extraction/src/main/kotlin/DataFlowEngine.kt	156
tools/sql_extraction/src/main/kotlin/DataFlowSolver.kt	22
tools/sql_extraction/src/main/kotlin/Environment.kt	62
tools/sql_extraction/src/main/kotlin/FilesExpander.kt	31
tools/sql_extraction/src/main/kotlin/FrontEnd.kt	12
tools/sql_extraction/src/main/kotlin/JavaAnalyzer.kt	143
tools/sql_extraction/src/main/kotlin/JavaFrontEnd.kt	21
tools/sql_extraction/src/main/kotlin/PythonAnalyzer.kt	140
tools/sql_extraction/src/main/kotlin/PythonFrontEnd.kt	21
tools/sql_extraction/src/main/kotlin/SqlExtractor.kt	95
tools/sql_extraction/src/main/kotlin/output/Location.kt	36
tools/sql_extraction/src/main/kotlin/output/Output.kt	2
tools/sql_extraction/src/main/kotlin/output/Query.kt	12
tools/sql_extraction/src/main/kotlin/output/QueryFragment.kt	64
tools/template_based_query_generation/src/main/java/QueryGenerator.java	132
tools/template_based_query_generation/src/main/java/data/DataType.java	42
tools/template_based_query_generation/src/main/java/data/Table.java	114
tools/template_based_query_generation/src/main/java/graph/MarkovChain.java	27
tools/template_based_query_generation/src/main/java/graph/Node.java	63
tools/template_based_query_generation/src/main/java/parser/DataTypeMap.java	19
tools/template_based_query_generation/src/main/java/parser/DataTypeMaps.java	11
tools/template_based_query_generation/src/main/java/parser/Dependencies.java	11
tools/template_based_query_generation/src/main/java/parser/Dependency.java	18
tools/template_based_query_generation/src/main/java/parser/DialectMap.java	17
tools/template_based_query_generation/src/main/java/parser/Feature.java	18
tools/template_based_query_generation/src/main/java/parser/FeatureIndicator.java	17
tools/template_based_query_generation/src/main/java/parser/FeatureIndicators.java	11
tools/template_based_query_generation/src/main/java/parser/Features.java	11
tools/template_based_query_generation/src/main/java/parser/Keywords.java	39
tools/template_based_query_generation/src/main/java/parser/KeywordsMapping.java	49
tools/template_based_query_generation/src/main/java/parser/RegexMap.java	11
tools/template_based_query_generation/src/main/java/parser/User.java	54
tools/template_based_query_generation/src/main/java/parser/Utils.java	282
tools/template_based_query_generation/src/main/java/query/SkeletonPiece.java	27
tools/template_based_query_generation/src/main/java/token/QueryRegex.java	99
tools/template_based_query_generation/src/main/java/token/TokenProvider.java	167
tools/unsupervised_dataset/run_crawler.py	22
tools/unsupervised_dataset/sql_classifier/classifier/src/main/java/Classifier.java	110
tools/unsupervised_dataset/sql_crawler/__init__.py	1
tools/unsupervised_dataset/sql_crawler/cloud_integration.py	48
tools/unsupervised_dataset/sql_crawler/cq_node.py	8
tools/unsupervised_dataset/sql_crawler/crawler.py	53
tools/unsupervised_dataset/sql_crawler/crawler_log.py	77
tools/unsupervised_dataset/sql_crawler/extraction_modules/__init__.py	1
tools/unsupervised_dataset/sql_crawler/extraction_modules/extraction_module_1.py	9
tools/unsupervised_dataset/sql_crawler/extraction_modules/extraction_module_2.py	13
tools/unsupervised_dataset/sql_crawler/extraction_modules/extraction_module_3.py	9
tools/unsupervised_dataset/sql_crawler/extraction_modules/extraction_module_4.py	14
tools/unsupervised_dataset/sql_crawler/extraction_modules/generic_extraction_module.py	10
tools/unsupervised_dataset/sql_crawler/extraction_modules/google_extraction_module.py	12
tools/unsupervised_dataset/sql_crawler/extraction_modules/sql_file_extraction_module.py	9
tools/unsupervised_dataset/sql_crawler/extractor.py	34
tools/vscode_automatic_query_fixer/copy_binaries.js	31
tools/vscode_automatic_query_fixer/src/auto_fixer_result.ts	15
tools/vscode_automatic_query_fixer/src/auto_fixer_runner.ts	77
tools/vscode_automatic_query_fixer/src/code_action_provider.ts	77
tools/vscode_automatic_query_fixer/src/extension.ts	66
tools/vscode_query_breakdown/src/extension.ts	109
tools/vscode_query_breakdown/src/query_breakdown_runner.ts	44
tools/vscode_query_breakdown/src/resultJson.ts	14
tools/vscode_sql_extraction/copy_binaries.js	33
tools/vscode_sql_extraction/src/extension.ts	52
tools/vscode_sql_extraction/src/highlighter.ts	66
tools/vscode_sql_extraction/src/query.ts	55
tools/vscode_sql_extraction/src/sql_extraction_runner.ts	73
tools/vscode_sql_extraction/src/tree_view.ts	152
tools/zetasql_helper/java/com/google/bigquery/utils/zetasqlhelper/Client.java	24
tools/zetasql_helper/java/com/google/bigquery/utils/zetasqlhelper/LocalServiceDockerProvider.java	95
tools/zetasql_helper/java/com/google/bigquery/utils/zetasqlhelper/LocalServiceException.java	9
tools/zetasql_helper/java/com/google/bigquery/utils/zetasqlhelper/LocalServiceProvider.java	14
tools/zetasql_helper/java/com/google/bigquery/utils/zetasqlhelper/Main.java	14
tools/zetasql_helper/java/com/google/bigquery/utils/zetasqlhelper/QueryFunctionRange.java	20
tools/zetasql_helper/java/com/google/bigquery/utils/zetasqlhelper/QueryLocationRange.java	24
tools/zetasql_helper/java/com/google/bigquery/utils/zetasqlhelper/Token.java	40
tools/zetasql_helper/java/com/google/bigquery/utils/zetasqlhelper/ZetaSqlHelper.java	63
tools/zetasql_helper/zetasql_helper/fixer/fix_column_not_grouped.cc	100
tools/zetasql_helper/zetasql_helper/fixer/fix_column_not_grouped.h	21
tools/zetasql_helper/zetasql_helper/fixer/fix_duplicate_columns.cc	106
tools/zetasql_helper/zetasql_helper/fixer/fix_duplicate_columns.h	20
tools/zetasql_helper/zetasql_helper/local_service/local_service.cc	78
tools/zetasql_helper/zetasql_helper/local_service/local_service.h	25
tools/zetasql_helper/zetasql_helper/local_service/local_service.proto	89
tools/zetasql_helper/zetasql_helper/local_service/local_service_grpc.cc	75
tools/zetasql_helper/zetasql_helper/local_service/local_service_grpc.h	27
tools/zetasql_helper/zetasql_helper/local_service/run_server.cc	21
tools/zetasql_helper/zetasql_helper/scanner/extract_function.cc	52
tools/zetasql_helper/zetasql_helper/scanner/extract_function.h	19
tools/zetasql_helper/zetasql_helper/scanner/function_range.proto	24
tools/zetasql_helper/zetasql_helper/scanner/locate_table.cc	28
tools/zetasql_helper/zetasql_helper/scanner/locate_table.h	12
tools/zetasql_helper/zetasql_helper/token/parse_token.proto	34
tools/zetasql_helper/zetasql_helper/token/token.cc	39
tools/zetasql_helper/zetasql_helper/token/token.h	12
tools/zetasql_helper/zetasql_helper/util/util.cc	38
tools/zetasql_helper/zetasql_helper/util/util.h	49
udfs/cloudbuild.yaml	56
udfs/datasketches/cloudbuild.yaml	16
udfs/deploy.yaml	16
udfs/dir_to_dataset_map.yaml	8
udfs/js_libs/js_libs.yaml	19
views/audit/bigquery_audit_logs_v1.sql	166
views/audit/bigquery_audit_logs_v2.sql	841
views/audit/bigquery_script_logs_v2.sql	578
views/audit/query_audit.sql	114
views/migration/teradata/sys_calendar.sql	36