What are the expected data types in schema.yml fille

In-Depth Discussions
,
1

When creating a schema.yml file for a data model, I’m always confused about the expected data_type values for the format like below. Do we have a list of suggested types, and does it vary on different query engines? Thanks!

    columns:
      - name: event_timestamp
        data_type: TIMESTAMP
        description: ""
2

Did you get any conclusion regarding this information?
I can find several examples online, but they are not consistent.
Thanks

3

I haven’t, I’ve been using the data type values compatible to the underlying database (BigQuery, etc.) and it seems working just fine. With the introduction of model constraints and contract, I believe dbt is indeed validating the data types defined in schema.yml with the underlying DB

4

Thanks for the reply, I will check it out.

At this moment, I’m using generic types in the generator (string, decimal, etc…), as soon as I finish the generator I will try it and check if they are valid or not.

Thanks again for your reply.