soda core file

[bhanurana111]

employeeNumber,lastName,firstName,extension,email,officeCode,reportsTo,jobTitle
1002,Murphy,Diane,x5800,dmurphy@classicmodelcars.com,1,NULL,President
1056,Patterson,Mary,x4611,mpatterso@classicmodelcars.com,1,1002,"VP Sales"
1076,Firrelli,Jeff,x9273,jfirrelli@classicmodelcars.com,1,1002,"VP Marketing"
1088,Patterson,William,x4871,wpatterson@classicmodelcars.com,6,1056,"Sales Manager (APAC)"
1102,Bondur,Gerard,x5408,gbondur@classicmodelcars.com,4,1056,"Sale Manager (EMEA)"
1143,Bow,Anthony,x5428,abow@classicmodelcars.com,1,1056,"Sales Manager (NA)"
1165,Jennings,Leslie,x3291,ljennings@classicmodelcars.com,1,1143,"Sales Rep"
1166,Thompson,Leslie,x4065,lthompson@classicmodelcars.com,1,1143,"Sales Rep"
1188,Firrelli,Julie,x2173,jfirrelli@classicmodelcars.com,2,1143,"Sales Rep"
1216,Patterson,Steve,x4334,spatterson@classicmodelcars.com,2,1143,"Sales Rep"
1286,Tseng,"Foon Yue",x2248,ftseng@classicmodelcars.com,3,1143,"Sales Rep"
1323,Vanauf,George,x4102,gvanauf@classicmodelcars.com,3,1143,"Sales Rep"
1337,Bondur,Loui,x6493,lbondur@classicmodelcars.com,4,1102,"Sales Rep"
1370,Hernandez,Gerard,x2028,ghernande@classicmodelcars.com,4,1102,"Sales Rep"
1401,Castillo,Pamela,x2759,pcastillo@classicmodelcars.com,4,1102,"Sales Rep"
1501,Bott,Larry,x2311,lbott@classicmodelcars.com,7,1102,"Sales Rep"
1504,Jones,Barry,x102,bjones@classicmodelcars.com,7,1102,"Sales Rep"
1611,Fixter,Andy,x101,afixter@classicmodelcars.com,6,1088,"Sales Rep"
1612,Marsh,Peter,x102,pmarsh@classicmodelcars.com,6,1088,"Sales Rep"
1619,King,Tom,x103,tking@classicmodelcars.com,6,1088,"Sales Rep"
1621,Nishi,Mami,x101,mnishi@classicmodelcars.com,5,1056,"Sales Rep"
1625,Kato,Yoshimi,x102,ykato@classicmodelcars.com,5,1621,"Sales Rep"
1702,Gerard,Martin,x2312,mgerard@classicmodelcars.com,4,1102,"Sales Rep"

[tools-soda]

CLOUD-9206

[bujjibabukatta]

It looks like you're trying to run data quality checks on a CSV file (employee data). Soda Core v4 doesn't read CSV files directly, but you can do this easily using the DuckDB connector — DuckDB can query CSV files natively.
Here's how:

1. Install:
   pip install soda-duckdb

2. Data source config (datasource.yml):
   name: my_duckdb
   type: duckdb
   connection:
   database: ":memory:"

3. Contract (contract.yml):
   dataset: read_csv('employees.csv')
   columns:

• name: employeeNumber
• name: lastName
• name: firstName
  checks:
• type: row_count
  must_be_greater_than: 0
• type: missing
  column: email
  must_be: 0

4. Run:
   soda contract verify -ds datasource.yml -c contract.yml

This will read your CSV and run the checks without needing a database. Hope this helps!