Consistency of Field Names for PostreSQL Gateway and Direct Query

Related products: API and SDKs

In PostgreSQL gateway the datapoints use the field name “time_stamp”.  In the PostgreSQL connection used by direct query the field is called “timestamp”.  As much as possible, can these field names across these providers be consistent with one another?

NewGathering Interest

@Ben Brandt this is unfortunate that we have different names for the same thing, however I don’t think it’s feasible to do at this point as it would introduce a breaking change,
It should, however, be possible to alias the column in PostgreSQL gateway while selecting it?


Yes.  Maybe a simple set of views is all that is needed to standardize across PostgreSQL Gateway, Direct Query, and the SQL Transformation features.