Max number of columns in a dataset?

AJ2020
AJ2020 βšͺ️

Hi,

What is the maximum count of columns for a dataset?

Thanks!

Comments

  • jaeW_at_Onyx
    jaeW_at_Onyx Budapest / Portland, OR 🟀

    @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?


    Jae Wilson
    Check out my Domo Training YouTube Channel

    **Say "Thanks" by clicking the heart in the post that helped you.
    **Please mark the post that solves your problem by clicking on "Accept as Solution"