Fabricate - Create Table using SQL DDL - Column limit?

#1

When using the ‘Import tables and relationships from a SQL DDL script:’ within Add Table, I’m using a CREATE table_name script, but have found that it seems to fail when trying to create an excessive amount of columns (in total, I’m trying to create a table with 88 columns).

It seems to work with approx 50-60.

Is there a limit?

Thanks

#2

My guess is you’re probably hitting a timeout when Fabricate uses AI to derive the columns and generators. I’ll dive into this later today and provide an update.

#3

I’ve bumped up the timeout by 4x. Can you try again and let me know if you still run into this issue?

1 Like
#4

Fantastic, thanks, that seemed to sort it. I’ll be making a few adjustments to get the data quality more accurate, would it be okay to leave the timeout bump increased for a while?

#5

There’s no reason to roll it back. The original timeout was arbitrary anyway. So you should expect it to say the same going forward.

#6

Perfect, thanks so much for the quick reply - fantastic tool you’ve got here, revolutionised my workflow!

1 Like