Name is required.
Email address is required.
Invalid email address
Answer is required.
Exceeding max length of 5KB

S3 put object

Hi ,

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

Thanks
Ganesh

3 Community Answers

Matillion Agent  

David Langton —

Hi Ganesh,

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.

Regards,
David


Matillion Agent  

David Langton —

Hi Ganesh,

The job can be downloaded here: https://s3-eu-west-1.amazonaws.com/matillion-public/support_cases/load-road-safety.json

Regards


Ganesh Arunasalam —

Hi David,

Thanks a lot for your help !!!

Regards
Ganesh

Post Your Community Answer

To add an answer please login