Table of Contents

Search

  1. Preface
  2. Introduction to PowerExchange for Google BigQuery
  3. PowerExchange for Google BigQuery Configuration
  4. Configuring HTTP Proxy Options
  5. Google BigQuery Connections
  6. PowerExchange for Google BigQuery Data Objects
  7. PowerExchange for Google BigQuery Mappings
  8. Google BigQuery Lookup
  9. Google BigQuery Run-Time Processing
  10. Appendix A: Google BigQuery Data Type Reference

PowerExchange for Google BigQuery User Guide

PowerExchange for Google BigQuery User Guide

Parameterization for Google BigQuery Sources

Parameterization for Google BigQuery Sources

You can parameterize the Google BigQuery connection and data object read operation properties to override the mapping properties at run time.
You can parameterize the following read operation properties for a Google BigQuery source:
  • Source Dataset ID
  • Source Table name
  • Number of Rows to Read
  • Query Results Table Name
  • Job Poll Interval In Seconds
  • Read Mode
  • Number of Threads for Downloading Staging Files
  • Data format of the staging file
  • Local Stage File Directory
  • Staging File Name
  • pre SQL
  • post SQL
  • pre SQL Configuration
  • post SQL Configuration
  • SQL Override Query

0 COMMENTS

We’d like to hear from you!