Google Cloud Platform Big Query Data Validations | Numeric | Alphabetic | Date Validations

Опубликовано: 24 Март 2026
на канале: Latest Technologies

368

GCP BigQuery Data Validations

Numeric Validations
Alphabetic Validations
Date Validations
AlphaNumeric Validations

Query

Numeric Validation

SELECT station_id FROM `bigquery-public-data.austin_bikeshare.bikeshare_stations` where regexp_contains(cast(station_id AS STRING), r'^[0-9]+$')

Alphabetic Validations

SELECT status FROM `bigquery-public-data.austin_bikeshare.bikeshare_stations` where regexp_contains(cast(status AS STRING), r'^[a-zA-Z]+$')

Date Validations

SELECT modified_date FROM `bigquery-public-data.austin_bikeshare.bikeshare_stations`
where modified_date=timestamp(modified_date)

AlphaNumericSpecialChar

SELECT address FROM `bigquery-public-data.austin_bikeshare.bikeshare_stations` where regexp_contains(cast(address AS STRING), r'^[a-zA-Z &/.0-9]+$')