-
Notifications
You must be signed in to change notification settings - Fork 86
Expand file tree
/
Copy pathBigQueryToMultipleSinks.feature
More file actions
53 lines (52 loc) · 2.9 KB
/
BigQueryToMultipleSinks.feature
File metadata and controls
53 lines (52 loc) · 2.9 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
@BigQuery_Source
Feature: BigQuery source - Verification of BigQuery to Multiple sinks successful data transfer
@CMEK @BQ_SOURCE_TEST @GCS_SINK_TEST @BQ_SINK_TEST @PUBSUB_SINK_TEST
Scenario:Validate successful records transfer from BigQuery to multiple sinks (GCS, BigQuery and PubSub)
Given Open Datafusion Project to configure pipeline
When Source is BigQuery
When Sink is GCS
Then Connect source as "BigQuery" having title "BigQuery" and sink1 as "GCS" having title "GCS" to establish connection
When Sink is BigQuery
Then Connect source as "BigQuery" having title "BigQuery" and sink2 as "BigQuery" having title "BigQuery2" to establish connection
When Sink is PubSub
Then Connect source as "BigQuery" having title "BigQuery" and sink3 as "GooglePublisher" having title "Pub/Sub" to establish connection
Then Open BigQuery source properties
Then Override Service account details if set in environment variables
Then Enter the BigQuery source mandatory properties
Then Validate "BigQuery" plugin properties
Then Close the BigQuery properties
Then Open GCS sink properties
Then Override Service account details if set in environment variables
Then Enter the GCS sink mandatory properties
Then Enter GCS property encryption key name "cmekGCS" if cmek is enabled
Then Validate "GCS" plugin properties
Then Close the GCS properties
Then Open BigQuery sink properties
Then Override Service account details if set in environment variables
Then Enter the BigQuery sink mandatory properties
Then Enter BiqQuery property encryption key name "cmekBQ" if cmek is enabled
Then Validate "BigQuery" plugin properties
Then Close the BigQuery properties
Then Open the PubSub sink properties
Then Override Service account details if set in environment variables
Then Enter the PubSub sink mandatory properties
Then Enter PubSub sink property encryption key name "cmekPubSub" if cmek is enabled
Then Validate "PubSub" plugin properties
Then Close the PubSub properties
Then Save the pipeline
Then Preview and run the pipeline
Then Wait till pipeline preview is in running state
Then Open and capture pipeline preview logs
Then Verify the preview run status of pipeline in the logs is "succeeded"
Then Close the pipeline logs
Then Close the preview
Then Deploy the pipeline
Then Run the Pipeline in Runtime
Then Wait till pipeline is in running state
Then Open and capture logs
Then Verify the pipeline status is "Succeeded"
Then Verify data is transferred to target GCS bucket
Then Get count of no of records transferred to target BigQuery Table
Then Validate the cmek key "cmekGCS" of target GCS bucket if cmek is enabled
Then Validate the cmek key "cmekBQ" of target BigQuery table if cmek is enabled
Then Validate the cmek key "cmekPubSub" of target PubSub topic if cmek is enabled