Hi, I'm using Windows embedded to connect to S3, but am having querying using ODBC
The ODBC connection works (connection string below) CastAnyToVarchar=true;Catalog=s3citibike;Schema=default;HandshakeTimeout=5;QueryTimeout=180;TimestampTZDisplayTimezone=local;NumberOfPrefetchBuffers=5;StringColumnLength=1024;ConvertToCast=false Using Drill Explorer (direct to Drillbit), I can see the files in s3citibike.default, and view the data (see attached image) but for some reason I cannot see my files when using ODBC with another client such as Excel. I can query using sqline, for example the bellow returns the dataset SELECT * FROM `s3citibike`.`default`.`./201307-citibike-tripdata.csv` LIMIT 100; I'm kind of guessing I'm just not specifying the folder path correctly, but I've been looking around for a while, tried Catalog = DRILL, schema = s3citibike.default, no avail. I'd try the drill-jdbc-all-1.10.0.jar JDBC driver for my client, but understand it doesn't work with embedded Windows Can anyone see where I'm going wrong? Thanks and regards, Jack