Source code for tests.system.google.cloud.bigquery.example_bigquery_operations
## Licensed to the Apache Software Foundation (ASF) under one# or more contributor license agreements. See the NOTICE file# distributed with this work for additional information# regarding copyright ownership. The ASF licenses this file# to you under the Apache License, Version 2.0 (the# "License"); you may not use this file except in compliance# with the License. You may obtain a copy of the License at## http://www.apache.org/licenses/LICENSE-2.0## Unless required by applicable law or agreed to in writing,# software distributed under the License is distributed on an# "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY# KIND, either express or implied. See the License for the# specific language governing permissions and limitations# under the License."""Example Airflow DAG for Google BigQuery service local file upload and external table creation."""from__future__importannotationsimportosfromdatetimeimportdatetimefrompathlibimportPathfromairflow.models.dagimportDAGfromairflow.providers.google.cloud.operators.bigqueryimport(BigQueryCreateEmptyDatasetOperator,BigQueryCreateTableOperator,BigQueryDeleteDatasetOperator,)fromairflow.providers.google.cloud.operators.gcsimportGCSCreateBucketOperator,GCSDeleteBucketOperatorfromairflow.providers.google.cloud.transfers.local_to_gcsimportLocalFilesystemToGCSOperatorfromairflow.utils.trigger_ruleimportTriggerRulefromsystem.openlineage.operatorimportOpenLineageTestOperator
create_dataset=BigQueryCreateEmptyDatasetOperator(task_id="create_dataset",dataset_id=DATASET_NAME)create_dataset_with_location=BigQueryCreateEmptyDatasetOperator(task_id="create_dataset_with_location",dataset_id=DATASET_NAME+"_loc",location=BQ_LOCATION,)upload_file=LocalFilesystemToGCSOperator(task_id="upload_file_to_bucket",src=CSV_FILE_LOCAL_PATH,dst=DATA_SAMPLE_GCS_OBJECT_NAME,bucket=DATA_SAMPLE_GCS_BUCKET_NAME,)create_table=BigQueryCreateTableOperator(task_id="create_table",dataset_id=DATASET_NAME,table_id="external_table",table_resource={"externalDataConfiguration":{"sourceFormat":"CSV","sourceUris":[f"gs://{DATA_SAMPLE_GCS_BUCKET_NAME}/{DATA_SAMPLE_GCS_OBJECT_NAME}"],"csvOptions":{"skipLeadingRows":1,},},"schema":{"fields":[{"name":"emp_name","type":"STRING","mode":"REQUIRED"},{"name":"salary","type":"INTEGER","mode":"NULLABLE"},]},},)create_table_with_location=BigQueryCreateTableOperator(task_id="create_table_with_location",dataset_id=DATASET_NAME+"_loc",table_id="external_table_with_location",table_resource={"externalDataConfiguration":{"sourceFormat":"CSV","sourceUris":[f"gs://{DATA_SAMPLE_GCS_BUCKET_NAME}/{DATA_SAMPLE_GCS_OBJECT_NAME}"],"csvOptions":{"skipLeadingRows":1,},},"schema":{"fields":[{"name":"emp_name","type":"STRING","mode":"REQUIRED"},{"name":"salary","type":"INTEGER","mode":"NULLABLE"},]},},)delete_dataset=BigQueryDeleteDatasetOperator(task_id="delete_dataset",dataset_id=DATASET_NAME,delete_contents=True,trigger_rule=TriggerRule.ALL_DONE,)delete_dataset_with_location=BigQueryDeleteDatasetOperator(task_id="delete_dataset_with_location",dataset_id=DATASET_NAME+"_loc",delete_contents=True,trigger_rule=TriggerRule.ALL_DONE,)delete_bucket=GCSDeleteBucketOperator(task_id="delete_bucket",bucket_name=DATA_SAMPLE_GCS_BUCKET_NAME,trigger_rule=TriggerRule.ALL_DONE)check_openlineage_events=OpenLineageTestOperator(task_id="check_openlineage_events",file_path=str(Path(__file__).parent/"resources"/"openlineage"/"bigquery_operations.json"),)(# TEST SETUP[create_bucket,create_dataset,create_dataset_with_location]# TEST BODY>>upload_file>>[create_table,create_table_with_location]# TEST TEARDOWN>>delete_bucket>>[delete_dataset,delete_dataset_with_location]>>check_openlineage_events)fromtests_common.test_utils.watcherimportwatcher# This test needs watcher in order to properly mark success/failure# when "tearDown" task with trigger rule is part of the DAGlist(dag.tasks)>>watcher()fromtests_common.test_utils.system_testsimportget_test_run# noqa: E402# Needed to run the example DAG with pytest (see: tests/system/README.md#run_via_pytest)