Google Cloud Platform Big Query Data Validations | Numeric | Alphabetic | Date Validations
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]+$')
On this page of the site you can watch the video online Google Cloud Platform Big Query Data Validations | Numeric | Alphabetic | Date Validations with a duration of hours minute second in good quality, which was uploaded by the user Latest Technologies 10 March 2024, share the link with friends and acquaintances, this video has already been watched 368 times on youtube and it was liked by 11 viewers. Enjoy your viewing!
