JR62253: GCS CONNECTOR TO SUPPORT LOADING INTO BIGQUERY TABLE.

APAR status

• Closed as new function.

Error description

• Support loading BigQuery table from Google Cloud Storage file
  using GCS connector.
  

Local fix

• N/A
  

Problem summary

• GCS connector to support loading into BigQuery table
  

Problem conclusion

• Google Cloud Storage Connector loads data from the GCS file
  written to the specified Big Query table.
  
  The following new properties are added to the connector in
  the target context.
  
   1. Load data to BigQuery table - Default is No, when this is
  selected, then the below additional properties are required.
   2. Table action - Append / Replace.
  
       Append - Creates and loads data into BigQuery table
      if table doesn't exist. If table already exists, it appends
  the data from the GCS file to the table.
  
      Replace - Drops the existing table, creates a new BigQuery
      table and loads the data from file into the table.
  
    3. Schema name - Provide the BigQuery schema/dataset name.
    4. Table name - Provide the table name where the data needs
       to be loaded.
  
  Note: This feature is supported only for CSV, Avro, Parquet and
  ORC file formats.
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

• Fixed component name

  WIS DATASTAGE

• Fixed component ID

  5724Q36DS

Applicable component levels