Terabyte Click Logs from Criteo

Download the data from http://labs.criteo.com/downloads/download-terabyte-click-logs/

Create a table to import the log to:

Insert the data:

Create a table for the converted data:

Transform data from the raw log and put it in the second table: