@DanielW 

You're welcome! Yes, that's absolutely an option for your integer and bigint columns. Using format: number without explicitly specifying a type can work well for handling numeric values from Databricks in Power Apps.

Here's how you could define those columns in your Swagger:

In yaml file

testint:
format: number
description: "Integer column from Databricks"

bigintcolumn:
format: number
description: "BigInt column from Databricks"

If you're still getting any issues with very large numbers (particularly with bigint columns that
might exceed JavaScript's number precision), you could also try:

bigintcolumn:
type: string
format: number
x-ms-powerApps-display-format: number

This hybrid approach tells Power Apps to treat the value as a number for display purposes while still accepting the string representation from the API.
I'm glad to hear the format: number approach is already working for your number columns! This should work equally well for your integer and bigint columns as long as they're within the standard numeric range that JavaScript/Power
Apps can handle (approximately ±9,007,199,254,740,991).