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]+$')
Watch video Google Cloud Platform Big Query Data Validations | Numeric | Alphabetic | Date Validations online without registration, duration hours minute second in high quality. This video was added by user Latest Technologies 10 March 2024, don't forget to share it with your friends and acquaintances, it has been viewed on our site 213 once and liked it 9 people.