Hi there,
I have started using BI engine for one of the projects and when i ran a query recently i noticed that it did not utilize the BI engine and instead it's showing this message - " Cannot broadcast table X: number of files 100 > supported limit of 20."
The query contains a left join to table X.
I am on a flat-rate pricing with a reservation of 10GB. i did not specify any preferred tables.
Could someone please explain me the reason in a bit more detail and what i can do to make my query utilize the BI engine?
LinkedIn
Twitter
