Maximum of columns for profiling

jason.gregg · January 17, 2020, 10:26pm

I have a spreadsheet with over 2000 columns where I am trying to profile several rows of data. What is the maximum number of columns that are supported for profiling?

dan · January 20, 2020, 1:04pm

Hi Jason,
have you already tried it? We haven't tested the maximum number of columns for profiling yet.

dan · January 20, 2020, 2:04pm

Ok, tested now. We have a limit of 1024 columns for Toad import. And with 1024 columns it works fine. I was testing on SQL Server with 10 rows generated for 1024 columns.