XDM Logo XDM User Manual

Content

    • Introduction to XDM
    • Accessibility
    • What’s New in XDM
    • Changelog
      • Changelog
      • Epic Overview
      • Road Map
    • Setup
      • Installation and Planning
        • Planning a Proof of Concept
        • Requirements
        • Data Security Recommendations
        • License Packages
      • Installation
      • Installation on Kubernetes
      • Installation Verification
      • Configuration
      • Update
      • Upgrade Postgres
      • Backup and Restore
      • Maintenance
      • Jenkins integration
      • Upgrade mapping table container
    • Tutorial
      • Introduction
      • Sample Environment
      • Infrastructure Objects
      • Native Table Copy Tasks
      • Modification Sets and Modification Methods
      • Application Models and Environments
      • Row Level Processing Tasks
      • Using Custom Parameters
      • Data Shop
      • Row Level Delete Tasks
      • Stage Hooks
      • Advanced Tutorial
        • Complex Data Shop
        • Test Data Finder
        • Data Generation
    • Working With XDM
      • Introduction
        • What is XDM ?
        • Concept of Task Templates and Tasks
        • Overview of Rules in XDM
      • XDM Clients
        • User Interface
          • Introduction
          • Connecting
          • General Parts
          • Keyboard Accessibility
          • Context Menu
          • Control Elements
          • Global Search
          • Tags
          • User Settings
          • System Settings
          • Data Shop Purchaser Layout
          • Configure Data Shop Layout
        • Jenkins Integration
        • Public REST API
        • Transfer Tool
      • Administrative Concepts
        • Roles and Permissions
        • Examples for Role Management
        • Scheduling Tasks
        • History Function
        • Export/Import of Configuration
        • Maintenance Mode
      • Processing Subsets
        • Environments and Application Models
        • Data Selection and Data Reduction
        • Inserting Data into the Target
        • Automatic test data reservation
        • Test data finder and classification terms
      • Copying Full Tables
        • Table Selection
        • Comparing and Generating Database Objects
        • Data Reduction
        • Extracting, Data Transport and Loading
      • Comparing Structures
        • Object selection
        • Cross database system DDL generation
      • Using Icebox
        • Choosing a Generation
        • Using the Structure Icebox
      • Mask and Modify Data
        • Introduction to Masking
        • Using Modification in Tasks
        • XDM Data Orchestration : Anonymization
      • Synthetic Data Generation
        • Overview
        • Data Generation
        • File Sink Templates
      • Data Shop
      • Workflows
      • Hooks
      • Data Preview
    • Object Reference
      • Task Executions
        • Executed Task
        • Requested Data Shop Order
        • Scheduled Task
      • Tasks
        • Data Shop
          • Attribute Comparison
          • Attribute Comparison Filter
        • Task Template
          • Row Level Processing
            • Row Level Delete
            • Row Level From Icebox
            • Row Level Processor
            • Row Level To Icebox
            • Webservice Copy
            • Entity Copy
          • Table Copy
            • Compatibility Table Copy
            • Compatibility Table From Icebox
            • Compatibility Table To Icebox
            • Native Table Copy
            • Native Table From Icebox
            • Native Table To Icebox
          • Database Clone
            • Db2 LUW Database Clone
            • MS SQL Server Database Clone
            • PostgreSQL Database Clone
          • Analyse
            • PII Finder
            • Structure Compare
            • Structure Compare With Icebox
            • Structure To Icebox
            • Test Data Indexing
            • Webservice Indexing
          • Generation
            • Generation
          • Task
          • Rules
            • Column Exclude Rule
            • Column Property Rule
            • Column Specification Rule
            • Exclude Rule
            • Extract Data Rule
            • Icebox Generation
            • Ignore Difference Rule
            • Mapping Rule
            • Path Mapping Rule
            • Reduction Rule
            • Selection Rule
          • Others
            • Execution Default Permission
            • Task Stage Hook Usage
            • User Defined Primary Key
        • Task Stage Hook
        • Workflow Template
          • Workflow
      • Infrastructure
        • Connection
          • Db2 for iSeries
          • Db2 LUW
          • Db2 z/OS
          • File Bridge
          • Generic JDBC
          • Google Big Query
          • IMS
          • Oracle
          • PostgreSQL
          • Snowflake
          • SQL Server
          • Rules
            • Column Property Rule
            • Exclude Rule
            • Reduction Rule
        • Credential
        • Storage Location
        • Kafka Topic
      • Data Subsets
        • Application Model
          • Version
            • Table Relation Modelling
              • Data Apply Rule
              • Data Relation Rule
            • Test Data Classification
              • Attribute
              • Classification Term Relation
              • Classification Term Usage
            • Rules
              • Column Exclude Rule
              • Column Specification Rule
              • Reduction Rule
            • Others
              • User Defined Primary Key
        • Classification Term
        • Data Reservation
          • Data Reservation Entry
        • Domain Model
          • Domain Entity
            • Domain Attribute
            • Entity Modification Rule
        • Environment
          • Installed Application
        • Webservice
      • Masking
        • Entity Modification Method
        • Mapping Table Container
        • Matcher
        • Modification Method
        • Modification Set
          • Modification Rule
        • Lookup Tables
      • Generation
        • Attribute Generator
        • Entity Generator
        • Entity Scenario Generator
        • File Scenario
          • File Operator
      • Configuration
        • Announcement
        • Custom Parameter
        • Event
          • Event Execution Log
        • File
        • Tag
        • Task Execution Reports
      • Administrative
        • Custom Default Value
        • Stores
          • Entity
        • History entries
        • Permission Recipient
          • Default Permission
          • List Permission
          • Object Permission
        • User
          • User Default Permissions
      • Task Execution Reference
        • Introduction to the batch programs
        • Collect
        • Collect Identity Column
        • Command
        • Compare Evaluator
        • Container Merger
        • Database CLI Executor
        • Database Support
        • Data Extractor
        • Data Indexer
        • Data Loader
        • Data Miner
        • DDL Generator
        • Direct Apply
        • Data Relation Rule Reducer
        • Dummy Status Task
        • Enhanced Record
        • Extended FTP
        • Extended SCP
        • Extended SSH Exec
        • Extract
        • Generation
        • Host Task
        • Icebox Object Selector
        • Index Writer
        • JDBC Clone Functor
        • Multi Object Container Repairer
        • Multi Source Object Selector
        • Object Comparer
        • Object Container Selector
        • Object Filter
        • Object Selector
        • Report Consolidator
        • SQL Executor
        • State Checker
        • Status File Primer
        • Structure Compare Evaluator
        • Subset Apply
        • Subset Compare Evaluator
        • Table Backup Task Path Builder
        • Table Restore Task Path Builder
        • Tailor Engine
        • Types mappings
          • Db2 for i
          • Db2 LUW
          • Db2 z/OS
          • BigQuery
          • FileBridge
          • Generic JDBC
          • IMS
          • Oracle
          • PostgreSQL
          • Snowflake
          • SQL Server
        • User Defined Key Adder
        • Validation Query Task
      • Properties
        • Syntax for time periods
        • Syntax for timestamp
      • Task Reports
    • Script Reference
      • Introduction
      • Scripts
      • API Reference
      • API Docs
      • Script Examples
        • Common Script Examples
        • Task Stage Hooks
        • Modification Method
    • Guides and Repository
      • Configuration Object Repository
      • Guides
        • Kerberos Authentication with Oracle
        • Call an MVS Host Job from a Stage Hook
        • Using Files in a RLP Start Condition Query
        • Moving Code into Script Libraries
        • Set a Dummy PDF for Modification
        • Using SC Task to Compare Environments
        • Set start value for identity columns in MS SQL server automatically
        • Writing BLOB data in an XDM File
        • Dynamic Environments using the Activation Script
        • Delete expired Objects
        • Set Environment ID as Environment Variable
        • Dynamic Environment-Based Schema and Table Naming in XDM Copy Tasks
        • Avoiding the use of generated always column in a merge statement
        • Exploring and Recommending Data Relation Rules with the Table Reference Stage Hook
    • File Bridge
      • File Bridge Server installation
      • Using the File Bridge Server
      • File Bridge Server Statements
      • Create Virtual Tables Using XDM
  • Content
  • Object Reference
  • Task Execution Reference
  • Types mappings
  • BigQuery

Supported BigQuery data types

XDM relies on the JDBC drivers data type mapping. Refer to the type documentation of the Simba BigQuery driver and XDM JDBC type mapping.

© 2025 UBS Hainer GmbH | www.ubs-hainer.com