Google Cloud
Why Google
  • Groundbreaking solutions. Transformative know-how.
  • Whether your business is early in its journey or well on its way to digital transformation, Google Cloud's solutions and technologies help chart a path to success.
  • Learn more
  • Why Google Cloud
  • Choosing Google Cloud
    Reasons why people choose us
  • Trust and security
    Keep your data secure and compliant
  • Open cloud
    Scale with open, flexible technology
  • Global infrastructure
    Build on the same infrastructure Google uses
  • Analyst reports
    See how Google Cloud ranks
  • Customer stories
    Learn how businesses use Google Cloud
  • Partners
    Tap into our global ecosystem of cloud experts
  • Google Cloud Blog
    Read the latest stories and product updates
  • Events
    Join events and learn more about Google Cloud
Solutions
  • Industry Solutions
    Reduce cost, increase operational agility, and capture new market opportunities.
  • Retail
    Analytics and collaboration tools for the retail value chain.
  • Financial Services
    Computing, data management, and analytics tools for financial services.
  • Healthcare and Life Sciences
    Health-specific solutions to enhance the patient experience.
  • Media and Entertainment
    Solutions for content production and distribution operations.
  • Telecommunications
    Hybrid and multi-cloud services to deploy and monetize 5G.
  • Gaming
    AI-driven solutions to build and scale games faster.
  • Manufacturing
    Migration and AI tools to optimize the manufacturing value chain.
  • Energy
    Multi-cloud and hybrid solutions for energy companies.
  • Government
    Data storage, AI, and analytics solutions for government agencies.
  • Education
    Teaching tools to provide more engaging learning experiences.
  • Small and Medium Business
    Explore SMB solutions for web hosting, app development, AI, analytics, and more.
  • Cloud Natives
    Resources and solutions for cloud-native organizations.
  • Not seeing what you're looking for?
  • See all solutions
  • Application Modernization
    Develop and run applications anywhere, using cloud-native technologies like containers, serverless, and service mesh.
  • Hybrid and Multi-cloud Application Platform
    Platform for modernizing legacy apps and building new apps.
  • Cloud-Native App Development
    End-to-end solution for building, deploying, and managing apps.
  • Serverless solutions
    Fully managed environment for developing, deploying and scaling apps.
  • DevOps
    Processes and resources for implementing DevOps in your org.
  • Configuration Management
    Tools for automating and maintaining system configurations.
  • Continuous Delivery (CD)
    End-to-end automation from source to production.
  • Continuous Integration (CI)
    Fast feedback on code changes at scale.
  • Infrastructure as Code
    Automate repeatable tasks for one machine or millions.
  • Secrets Management
    Encrypt, store, manage, and audit infrastructure and application-level secrets.
  • Mainframe Modernization
    Automated tools and prescriptive guidance for moving to the cloud.
  • Hosting
    Services and infrastructure for building web apps and websites.
  • Artificial Intelligence
    Add intelligence and efficiency to your business with AI and machine learning.
  • Build and Use AI
    Products to build and use artificial intelligence.
  • Contact Center AI
    AI model for speaking with customers and assisting human agents.
  • Document AI
    Machine learning and AI to unlock insights from your documents.
  • Cloud Talent Solution
    AI with job search and talent acquisition capabilities.
  • Business Application Platform
    Speed up the pace of innovation without coding, using APIs, apps, and automation.
  • New Business Channels Using APIs
    Attract and empower an ecosystem of developers and partners.
  • Unlocking Legacy Applications Using APIs
    Cloud services for extending and modernizing legacy apps.
  • Open Banking APIx
    Simplify and accelerate secure delivery of open banking compliant APIs.
  • Data Management
    Migrate and manage enterprise data with security, reliability, high availability, and fully managed data services.
  • Database Migration
    Guides and tools to simplify your database migration life cycle.
  • Database Modernization
    Upgrades to modernize your operational database infrastructure.
  • Google Cloud Databases
    Database services to migrate, manage, and modernize data.
  • Migrate Oracle workloads to Google Cloud
    Rehost, replatform, rewrite your Oracle workloads.
  • Open Source Databases
    Fully managed open source databases with enterprise-grade support.
  • SQL Server on Google Cloud
    Options for running SQL Server virtual machines on Google Cloud.
  • Digital Transformation
  • Accelerate business recovery and ensure a better future with solutions that enable hybrid and multi-cloud, generate intelligent insights, and keep your workers connected.
  • Business Continuity
    Proactively plan and prioritize workloads.
  • Digital Innovation
    Reimagine your operations and unlock new opportunities.
  • Operational Efficiency
    Prioritize investments and optimize costs.
  • COVID-19 Solutions
    Get work done more safely and securely.
  • COVID-19 Solutions for the Healthcare Industry
    How Google is helping healthcare meet extraordinary challenges.
  • Infrastructure Modernization
    Migrate quickly with solutions for SAP, VMware, Windows, Oracle, and other workloads.
  • VM Migration
    Discovery and analysis tools for moving to the cloud.
  • SAP on Google Cloud
    Certifications for running SAP applications and SAP HANA.
  • High Performance Computing
    Compute, storage, and networking options to support any workload.
  • Windows on Google Cloud
    Tools and partners for running Windows workloads.
  • Data Center Migration
    Migration solutions for VMs, apps, databases, and more.
  • Marketing Technology
    Tools for app hosting, real-time bidding, ad serving, and more.
  • Active Assist
    Automatic cloud resource optimization and increased security.
  • Virtual Desktops
    Remote work solutions for desktops and applications (VDI & DaaS).
  • Productivity and Collaboration
    Change the way teams work with solutions designed for humans and built for impact.
  • Google Workspace
    Collaboration and productivity tools for enterprises.
  • Google Workspace Essentials
    Secure video meetings and modern collaboration for teams.
  • Cloud Identity
    Unified platform for IT admins to manage user devices and apps.
  • Chrome Enterprise
    Chrome OS, Chrome Browser, and Chrome devices built for business.
  • Cloud Search
    Enterprise search for employees to quickly find company information.
  • Security
    Detect, investigate, and respond to online threats to help protect your business.
  • Application Security
    App protection against fraudulent activity, spam, and abuse.
  • Security Analytics and Operations
    Solution for analyzing petabytes of security telemetry.
  • BeyondCorp Remote Access
    Zero-trust access control for your internal web apps.
  • Smart Analytics
    Generate instant insights from data at any scale with a serverless, fully managed analytics platform that significantly simplifies analytics.
  • Data Warehouse Modernization
    Data warehouse to jumpstart your migration and unlock insights.
  • Stream Analytics
    Insights from ingesting, processing, and analyzing event streams.
  • Marketing Analytics
    Solutions for collecting, analyzing, and activating customer data.
  • Data Lake Modernization
    Services for building and modernizing your data lake.
  • Business Intelligence
    Data analytics tools for collecting, analyzing, and activating BI.
Products
  • Featured Products
  • Compute Engine
    Virtual machines running in Google’s data center.
  • Cloud Storage
    Object storage that’s secure, durable, and scalable.
  • Cloud SDK
    Command-line tools and libraries for Google Cloud.
  • Cloud SQL
    Relational database services for MySQL, PostgreSQL, and SQL server.
  • Google Kubernetes Engine
    Managed environment for running containerized apps.
  • BigQuery
    Data warehouse for business agility and insights.
  • Cloud CDN
    Content delivery network for delivering web and video.
  • Dataflow
    Streaming analytics for stream and batch processing.
  • Operations
    Monitoring, logging, and application performance suite.
  • Cloud Run
    Fully managed environment for running containerized apps.
  • Cloud Functions
    Event-driven compute platform for cloud services and apps.
  • Not seeing what you're looking for?
  • See all products (100+)
  • AI and Machine Learning
  • Speech-to-Text
    Speech recognition and transcription supporting 125 languages.
  • Vision AI
    Custom and pre-trained models to detect emotion, text, more.
  • Text-to-Speech
    Speech synthesis in 220+ voices and 40+ languages.
  • Cloud Translation
    Language detection, translation, and glossary support.
  • Cloud Natural Language
    Sentiment analysis and classification of unstructured text.
  • AutoML
    Custom machine learning model training and development.
  • AI Platform
    Platform for training, hosting, and managing ML models.
  • Video AI
    Video classification and recognition using machine learning.
  • AI Infrastructure
    Options for every business to train deep learning and machine learning models cost-effectively.
  • Dialogflow
    Conversation applications and systems development suite.
  • AutoML Tables
    Service for training ML models with structured data.
  • Not seeing what you're looking for?
  • See all AI and machine learning products
  • API Management
  • Apigee API Platform
    API management, development, and security platform.
  • Analyze APIs
    Dashboards, custom reports, and metrics for API performance.
  • Monetize APIs
    Revenue stream and business model creation from APIs.
  • Apigee Hybrid
    Deployment option for managing APIs on-premises or in the cloud.
  • Apigee Sense
    Intelligent behavior detection to protect APIs.
  • Cloud Endpoints
    Deployment and development management for APIs on Google Cloud.
  • Developer Portal
    Self-service and custom developer portal creation.
  • Apigee Healthcare APIx
    FHIR API-based digital service formation.
  • Apigee Open Banking APIx
    Open banking and PSD2-compliant API delivery.
  • Cloud Healthcare API
    Solution to bridge existing care systems and apps on Google Cloud.
  • AppSheet
    No-code development platform to build and extend applications.
  • Compute
  • Compute Engine
    Virtual machines running in Google’s data center.
  • App Engine
    Serverless application platform for apps and back ends.
  • Cloud GPUs
    GPUs for ML, scientific computing, and 3D visualization.
  • Migrate for Compute Engine
    Server and virtual machine migration to Compute Engine.
  • Preemptible VMs
    Compute instances for batch jobs and fault-tolerant workloads.
  • Shielded VMs
    Reinforced virtual machines on Google Cloud.
  • Sole-Tenant Nodes
    Dedicated hardware for compliance, licensing, and management.
  • Bare Metal
    Infrastructure to run specialized workloads on Google Cloud.
  • Recommender
    Usage recommendations for Google Cloud products and services.
  • VMware Engine
    Migrate and run your VMware workloads natively on Google Cloud.
  • Cloud Run
    Fully managed environment for running containerized apps.
  • Not seeing what you're looking for?
  • See all compute products
  • Containers
  • Google Kubernetes Engine
    Managed environment for running containerized apps.
  • Container Registry
    Registry for storing, managing, and securing Docker images.
  • Container Security
    Container environment security for each stage of the life cycle.
  • Cloud Build
    Solution for running build steps in a Docker container.
  • Deep Learning Containers
    Containers with data science frameworks, libraries, and tools.
  • Kubernetes Applications
    Containerized apps with prebuilt deployment and unified billing.
  • Artifact Registry
    Package manager for build artifacts and dependencies.
  • Knative
    Components to create Kubernetes-native cloud-based software.
  • Cloud Run
    Fully managed environment for running containerized apps.
  • Cloud Code
    IDE support to write, run, and debug Kubernetes applications.
  • Data Analytics
  • BigQuery
    Data warehouse for business agility and insights.
  • Looker
    Platform for BI, data applications, and embedded analytics.
  • Dataflow
    Streaming analytics for stream and batch processing.
  • Pub/Sub
    Messaging service for event ingestion and delivery.
  • Dataproc
    Service for running Apache Spark and Apache Hadoop clusters.
  • Cloud Data Fusion
    Data integration for building and managing data pipelines.
  • Cloud Composer
    Workflow orchestration service built on Apache Airflow.
  • Data Catalog
    Metadata service for discovering, understanding and managing data.
  • Dataprep
    Service to prepare data for analysis and machine learning.
  • Google Data Studio
    Interactive data suite for dashboarding, reporting, and analytics.
  • Google Marketing Platform
    Marketing platform unifying advertising and analytics.
  • Cloud Life Sciences
    Tools for managing, processing, and transforming biomedical data.
  • Databases
  • Cloud Bigtable
    NoSQL wide-column database for storing big data with low latency.
  • Firestore
    NoSQL document database for mobile and web application data.
  • Memorystore
    In-memory data store service for Redis for fast data processing.
  • Cloud Spanner
    Relational database with unlimited scale and high availability.
  • Cloud SQL
    Relational database services for MySQL, PostgreSQL, and SQL server.
  • Firebase Realtime Database
    NoSQL cloud database for storing and syncing data in real time.
  • Developer Tools
  • Cloud SDK
    Command line tools and libraries for Google Cloud.
  • Container Registry
    Private Docker storage for container images on Google Cloud.
  • Cloud Build
    Continuous integration and continuous delivery platform.
  • Cloud Source Repositories
    Private Git repository to store, manage, and track code.
  • Cloud Scheduler
    Cron job scheduler for task automation and management.
  • Tekton
    Kubernetes-native resources for declaring CI/CD pipelines.
  • Cloud Tasks
    Task management service for asynchronous task execution.
  • Cloud Code
    IDE support to write, run, and debug Kubernetes applications.
  • Tools for Visual Studio
    Tools to enable development in Visual Studio on Google Cloud.
  • Tools for Eclipse
    Plugin for Google Cloud development inside the Eclipse IDE.
  • Cloud Code for IntelliJ
    IDE support for debugging production cloud apps inside IntelliJ.
  • Not seeing what you're looking for?
  • See all developer tools
  • Healthcare and Life Sciences
  • Apigee Healthcare APIx
    FHIR API-based digital service production.
  • Cloud Healthcare API
    Solution for bridging existing care systems and apps on Google Cloud.
  • Cloud Life Sciences
    Tools for managing, processing, and transforming biomedical data.
  • Hybrid and Multi-cloud
  • Anthos
    Platform for modernizing existing apps and building new ones.
  • Cloud Run for Anthos
    Integration that provides a serverless development platform on GKE.
  • Google Cloud Marketplace for Anthos
    Containerized apps with prebuilt deployment and unified billing.
  • Migrate for Anthos
    Tool to move workloads and existing applications to GKE.
  • Operations
    Monitoring, logging, and application performance suite.
  • Cloud Build
    Service for executing builds on Google Cloud infrastructure.
  • Traffic Director
    Traffic control pane and management for open service mesh.
  • Apigee API Management
    API management, development, and security platform.
  • Internet of Things
  • Cloud IoT Core
    IoT device management, integration, and connection service.
  • Edge TPU
    ASIC designed to run ML inference and AI at the edge.
  • Management Tools
  • Cloud Shell
    Interactive shell environment with a built-in command line.
  • Cloud Console
    Web-based interface for managing and monitoring cloud apps.
  • Cloud Deployment Manager
    Service for creating and managing Google Cloud resources.
  • Cloud Mobile App
    App to manage Google Cloud services from your mobile device.
  • Cloud APIs
    Programmatic interfaces for Google Cloud services.
  • Private Catalog
    Service catalog for admins managing internal enterprise solutions.
  • Cost Management
    Tools for monitoring, controlling, and optimizing your costs.
  • Media and Gaming
  • Game Servers
    Game server management service running on Google Kubernetes Engine.
  • Zync Render
    Platform for 3D modeling and rendering on Google Cloud infrastructure.
  • Anvato
    Media content platform for OTT services and video streaming.
  • OpenCue
    Open source render manager for visual effects and animation.
  • Migration
  • BigQuery Data Transfer Service
    Data import service for scheduling and moving data into BigQuery.
  • Cloud Data Transfer
    Tools and services for transferring your data to Google Cloud.
  • Cloud Foundation Toolkit
    Reference templates for Deployment Manager and Terraform.
  • Transfer Service
    Data transfers from online and on-premises sources to Cloud Storage.
  • Migrate for Anthos
    Components for migrating VMs into system containers on GKE.
  • Migrate for Compute Engine
    Components for migrating VMs and physical servers to Compute Engine.
  • Transfer Appliance
    Storage server for moving large volumes of data to Google Cloud.
  • VM Migration
    VM migration to the cloud for low-cost refresh cycles.
  • Networking
  • Cloud Armor
    Security policies and defense against web and DDoS attacks.
  • Cloud CDN
    Content delivery network for serving web and video content.
  • Cloud DNS
    Domain name system for reliable and low-latency name lookups.
  • Cloud Load Balancing
    Service for distributing traffic across applications and regions.
  • Cloud NAT
    NAT service for giving private instances internet access.
  • Hybrid Connectivity
    Connectivity options for VPN, peering, and enterprise needs.
  • Network Intelligence Center
    Network monitoring, verification, and optimization platform.
  • Network Service Tiers
    Cloud network options based on performance, availability, and cost.
  • Network Telemetry
    VPC flow logs for network monitoring, forensics, and security.
  • Traffic Director
    Traffic control pane and management for open service mesh.
  • Virtual Private Cloud
    Virtual network for Google Cloud resources and cloud-based services.
  • Service Directory
    Platform for discovering, publishing, and connecting services.
  • Operations
  • Cloud Logging
    Google Cloud audit, platform, and application logs management.
  • Cloud Monitoring
    Infrastructure and application health with rich metrics.
  • Error Reporting
    Application error identification and analysis.
  • Kubernetes Engine Monitoring
    GKE app development and troubleshooting.
  • Service Monitoring
    SLO monitoring and alerting.
  • Cloud Trace
    Tracing system collecting latency data from applications.
  • Cloud Profiler
    CPU and heap profiler for analyzing application performance.
  • Cloud Debugger
    Real-time application state inspection and in-production debugging.
  • Transparent Service Level Indicators
    SLIs for monitoring Google Cloud services and their effects on your workloads.
  • Security and Identity
  • Cloud IAM
    Permissions management system for Google Cloud resources.
  • Assured Workloads
    Compliance and security controls for sensitive workloads.
  • Cloud Key Management
    Manage encryption keys on Google Cloud.
  • Confidential Computing
    Encrypt data in use with Confidential VMs.
  • Security Command Center
    Platform for defending against threats to your Google Cloud assets.
  • Cloud Data Loss Prevention
    Sensitive data inspection, classification, and redaction platform.
  • Managed Service for Microsoft Active Directory
    Hardened service running Microsoft® Active Directory (AD).
  • Access Transparency
    Cloud provider visibility through near real-time logs.
  • Titan Security Key
    Two-factor authentication device for user account protection.
  • Secret Manager
    Store API keys, passwords, certificates, and other sensitive data.
  • Not seeing what you're looking for?
  • See all security and identity products
  • Serverless Computing
  • Cloud Run
    Fully managed environment for running containerized apps.
  • Cloud Functions
    Platform for creating functions that respond to cloud events.
  • App Engine
    Serverless application platform for apps and back ends.
  • Workflows
    Workflow orchestration for serverless products and API services.
  • Storage
  • Cloud Storage
    Object storage that’s secure, durable, and scalable.
  • Filestore
    File storage that is highly scalable and secure.
  • Persistent Disk
    Block storage for virtual machine instances running on Google Cloud.
  • Cloud Storage for Firebase
    Object storage for storing and serving user-generated content.
  • Local SSD
    Block storage that is locally attached for high-performance needs.
  • Archival Storage
    Data archive that offers online access speed at ultra low cost.
  • Cloud Data Transfer
    Tools and services for transferring your data to Google Cloud.
  • Google Workspace Essentials
    Secure video meetings and modern collaboration for teams.
Pricing
  • Do more for less with Google Cloud
  • Our customer-friendly pricing means more overall value to your business.
  • Contact sales
  • Google Cloud Platform
  • Overview
    Pay only for what you use with no lock-in
  • Price list
    Pricing details on each Google Cloud product
  • Calculators
    Calculate your cloud savings
  • Free on Google Cloud
    Learn and build on Google Cloud for free
  • More Cloud Products
  • Google Workspace
  • Google Maps Platform
  • Cloud Identity
  • Apigee
  • Firebase
  • Zync Render
Getting started
  • Get started with Google Cloud
  • Start building right away on our secure, intelligent platform. New customers can use a $300 free credit to get started with any GCP product.
  • Try GCP Free
  • Get Started
  • Resources to Start on Your Own
  • Quickstarts
    View short tutorials to help you get started
  • GCP Marketplace
    Deploy ready-to-go solutions in a few clicks
  • Training
    Enroll in on-demand or classroom training
  • Certification
    Become Google Cloud Certified
  • Get Help from an Expert
  • Consulting
    Jump-start your project with help from Google
  • Technical Account Management
    Get long-term guidance from Google
  • Find a Partner
    Work with a Partner in our global network
  • Become a Partner
    Join Google Cloud's Partner program
  • More ways to get started
Docs Support
Docs Support
  • Data analytics products
Guides Reference Resources
Contact Sales Get started for free
Google Cloud
  • Why Google
    • More
  • Solutions
    • More
  • Products
    • More
  • Pricing
    • More
  • Getting started
    • More
  • Docs
    • Guides
    • Reference
    • Resources
  • Support
  • Console
  • Contact Sales
  • Get started for free
  • Cloud Dataprep by Trifacta
  • All References
  • Language Reference
    • Overview
    • Aggregate Functions
      • Overview
      • ANY Function
      • ANYIF Function
      • AVERAGE Function
      • AVERAGEIF Function
      • CORREL Function
      • COUNT Function
      • COUNTA Function
      • COUNTAIF Function
      • COUNTDISTINCT Function
      • COUNTDISTINCTIF Function
      • COUNTIF Function
      • COVAR Function
      • COVARSAMP Function
      • KTHLARGEST Function
      • KTHLARGESTIF Function
      • KTHLARGESTUNIQUE Function
      • KTHLARGESTUNIQUEIF Function
      • LIST Function
      • LISTIF Function
      • MAX Function
      • MAXIF Function
      • MEDIAN Function
      • MIN Function
      • MINIF Function
      • MODE Function
      • MODEIF Function
      • PERCENTILE Function
      • QUARTILE Function
      • STDEV Function
      • STDEVIF Function
      • STDEVSAMP Function
      • STDEVSAMPIF Function
      • SUM Function
      • SUMIF Function
      • UNIQUE Function
      • VAR Function
      • VARIF Function
    • Comparison Functions
      • Overview
      • Comparison Operators
      • EQUAL Function
      • GREATERTHAN Function
      • GREATERTHANEQUAL Function
      • IN Function
      • ISEVEN Function
      • ISODD Function
      • LESSTHAN Function
      • LESSTHANEQUAL Function
      • MATCHES Function
      • NOTEQUAL Function
      • VARSAMP Function
      • VARSAMPIF Function
    • Date Functions
      • Overview
      • CONVERTFROMUTC Function
      • CONVERTTIMEZONE Function
      • CONVERTTOUTC Function
      • DATE Function
      • DATEADD Function
      • DATEFORMAT Function
      • DATEDIF Function
      • DATETIME Function
      • DAY Function
      • HOUR Function
      • MAXDATE Function
      • MINDATE Function
      • MINUTE Function
      • MODEDATE Function
      • MONTH Function
      • MONTHNAME Function
      • NETWORKDAYS Function
      • NETWORKDAYSINTL Function
      • NOW Function
      • PARSEDATE Function
      • SECOND Function
      • TIME Function
      • TODAY Function
      • UNIXTIME Function
      • UNIXTIMEFORMAT Function
      • WEEKDAY Function
      • WEEKNUM Function
      • WORKDAY Function
      • WORKDAYINTL Function
      • YEAR Function
    • Examples
      • ARRAYINDEXOF and ARRAYRIGHTINDEXOF Functions
      • ARRAYLEN and ARRAYELEMENTAT Functions
      • ARRAYSLICE and ARRAYMERGEELEMENTS Functions
      • ARRAYSTOMAP Function
      • Case Functions
      • Comparison Functions Equal
      • Comparison Functions1
      • Comparison Functions2
      • Conditional Calculations Functions
      • COUNT Functions
      • COUNTIF Functions
      • Countpattern Transform
      • DATE and TIME Functions
      • Date Difference Functions
      • Date Functions
      • Date Functions: Min, Max, and Mode
      • DATEDIF Function
      • Day-of Functions
      • DEGREES and RADIANS Functions
      • Delete and Keep Transforms
      • Domain Functions
      • Double Metaphone Functions
      • Exponentional Functions
      • Extractkv and Unnest Transforms
      • Extractlist Transform
      • Flatten and Unnest Transforms
      • Flatten and Valuestocols Transforms
      • IF Data Type Validation Functions
      • IPTOINT Function
      • KTHLARGEST Function
      • KTHLARGESTIF Function
      • LISTIF Functions
      • LIST Math Functions
      • LIST and UNIQUE Function
      • Logical Functions
      • Nested Functions
      • NEXT Function
      • NOW and TODAY Functions
      • Numeric Functions
      • Percentile Functions
      • POW and SQRT Functions
      • PREV Function
      • Quote Parameter
      • RANDBETWEEN and PI-Functions
      • RANK Functions
      • Replacement Transforms
      • ROLLINGKTHLARGEST Functions
      • Rolling Functions
      • Rolling Functions 2
      • Rounding Functions
      • Settype Transform
      • SOURCEROWNUMBER Function
      • Splitting with Different Delimiter Types
      • STARTSWITH and ENDSWITH Functions
      • Statistical Functions
      • Statistical Functions Sample Method
      • String Cleanup Functions
      • String-Comparison-Functions
      • SUMIF and COUNTDISTINCTIF Functions
      • SUMIF Function
      • Time Zone Conversion Function
      • Trigonometry Arc Functions
      • Trigonometry Functions
      • Trigonometry Hyperbolic Arc Functions
      • Trigonometry Hyperbolic Functions
      • Two Column Statistical Functions
      • Type Functions
      • Type Parsing Functions
      • UNICODE Function
      • Unixtime Functions
    • Language Documentation Syntax Notes
    • Logical Functions
      • Overview
      • Logical Operators
      • AND Function
      • OR Function
      • NOT Function
    • Math Functions
      • Overview
      • ABS Function
      • ADD Function
      • CEILING Function
      • DIVIDE Function
      • EXP Function
      • FLOOR Function
      • LCM Function
      • LN Function
      • LOG Function
      • MOD Function
      • MULTIPLY Function
      • NEGATE Function
      • NUMFORMAT Function
      • POW Function
      • ROUND Function
      • SIGN Function
      • SQRT Function
      • SUBTRACT Function
      • TRUNC Function
      • Numeric Operators
    • Trigonometry Functions
      • Overview
      • DEGREES Function
      • RADIANS Function
      • SIN Function
      • COS Function
      • TAN Function
      • ASIN Function
      • ACOS Function
      • ATAN Function
      • SINH Function
      • COSH Function
      • TANH Function
      • ASINH Function
      • ACOSH Function
      • ATANH Function
    • Nested Functions
      • Overview
      • ARRAYCONCAT Function
      • ARRAYCROSS Function
      • ARRAYELEMENTAT Function
      • ARRAYINDEXOF Function
      • ARRAYINTERSECT Function
      • ARRAYLEN Function
      • ARRAYMERGEELEMENTS Function
      • ARRAYRIGHTINDEXOF Function
      • ARRAYSLICE Function
      • ARRAYSORT Function
      • ARRAYSTOMAP Function
      • ARRAYUNIQUE Function
      • ARRAYZIP Function
      • FILTEROBJECT Function
      • KEYS Function
      • LISTAVERAGE Function
      • LISTMAX Function
      • LISTMIN Function
      • LISTMODE Function
      • LISTSTDEV Function
      • LISTSUM Function
      • LISTVAR Function
    • Other Functions
      • Overview
      • CASE Function
      • COALESCE Function
      • DOMAIN Function
      • HOST Function
      • IF Function
      • IPFROMINT Function
      • IPTOINT Function
      • PI Function
      • RAND Function
      • RANDBETWEEN Function
      • RANGE Function
      • SOURCEROWNUMBER Function
      • SUBDOMAIN Function
      • SUFFIX Function
      • Ternary Operators
      • URLPARAMS Function
    • Parameters
      • after_col Parameter
      • after Parameter
      • as Parameter
      • at Parameter
      • before_col Parameter
      • before Parameter
      • col_multi Parameter
      • delimiter Parameter
      • from Parameter
      • global Parameter
      • groupEvery Parameter
      • group Parameter
      • ignoreCase Parameter
      • key Parameter
      • keys Parameter
      • limit Parameter
      • markLineage Parameter
      • on Parameter
      • pluck Parameter
      • quote Parameter
      • row Parameter
      • sourcerownumber Parameter
      • to_col Parameter
      • to Parameter
      • type Parameter
      • valueafter Parameter
      • value Parameter
      • with Parameter
    • Source-Metadata-References
    • String Functions
      • Overview
      • CHAR Function
      • DOUBLEMETAPHONE Function
      • DOUBLEMETAPHONEEQUALS Function
      • ENDSWITH Function
      • EXACT Function
      • FIND Function
      • LEFT Function
      • LEN Function
      • LOWER Function
      • MERGE Function
      • PAD Function
      • PROPER Function
      • REMOVESYMBOLS Function
      • REMOVEWHITESPACE Function
      • REPEAT Function
      • RIGHT Function
      • RIGHTFIND Function
      • STARTSWITH Function
      • STRINGGREATERTHAN Function
      • STRINGGREATERTHANEQUAL Function
      • STRINGLESSTHAN Function
      • STRINGLESSTHANEQUAL Function
      • SUBSTITUTE Function
      • SUBSTRING Function
      • TRANSLITERATE Function
      • TRIM Function
      • UNICODE Function
      • UPPER Function
    • Supported Data Types
      • Overview
      • Array Data Type
      • Boolean Data Type
      • Credit Card Data Type
      • Data Type Validation Patterns
      • Decimal Data Type
      • Datetime Data Type
        • Overview
        • Supported Time Zone Values
      • Email Address Data Type
      • Gender Data Type
      • HTTP Code Data Type
      • Integer Data Type
      • IP Address Data Type
      • Object-Data-Type
      • Phone Number Data Type
      • Social Security Number Data Type
      • State Data Type
      • String Data Type
      • URL Data Type
        • Overview
        • Structure of a URL
      • Valid Data Type Strings
      • Zip Code Data Type
    • Text Matching
      • Overview
      • Capture Group References
      • Escaping Strings in Transformations
      • Pattern Clause Position Matching
      • Supported Special Regular Expression Characters
      • String Collation Rules
    • Type Conversions
      • Overview
      • BigQuery Data Type Conversions
      • Parquet Data Type Conversions
      • DB2 Data Type Conversions
      • Oracle Data Type Conversions
      • Postgres Data Type Conversions
      • Salesforce Data Type Conversions
      • SQL Server Data Type Conversions
    • Type Functions
      • Overview
      • IFMISMATCHED Function
      • IFMISSING Function
      • IFNULL Function
      • IFVALID Function
      • ISMISMATCHED Function
      • ISMISSING Function
      • ISNULL Function
      • NULL Function
      • PARSEBOOL Function
      • PARSEFLOAT Function
      • PARSEINT Function
      • VALID Function
    • Window Functions
      • Overview
      • DENSERANK Function
      • FILL Function
      • NEXT Function
      • PREV Function
      • RANK Function
      • ROLLINGAVERAGE Function
      • ROLLINGCOUNTA Function
      • ROLLINGKTHLARGEST Function
      • ROLLINGKTHLARGESTUNIQUE Function
      • ROLLINGLIST Function
      • ROLLINGMAX Function
      • ROLLINGMIN Function
      • ROLLINGMODE Function
      • ROLLINGSTDEV Function
      • ROLLINGSTDEVSAMP Function
      • ROLLINGSUM Function
      • ROLLINGVAR Function
      • ROLLINGVARSAMP-Function
      • ROWNUMBER Function
      • SESSION Function
    • Language Appendices
      • Overview
      • Transforms
        • Overview
        • Case Transform
        • Comment Transform
        • Countpattern Transform
        • Deduplicate Transform
        • Delete Transform
        • Derive Transform
        • Drop Transform
        • Extract Transform
        • Extractkv Transform
        • Extractlist Transform
        • Filter Transform
        • Flatten Transform
        • Header Transform
        • Keep Transform
        • Merge Transform
        • Move Transform
        • Nest Transform
        • Pivot Transform
        • Rename Transform
        • Replace Transform
        • Set Transform
        • Settype Transform
        • Split Transform
        • Splitrows Transform
        • Unnest Transform
        • Unpivot Transform
        • Valuestocols Transform
        • Window Transform
  • UI Reference
    • Overview
    • Home Page
    • Plans Page
      • Overview
      • Plan View Page
    • Flows Page
      • Overview
      • Create Flow Page
      • Flow View Page
        • Overview
        • Add Schedule Dialog
        • Change Dataset Dialog
        • Cron Schedule Syntax Reference
        • Manage Parameters Dialog
        • Share Flow Dialog
        • Manage Flow Notifications Dialog
    • Jobs Page
      • Overview
      • Job Details Page
      • Publishing Dialog
    • Library Page
      • Overview
      • Dataset Details Page
      • Import Data Page
        • Overview
        • BigQuery Browser
        • Cloud Storage Browser
        • Database Browser
        • Salesforce Browser
        • Create Connection Window
      • Macros Page
        • Overview
        • Macros Details Page
    • Projects Menu
    • Transformer Page
      • Overview
      • Column Browser Panel
        • Overview
        • Transformation by Example Page
      • Column Details Panel
        • Overview
        • Column Statistics Reference
      • Column Menus
        • Overview
        • Choose Datetime Format Dialog
      • Data Grid Panel
        • Overview
        • Column Histograms
        • Data Quality Bars
        • Lookup Wizard
        • Standardize Page
      • Join Metrics
      • Join Window
      • Join Types
      • Recipe Navigator
      • Recipe Panel
      • Run Job
        • Run Job Page
        • Dataflow Execution Settings
      • Transform Builder
      • Transform Context Panel
        • Overview
        • Edit History Panel
        • Filter Panel
        • Pattern History Panel
        • Samples Panel
        • Search Panel
        • Selection Details Panel
      • Transform Preview
      • Transformer Toolbar
      • Union Page
      • Visible Columns Panel
    • Preferences Page
      • Overview
      • Project Settings Page
      • User Profile Page
      • Access Tokens Page
      • Connections Page
        • Overview
        • Share Connection Window
        • Email Notifications Page
  • API Reference
    • Overview
    • Authentication
      • Manage API Access Tokens
    • Endpoints
      • API Endpoints for GDP Premium
      • API Endpoints for GDP Standard
      • API Endpoints for GDP
    • Workflows
      • Overview
      • Run Job
      • Develop a Flow
      • Run Job on Dataset with Parameters
      • Swap Datasets
      • Manage Outputs
      • Run Plan
  • Admin Reference
    • Overview
    • Required User Permissions
  • Other References
    • Glossary
    • Locale Settings
    • Sort Order
    • Supported File Encoding Types
    • Transformation Reference
  • Groundbreaking solutions. Transformative know-how.
  • Learn more
  • Why Google Cloud
  • Choosing Google Cloud
  • Trust and security
  • Open cloud
  • Global infrastructure
  • Analyst reports
  • Customer stories
  • Partners
  • Google Cloud Blog
  • Events
  • Industry Solutions
  • Retail
  • Financial Services
  • Healthcare and Life Sciences
  • Media and Entertainment
  • Telecommunications
  • Gaming
  • Manufacturing
  • Energy
  • Government
  • Education
  • Small and Medium Business
  • Cloud Natives
  • See all solutions
  • Application Modernization
  • Hybrid and Multi-cloud Application Platform
  • Cloud-Native App Development
  • Serverless solutions
  • DevOps
  • Configuration Management
  • Continuous Delivery (CD)
  • Continuous Integration (CI)
  • Infrastructure as Code
  • Secrets Management
  • Mainframe Modernization
  • Hosting
  • Artificial Intelligence
  • Build and Use AI
  • Contact Center AI
  • Document AI
  • Cloud Talent Solution
  • Business Application Platform
  • New Business Channels Using APIs
  • Unlocking Legacy Applications Using APIs
  • Open Banking APIx
  • Data Management
  • Database Migration
  • Database Modernization
  • Google Cloud Databases
  • Migrate Oracle workloads to Google Cloud
  • Open Source Databases
  • SQL Server on Google Cloud
  • Digital Transformation
  • Business Continuity
  • Digital Innovation
  • Operational Efficiency
  • COVID-19 Solutions
  • COVID-19 Solutions for the Healthcare Industry
  • Infrastructure Modernization
  • VM Migration
  • SAP on Google Cloud
  • High Performance Computing
  • Windows on Google Cloud
  • Data Center Migration
  • Marketing Technology
  • Active Assist
  • Virtual Desktops
  • Productivity and Collaboration
  • Google Workspace
  • Google Workspace Essentials
  • Cloud Identity
  • Chrome Enterprise
  • Cloud Search
  • Security
  • Application Security
  • Security Analytics and Operations
  • BeyondCorp Remote Access
  • Smart Analytics
  • Data Warehouse Modernization
  • Stream Analytics
  • Marketing Analytics
  • Data Lake Modernization
  • Business Intelligence
  • Featured Products
  • Compute Engine
  • Cloud Storage
  • Cloud SDK
  • Cloud SQL
  • Google Kubernetes Engine
  • BigQuery
  • Cloud CDN
  • Dataflow
  • Operations
  • Cloud Run
  • Cloud Functions
  • See all products (100+)
  • AI and Machine Learning
  • Speech-to-Text
  • Vision AI
  • Text-to-Speech
  • Cloud Translation
  • Cloud Natural Language
  • AutoML
  • AI Platform
  • Video AI
  • AI Infrastructure
  • Dialogflow
  • AutoML Tables
  • See all AI and machine learning products
  • API Management
  • Apigee API Platform
  • Analyze APIs
  • Monetize APIs
  • Apigee Hybrid
  • Apigee Sense
  • Cloud Endpoints
  • Developer Portal
  • Apigee Healthcare APIx
  • Apigee Open Banking APIx
  • Cloud Healthcare API
  • AppSheet
  • Compute
  • Compute Engine
  • App Engine
  • Cloud GPUs
  • Migrate for Compute Engine
  • Preemptible VMs
  • Shielded VMs
  • Sole-Tenant Nodes
  • Bare Metal
  • Recommender
  • VMware Engine
  • Cloud Run
  • See all compute products
  • Containers
  • Google Kubernetes Engine
  • Container Registry
  • Container Security
  • Cloud Build
  • Deep Learning Containers
  • Kubernetes Applications
  • Artifact Registry
  • Knative
  • Cloud Run
  • Cloud Code
  • Data Analytics
  • BigQuery
  • Looker
  • Dataflow
  • Pub/Sub
  • Dataproc
  • Cloud Data Fusion
  • Cloud Composer
  • Data Catalog
  • Dataprep
  • Google Data Studio
  • Google Marketing Platform
  • Cloud Life Sciences
  • Databases
  • Cloud Bigtable
  • Firestore
  • Memorystore
  • Cloud Spanner
  • Cloud SQL
  • Firebase Realtime Database
  • Developer Tools
  • Cloud SDK
  • Container Registry
  • Cloud Build
  • Cloud Source Repositories
  • Cloud Scheduler
  • Tekton
  • Cloud Tasks
  • Cloud Code
  • Tools for Visual Studio
  • Tools for Eclipse
  • Cloud Code for IntelliJ
  • See all developer tools
  • Healthcare and Life Sciences
  • Apigee Healthcare APIx
  • Cloud Healthcare API
  • Cloud Life Sciences
  • Hybrid and Multi-cloud
  • Anthos
  • Cloud Run for Anthos
  • Google Cloud Marketplace for Anthos
  • Migrate for Anthos
  • Operations
  • Cloud Build
  • Traffic Director
  • Apigee API Management
  • Internet of Things
  • Cloud IoT Core
  • Edge TPU
  • Management Tools
  • Cloud Shell
  • Cloud Console
  • Cloud Deployment Manager
  • Cloud Mobile App
  • Cloud APIs
  • Private Catalog
  • Cost Management
  • Media and Gaming
  • Game Servers
  • Zync Render
  • Anvato
  • OpenCue
  • Migration
  • BigQuery Data Transfer Service
  • Cloud Data Transfer
  • Cloud Foundation Toolkit
  • Transfer Service
  • Migrate for Anthos
  • Migrate for Compute Engine
  • Transfer Appliance
  • VM Migration
  • Networking
  • Cloud Armor
  • Cloud CDN
  • Cloud DNS
  • Cloud Load Balancing
  • Cloud NAT
  • Hybrid Connectivity
  • Network Intelligence Center
  • Network Service Tiers
  • Network Telemetry
  • Traffic Director
  • Virtual Private Cloud
  • Service Directory
  • Operations
  • Cloud Logging
  • Cloud Monitoring
  • Error Reporting
  • Kubernetes Engine Monitoring
  • Service Monitoring
  • Cloud Trace
  • Cloud Profiler
  • Cloud Debugger
  • Transparent Service Level Indicators
  • Security and Identity
  • Cloud IAM
  • Assured Workloads
  • Cloud Key Management
  • Confidential Computing
  • Security Command Center
  • Cloud Data Loss Prevention
  • Managed Service for Microsoft Active Directory
  • Access Transparency
  • Titan Security Key
  • Secret Manager
  • See all security and identity products
  • Serverless Computing
  • Cloud Run
  • Cloud Functions
  • App Engine
  • Workflows
  • Storage
  • Cloud Storage
  • Filestore
  • Persistent Disk
  • Cloud Storage for Firebase
  • Local SSD
  • Archival Storage
  • Cloud Data Transfer
  • Google Workspace Essentials
  • Do more for less with Google Cloud
  • Contact sales
  • Google Cloud Platform
  • Overview
  • Price list
  • Calculators
  • Free on Google Cloud
  • More Cloud Products
  • Google Workspace
  • Google Maps Platform
  • Cloud Identity
  • Apigee
  • Firebase
  • Zync Render
  • Get started with Google Cloud
  • Try GCP Free
  • Get Started
  • Resources to Start on Your Own
  • Quickstarts
  • GCP Marketplace
  • Training
  • Certification
  • Get Help from an Expert
  • Consulting
  • Technical Account Management
  • Find a Partner
  • Become a Partner
  • More ways to get started
  • Home
  • Docs
  • Data analytics products
  • Cloud Dataprep by Trifacta
  • Documentation
  • Reference

Gender Data Type

This data type matches a variety of text patterns for expressing male/female distinctions.

The following gender identifiers are supported:

Supported Values:

  • m / f
  • M / F
  • male / female
  • Male / Female

Except as otherwise noted, the content of this page is licensed under the Creative Commons Attribution 4.0 License, and code samples are licensed under the Apache 2.0 License. For details, see the Google Developers Site Policies. Java is a registered trademark of Oracle and/or its affiliates.

Last updated 2020-06-22 UTC.

  • Why Google

    • Choosing Google Cloud
    • Trust and security
    • Open cloud
    • Global infrastructure
    • Customers and case studies
    • Analyst reports
    • Whitepapers

  • Products and pricing

    • Google Cloud pricing
    • Google Workspace pricing
    • Maps Platform pricing
    • See all products

  • Solutions

    • Application modernization
    • Artificial Intelligence
    • Business application platform
    • Database solutions
    • Infrastructure modernization
    • Productivity & collaboration
    • Security
    • Smart analytics
    • Cloud-natives
    • DevOps
    • Industries
    • Small business
    • See all solutions

  • Resources

    • Google Cloud documentation
    • Google Cloud quickstarts
    • Google Cloud Marketplace
    • Google Workspace Marketplace
    • Support
    • Tutorials
    • Training
    • Certifications
    • Google Developers
    • Google Cloud for Startups
    • System status
    • Release Notes

  • Engage

    • Contact sales
    • Find a Partner
    • Become a Partner
    • Blog
    • Events
    • Podcast
    • Community
    • Press center
    • Google Cloud on YouTube
    • Google Cloud on YouTube
    • Google Workspace on YouTube
    • Follow on Twitter
    • Join User Research
    • We're hiring. Join Google Cloud!
  • About Google
  • Privacy
  • Site terms
  • Google Cloud terms
  • Sign up for the Google Cloud newsletter Subscribe