Max number of columns in a dataset?

AJ2020 · 2022-05-13T23:02:46+00:00

There was an error rendering this rich post.

AJ2020

Hi,

What is the maximum count of columns for a dataset?

Thanks!

Find more posts tagged with

Comments

jaeW_at_Onyx

@AJ2020 this is an interesting question.

are you asking for max columns you can read in via a connector? or maximum columns you can create in ETL?

I believe the max columns is 1024 but i'm probably wrong.

More importantly... why are you hitting the max number of columns? Could you shape the data in a way that's more useable? (particularly if you're working with a connector that adds columns based off of distinct values in a JSON array, you'll want to reconsider b/c from day to day the shape of the dataset could change).

i believe Domo support can lift an arbitrary limit ... but again, why would you have a multi-hundred-column dataset and more importantly could you use it in a way that makes sense?

AJ2020

Thanks @jaeW_at_Onyx !

Agreed, big datasets get unwieldy.

It was just a general knowledge question. Our SQL table limit is 1,000 and I was curious what Domo's was.

Thanks! 😀

AJ2020

Where did the "accept as solution" button go? I don't see it.