{ "csv_file": { "filename": "sampleTab.csv", "file_size": 276, "record_delimiter": "," }, "data_manipulations": { "replace_nulls": true, "replace_quotes": true }, "csv_headers": { "year_id": { "datatype": "int", "datatype_analysis": { "int": 4 }, "distinct_values": [ 1997, 1999, 1996 ] }, "make_id": { "datatype": "string", "datatype_analysis": { "string": 4 }, "distinct_values": [ "Ford", "Chevy", "Jeep" ] }, "model_id": { "datatype": "string", "datatype_analysis": { "string": 4 }, "distinct_values": "3+" }, "description_id": { "datatype": "string", "datatype_analysis": { "string": 2 }, "distinct_values": [ "ac, abs, moon", "MUST SELL!air, moon roof, loaded" ], "nullable": true }, "price_id": { "datatype": "float", "datatype_analysis": { "float": 4 }, "distinct_values": "3+" } }, "sql": { "pg": { "create_query": "create table sampletab.csv ( year_id int not null, make_id varchar(255) not null, model_id varchar(255) not null, description_id varchar(255), price_id float not null);", "import_query": "COPY sampletab.csv FROM '/home/avinash/Desktop/csv-import-analyzer/lib/sampleTab.csv' HEADER DELIMITER ',' CSV NULL AS 'NULL';" }, "mysql": { "create_query": "create table sampletab.csv ( year_id int not null, make_id varchar(255) not null, model_id varchar(255) not null, description_id varchar(255), price_id float not null);", "import_query": "COPY sampletab.csv FROM '/home/avinash/Desktop/csv-import-analyzer/lib/sampleTab.csv' HEADER DELIMITER ',' CSV NULL AS 'NULL';" } } }