For this example, refer to the sample of the rivers.tsv file:
09379180 LAGUNA CREEK AT DENNEHOTSO, AZ 09379910 COLORADO RIVER BELOW GLEN CANYON DAM, AZ 09380000 COLORADO RIVER AT LEES FERRY, AZ 09382000 PARIA RIVER AT LEES FERRY, AZ 09383300 FILLER DITCH AT GREER, AZ 09383400 LITTLE COLORADO RIVER AT GREER, AZ 09383100 COLORADO R ABV LITTLE COLORADO R NR DESERT VIEW 09379200 CHINLE CREEK NEAR MEXICAN WATER, AZ 09379050 LUKACHUKAI CREEK NEAR LUKACHUKAI, AZ 09379025 CHINLE CREEK AT CHINLE, AZ
This statement creates a schema for the rivers.tsv file.
CREATE CSV SCHEMA Rivers_Schema AS '{"field_delimiter":"\t", "field_names":["site_no","location"]}';