google-cloud/src/e2e-test/features/bigquery/source/BigQuerySourceError.feature at be1e5b67a1d7fc27fe1e8a10133739d27d0aff69 · data-integrations/google-cloud · GitHub

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
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
@BigQuery_Source
Feature: BigQuery source - Validate BigQuery source plugin error scenarios

  Scenario Outline:Verify BigQuery Source properties validation errors for mandatory fields
    Given Open Datafusion Project to configure pipeline
    When Source is BigQuery
    Then Open BigQuery source properties
    Then Enter the BigQuery properties with blank property "<property>"
    Then Validate mandatory property error for "<property>"
    Examples:
      | property      |
      | dataset       |
      | table         |

  @BQ_SOURCE_TEST
  Scenario Outline:Verify BigQuery Source properties validation errors for incorrect values
    Given Open Datafusion Project to configure pipeline
    When Source is BigQuery
    Then Open BigQuery source properties
    Then Enter BigQuery property reference name
    Then Override Service account details if set in environment variables
    Then Enter the BigQuery source properties with incorrect property "<property>" value "<value>"
    Then Validate BigQuery source incorrect property error for table "<property>" value "<value>"
    Examples:
      | property       | value                       |
      | dataset        | bqIncorrectDataset          |
      | table          | bqIncorrectTableName        |
      | datasetProject | bqIncorrectDatasetProjectId |

  Scenario Outline:Verify BigQuery Source properties validation errors for incorrect format of projectIds
    Given Open Datafusion Project to configure pipeline
    When Source is BigQuery
    Then Open BigQuery source properties
    Then Enter BigQuery property reference name
    Then Enter BigQuery property projectId "<ProjectID>"
    Then Enter BigQuery property datasetProjectId "<DatasetProjectID>"
    Then Enter BigQuery property dataset "dataset"
    Then Enter BigQuery source property table name
    Then Verify plugin properties validation fails with 1 error
    Examples:
      | ProjectID                  | DatasetProjectID                  |
      | bqIncorrectFormatProjectId | projectId                         |
      | projectId                  | bqIncorrectFormatDatasetProjectId |

  @BQ_SOURCE_TEST
  Scenario:Verify BigQuery Source properties validation errors for incorrect value of temporary bucket name
    Given Open Datafusion Project to configure pipeline
    When Source is BigQuery
    Then Open BigQuery source properties
    Then Enter BigQuery property reference name
    Then Enter BigQuery property projectId "projectId"
    Then Enter BigQuery property datasetProjectId "projectId"
    Then Override Service account details if set in environment variables
    Then Enter BigQuery property dataset "dataset"
    Then Enter BigQuery source property table name
    Then Enter BigQuery property temporary bucket name "bqInvalidTemporaryBucket"
    Then Verify the BigQuery validation error message for invalid property "bucket"

  @BQ_SOURCE_TEST
  Scenario:To verify error message when unsupported format is provided in Partition Start date and Partition end Date
    Given Open Datafusion Project to configure pipeline
    When Expand Plugin group in the LHS plugins list: "Source"
    When Select plugin: "BigQuery" from the plugins list as: "Source"
    Then Navigate to the properties page of plugin: "BigQuery"
    Then Replace input plugin property: "project" with value: "projectId"
    And Enter input plugin property: "referenceName" with value: "bqInvalidReferenceName"
    Then Replace input plugin property: "dataset" with value: "dataset"
    Then Replace input plugin property: "table" with value: "bqSourceTable"
    And Enter input plugin property: "partitionFrom" with value: "bqIncorrectFormatStartDate"
    And Enter input plugin property: "partitionTo" with value: "bqIncorrectFormatEndDate"
    Then Click on the Get Schema button
    And Click on the Validate button
    Then Verify that the Plugin Property: "referenceName" is displaying an in-line error message: "errorMessageIncorrectReferenceName"
    Then Verify that the Plugin Property: "partitionFrom" is displaying an in-line error message: "errorMessageIncorrectPartitionStartDate"
    Then Verify that the Plugin Property: "partitionTo" is displaying an in-line error message: "errorMessageIncorrectPartitionEndDate"