Package fails to inference type of column for PostgreSQL data_types about cube_dbt

[jronsse]

Hello !

We kinda have the same issue:

Context

We are currently experimenting with Cube Cloud after a month or so testing things out with Cube Core. We plan on using dbt to generate our models.
We recently updated our process and now include columns' data_type in the generated YAML model files. We use dbt-codegen: generate_model_yaml to generate the model.
We use Databricks SQL Serverless as our data warehouse

Issue encountered

The resulting manifest.json mentions data types that are not supported by cube-dbt:

"store_indice": {
  "name": "store_indice",
  "description": "",
  "meta": {},
  "data_type": "double",
  "constraints": [],
  "quote": null,
  "tags": []
},

Here's a list of datatypes that we might encounter in the manifest

@igorlukanin Would you agree that adding those type aliases to cube-dbt is the way to go? If so I'd be happy to create a PR.

Thanks !