SQLITE limitation - number of fields

Hi folks,

Anyone know what the max number of fields you can have in a SQLITE database? Google provideds mixed messages. Whatever it is, anyway to work around it in Alteryx? We want to put the final data for a predicive model into one table. But it was requested for it to be de-normalized, resulting in a large number of fields, so I was curious.

Thanks.

Database Connection

Accepted answers

PeterS

Hello Michael,

After checking with our developers, the inability to export more than 999 fields to an SQLite database is due to a limit that is hardcoded into the SQLite driver. Unfortuantely there are no work arounds.

All comments

mbarone

Just tested it and it looks like it's 999 for the max fields. From what I saw on Google, the default limit is 2000. Why is Alteryx only 999?

I know everyone's dying to know - why the heck would you need more than 999 fields????

Short answer --- it's significanlty faster to run some algorithms on one "huge-number-of-fields" table, than to join hundreds of smaller tables, and then run the algorithms.

PeterS

Hello Michael,

Quick Links

This months top contributors

FláviaB 262

caltang 177

DanM 167

IraWatt 157

gawa 157