[quantadev]

Having proper constraints and foreign keys that are clear is generally all that's needed in my experience. Are you sure your tables have well defined constraints, so that the AI can be absolutely 100% sure how everything links up? SQL is very precise, but only if you're utilizing constraints and foreign key definitions well.

[carderne]

It’s BigQuery, so it likely won’t have any of these.

[quantadev]

BigQuery supports all those SQL things I mentioned.

[carderne]

I’m just saying it’s likely they aren’t using them. But clearly you should if you want LLMs to do anything useful.