import.rb

connection = Cequel.connect(...)
table = connection.schema.read_table(:assessors)

my_data.each do |row|
  typecast_row = {}
  row.each_pair do |column_name, value|
    typecast_row[column_name] = table.column(column_name).cast(value)
  end
  connection[:assessors].insert(typecast_row)
end