Field types using postgres

Hello, I have a problem with the field types, I’m using postgres with the redshift provider and in the database some fields are real type, but they come in the metadata like ATTRIBUTES, and because they are numbers I need them with a numerical type, is this an issue in the toolkit?

1 Like

I see, no worries we are working on that, But meanwhile, there is a workaround, You can assign the NUMBER type to these fields using the metadata config, you can do something like this:

"public.your_table": {
      "fields": {
        "field1": {
            "type": "NUMBER"
        },
	"field2": {
            "type": "NUMBER"
        },
	"field3": {
            "type": "NUMBER"
        }
      }
    }

Including this in your metadata config will solve the problem

1 Like

Thanks, it works, but I think this is something temporary, right?

1 Like

Yes, we already fix this, so don’t worry about it