Field types using postgres

#1

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?

#2

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

#3

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

#4

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