I am new to Matillion, I am trying to download the sample data from http:/data.dft.gov.uk/road-accidents-safety-data/RoadSafetyData_Vehicles_2015.zip put into s3 bucket.
I am getting the following error message "protocol = http host = null" Could you pls help
3 Community Answers
David Langton —
The URL you have there is missing a ‘/’ – it should be http://data.dft.gov.uk/road-accidents-safety-data/RoadSafetyData_Vehicles_2015.zip.
My browser doesn’t seem to care and corrects it for me, but Matillion doesn’t. It leads to a failure in parsing the URL and not finding the host part. But once that’s solved, using the S3 Put Component to unpack the Zip onto S3. After that, the S3 Load Generator can generate a “Create Table” and “S3 Load” components to load the file – I’ve attached the job I just created.