Error Handling in Load Data

Hi All, I’m using ERROR HANDLE in Load data script. But the data errors are not getting written in information_schema.load_data_errors.

Do I need write access?

Hi @saro54377! Welcome to the MemSQL Forums! Sorry it took us so long to answer.

There are some internal row-level security screenings happening on information_schema.load_data_errors. Basically, you can only see rows in load_data_errors if you have insert privileges on all databases, or insert privileges on the database you’re loading into.

The intent was that you need whatever privileges are required to perform the load data in the first place to see the error for that load.

So, double-check your permissions, or try using a more privileged account to see the errors.