Table of Contents

Search

  1. Preface
  2. Understanding Pipeline Partitioning
  3. Partition Points
  4. Partition Types
  5. Pushdown Optimization
  6. Pushdown Optimization and Transformations
  7. Real-time Processing
  8. Commit Points
  9. Row Error Logging
  10. Workflow Recovery
  11. Stopping and Aborting
  12. Concurrent Workflows
  13. Grid Processing
  14. Load Balancer
  15. Workflow Variables
  16. Parameters and Variables in Sessions
  17. Parameter Files
  18. FastExport
  19. External Loading
  20. FTP
  21. Session Caches
  22. Incremental Aggregation
  23. Session Log Interface
  24. Understanding Buffer Memory
  25. High Precision Data

Advanced Workflow Guide

Advanced Workflow Guide

Google BigQuery Function Exceptions

Google BigQuery Function Exceptions

Use the following rules and guidelines when you push functions to a Google BigQuery database:
  • To push the ADD_TO_DATE() function to the Google BigQuery database, you must define the arguments of the Date data type.
  • To push the GET_DATE_PART() function to the Google BigQuery database, you must define the arguments of the Date, DateTime, or Timestamp data type.
  • To push the INSTR() function to the Google BigQuery database, you must use the following format:
    INSTR(string, search_value)
  • To push the IS_DATE() or LAST_DAY() function to the Google BigQuery database, you must define the arguments of the Date data type.
  • To push the function to the Google BigQuery database, you must define the arguments of the Date data type.
  • To push the MAX() function to the Google BigQuery database, you must define the arguments of the Number data type.
  • To push the MIN() function to the Google BigQuery database, you must define the arguments of the Date, Number, or String data type.
  • To push the ROUND(DATE) function to the Google BigQuery database, you must define the arguments of the Timestamp data type in the following format:
    • D
    • DD
    • DDD
    • DY
    • HH
    • HH24
    • MI
    • SS
    • MS
  • To push the TRUNC(DATE) function to the Google BigQuery database, you must define the arguments of the Timestamp data type in the following format:
    • Y
    • YY
    • YYY
    • YYYY
    • MM
    • MON
    • D
    • DD
    • DDD
    • DY
    • HH
    • HH24
    • MI
    • SS
    • MS
    • US
  • To push the TO_CHAR(DATE) function to the Google BigQuery database, you must define the arguments of the Timestamp data type in the following format:
    • YYYY
    • MM
    • DD
    • HH24
    • MI
    • US
    • -
    • /
    • .
    • ;
    • :
    • "text"
  • When you define arguments of the Timestamp data type in the TO_DATE() function, you must use the following format:
    • YYYY
    • MM
    • DD
    • HH24
    • MI
    • SS
    • MS
    • US
    • -
    • /
    • .
    • ;
    • :
  • When you define arguments of the Timestamp data type in the GET_DATE_PART() function, you must use the following format:
    • Y
    • YY
    • YYY
    • YYYY
    • MM
    • MON
    • D
    • DD
    • DDD
    • DY
    • HH
    • HH24
    • MI
    • SS
    • MS
    • US
  • When you push the TO_DATE() function to the Google BigQuery database, you must map the output to a Timestamp column in the Google BigQuery table.
  • When you push the SYSTIMESTAMP() function to the Google BigQuery database, do not specify any format. The Google BigQuery database returns the complete timestamp.


Updated May 02, 2021